Alvaro Herrera <alvherre@commandprompt.com> writes:
> Laurent ROCHE wrote:
>> Yep, of course but what's the situation for people using 8.1 and
>> pg_dump that does not generate code with SERIAL ?
> They grab 8.2's pg_dump and connect with it to their 8.1 server, to
> generate a dump that does.
Actually, I bet the OP's problem is exactly that he did that already.
8.1 pg_dump *will* generate a SERIAL column definition, if it sees
that the table being dumped was made that way. 8.2 prefers the OWNED BY
route (for good reasons btw).
regards, tom lane