| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | Justin <justin(at)emproshunts(dot)com>, Edward Blake <comedian(dot)watchman(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: MySQL to Postgres question |
| Date: | 2008-03-21 17:20:56 |
| Message-ID: | 26707.1206120056@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
>> Why????
> I am not sure about 8.3 but certainly earlier releases of PostgreSQL
> would have specific dependency issues when a sequence was applied to a
> a column after the fact, versus using the serial or bigserial
> psuedo-types.
As of (I think) 8.2, you can use ALTER SEQUENCE OWNED BY to manage
the dependency. In earlier releases it's true that you couldn't
exactly duplicate what SERIAL did (at least not without manual
catalog hacking), but now it truly is just a macro for things you
can do with SQL commands.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Smith | 2008-03-21 17:28:53 | Re: [postgis-users] how many min. floating-points? |
| Previous Message | Joshua D. Drake | 2008-03-21 17:18:28 | Re: Client-requested cast mode to emulate Pg8.2 on v8.3 |