| From: | Troels Arvin <troels(at)arvin(dot)dk> |
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: AUTO_INCREMENT patch |
| Date: | 2003-08-03 20:06:35 |
| Message-ID: | pan.2003.08.03.20.06.29.230448@arvin.dk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
On Sat, 02 Aug 2003 18:43:23 +0200, Dag-Erling Smørgrav wrote:
> It works by defining a new
> column constraint (CONSTR_AUTO_INCREMENT) which is handled specially
> by transformColumnDefinition() - after it has transformed SERIAL
> pseudo-types to the corresponding INT types
Beware that MySQL's AUTO_INCREMENT and PostgreSQL's SERIAL are not
equivalent.
See http://troels.arvin.dk/db/rdbms/#mix-identity
--
Greetings from Troels Arvin, Copenhagen, Denmark
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2003-08-03 21:56:15 | Re: concat_ws |
| Previous Message | Tom Lane | 2003-08-03 18:35:01 | Re: SQL2003 GENERATED ... AS ... syntax |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2003-08-04 03:04:11 | statement level trigger causes pltcl, plpython SIGSEGV |
| Previous Message | Tom Lane | 2003-08-03 15:45:53 | Re: 7.4 COPY BINARY Format Change |