Re: [HACKERS] Sequences.... - Mailing list pgsql-hackers

From Clark Evans
Subject Re: [HACKERS] Sequences....
Date
Msg-id 36EF3F47.7A4E2B41@manhattanproject.com
Whole thread Raw
In response to Re: [HACKERS] Sequences....  (Ryan Bradetich <rbrad@hpb50023.boi.hp.com>)
Responses Re: [HACKERS] Sequences....
Re: [HACKERS] Sequences....
List pgsql-hackers
Wow. Serious effort here.

Ryan Bradetich wrote:
> 1. Leave it as it is now.  It works, just explain to 
> people that sequences and tables are seperate entities, 
> and the serial type is just a shortcut.

I dislike this approach. It seems that it is hiding detail
that is necessary for proper maintence.  It isn't that
hard to type in the code.  IMHO, the shortcut causes more
confusion that it helps.  So, I propose a third option:

0.  Remove the SERIAL construct.


> 2. Create a new data type serial.  I haven't thought idea 
> out much, and need to investigate it some more. I'm thinking 
> it would be binary equivilent with the int4 type, and use 
> most of the existing seqence code, but not put the seqence 
> name entry in the pg_class system table.  Does this sound 
> like a feasible idea?

This dosn't sound all that bad... but I really
wonder what the advantage is. 

I vote for "0".  Sorry to dissappoint.

Clark


pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] Re: Developers Globe (FINAL)
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Subqueries and indexes