Re: Extended SERIAL parsing - Mailing list pgsql-hackers

From Jim C. Nasby
Subject Re: Extended SERIAL parsing
Date
Msg-id 20060612151050.GQ34196@pervasive.com
Whole thread Raw
In response to Re: Extended SERIAL parsing  (Böszörményi Zoltán <zboszor@dunaweb.hu>)
Responses Re: Extended SERIAL parsing  (Zoltan Boszormenyi <zboszor@dunaweb.hu>)
List pgsql-hackers
On Mon, Jun 12, 2006 at 02:27:31PM +0200, B?sz?rm?nyi Zolt?n wrote:
> > Zoltan Boszormenyi <zboszor@dunaweb.hu> writes:
> >> after some experimentation, I came up with the attached patch,
> >> which implements parsing the following SERIAL types:
> >
> > As has been pointed out before, it would be a seriously bad idea to
> > implement the SQL syntax for identity columns without matching the
> > SQL semantics for them.  That would leave us behind the eight-ball
> > when we wanted to implement the SQL semantics.  Right now we have
> > a useful but non-standard semantics, and a useful but non-standard
> > syntax, and those two should stick together.
> 
> Well, I read all sections of 5WD-02-Foundation-2003-09.pdf
> where "identity" appears, here are the list of changes that will
> be needed for an identity column:

Have you read the archives on the recent discussions that have taken
place about whether SERIAL should be a black box or not? IIRC most of
this was all hashed out in that thread.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461


pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: postgresql and process titles
Next
From: Andrew Dunstan
Date:
Subject: Re: TODO: Add pg_get_acldef(), pg_get_typedefault(),