Re: ALTER TABLE ... TO ... to change related names - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: ALTER TABLE ... TO ... to change related names
Date
Msg-id 1062285120.83670.50.camel@jester
Whole thread Raw
In response to Re: ALTER TABLE ... TO ... to change related names  (Dennis Björklund <db@zigo.dhs.org>)
List 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.

pgsql-hackers by date:

Previous
From: Dennis Björklund
Date:
Subject: Re: ALTER TABLE ... TO ... to change related names
Next
From: "Gaetano Mendola"
Date:
Subject: Re: SetVariable