| From: | Rod Taylor <rbt(at)rbt(dot)ca> |
|---|---|
| To: | Dennis Björklund <db(at)zigo(dot)dhs(dot)org> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Dunstan <andrew(at)dunslane(dot)net>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>, Jonathan Gardner <jgardner(at)jonathangardner(dot)net> |
| Subject: | Re: ALTER TABLE ... TO ... to change related names |
| Date: | 2003-08-30 23:12:01 |
| Message-ID: | 1062285120.83670.50.camel@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> > Backwards compatibility, if nothing else. Are you prepared to break
> > every existing dump file that has
> > CREATE TABLE ser (f1 serial);
> > SELECT pg_catalog.setval('ser_f1_seq', 1, false);
>
> I think breaking backward compability not always bad. If
Replacing SERIAL with a GENERATOR make sense as the definition of an
identity (including current count) is treated as an attribute of the
column for create table.
SQL2003 GENERATOR / IDENTITIES (based on DB2 and MSSQL, I believe) have
greater functionality than SERIAL.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gaetano Mendola | 2003-08-30 23:27:49 | Re: SetVariable |
| Previous Message | Dennis Björklund | 2003-08-30 22:55:15 | Re: ALTER TABLE ... TO ... to change related names |