Ralf Miller writes:
> The example shows that the column number of type serial is incremented
> as if the preceding insert-statement was successfull, even if it was
> not.
The serial type does not provide consecutive numbers, only unique ones.
> The SEQUENCE corresponding to a column of type serial is not beeing
> droped automatically when the table containing the serial-column is
> droped. Does it make sense to store a sequence without a corresponding
> table ?
Possibly you want to use it for more than one table.
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter