| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
| Cc: | Laurent ROCHE <laurent_roche(at)yahoo(dot)com>, Andreas Kretschmer <akretschmer(at)spamfence(dot)net>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Re : pg_dump SERIAL and SEQUENCE |
| Date: | 2007-10-18 20:02:25 |
| Message-ID: | 27886.1192737745@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Alvaro Herrera <alvherre(at)commandprompt(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ralph Smith | 2007-10-18 20:19:27 | pg_dumpall's subseq IMPORT ERRORS |
| Previous Message | Ralph Smith | 2007-10-18 19:55:29 | Did pg_dumpall and imported, NEED TO START OVER |