"Nikolay Samokhvalov" <samokhvalov@xxxxxxxxx> writes:
> My suggestions are:
> - do not use SERIAL at all. Always create sequence manually and then
> write DEFAULT expr.
Not an unreasonable suggestion.
> - when DEFAULT expr is simple nextval('...') you should make fool
> from pg_dump - write "DEFAULT nextval('...') + 0" - that dummy "+ 0"
> will prevent pg_dump from making conclusion that this is SERIAL...
This is completely silly, however. pg_dump does not pay any attention
to the contents of the default when determining if something is a SERIAL.
(One could argue that that's exactly the problem ...)
regards, tom lane
