Jaime Casanova wrote:
> Hi,
>
> i'm looking for some item i can do and that have enough consensus to
> make it worth the effort... :)
>
> * Have sequence dependency track use of DEFAULT sequences, seqname.nextval?
>
> what this means? i don't understand it...
The idea is to automatically add a dependency of the sequence on the
table using it as a default.
> * %Disallow changing default expression of a SERIAL column?
>
> why? a SERIAL is not really a datatype but a short-hand to make an
> integer with a nextval's sequence as default... so why making them
> both (the integer type and the nextval's sequence as default) act as
> if it were a single unit?
> Actually, i have dropped sequences created with SERIAL because i found
> that was better to me to make it manually...
Well, SERIAL adds dependency information, so if you drop the table, the
sequence is dropped. If you change the default for a serial type, the
dependency on the sequence should go away.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073