[isf-wifidog] can't login

[Benoit Grégoire]

On Sunday 13 July 2008, Wichert Akkerman wrote:
> > It seems that postgresql 7.4 doesn't support changing column types. 
> > Unless someone wants to send the patch to rewrite this upgrade as a
> > RENAME/ADD/COPY chain, this is definitely a won't fix.
>
> There is no need to copy the whole table around, you can do it on just
> the column you want to change. Something like:
>
> BEGIN
> ALTER TABLE x RENAME col TO tmpname;
> ALTER TABLE x ADD COLUMN col newtype;
> UPDATE x SET col=tmpname;
> ALTER TABLE x DROP COLUMN tmpname;
> COMMIT;

That's what I mean by RENAME/ADD/COPY.

-- 
Benoit Grégoire
Technologies Coeus inc.
-------------- section suivante --------------
Une pièce jointe non texte a été nettoyée...
Nom: non disponible
Type: application/pgp-signature
Taille: 189 octets
Desc: This is a digitally signed message part.
Url: http://listes.ilesansfil.org/pipermail/wifidog/attachments/20080713/1a38d9db/attachment.pgp