| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Adam Rich <adam(dot)r(at)sbcglobal(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: MySQL to Postgres question |
| Date: | 2008-03-23 02:31:58 |
| Message-ID: | 20080323023158.GI13206@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Adam Rich wrote:
> > The short answer is that Adam's statement is wrong, or at least
> > misleading.
>
> Sorry Tom, I wasn't trying to do either. Joshua Drake (who I understand
> to be a reliable source of postgresql information) said that applying
> a sequence to a column after creation created issues, versus using the
> serial type which did not.
He is wrong in that you *can* attach the same information that SERIAL
does if you use ALTER SEQUENCE .. OWNED BY after the fact. If you
don't, then he's right. pg_dump does use the OWNED BY stuff.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | chuckee | 2008-03-23 02:32:12 | table size and storage location |
| Previous Message | Joshua D. Drake | 2008-03-23 02:20:44 | Re: MySQL to Postgres question |