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 [EMAIL PROTECTED] http://funkturm.homeip.net/~peter ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
