Re: [HACKERS] Sequences....

Ryan Bradetich wrote:
> > Back to my origional point .. I think we need another system table to map the
> > sequence oid to the table's oid.  I've noticed this done with the inheritance,
> > indexes, etc ... but I don't see a pg_sequence table.

Sounds good.

As long as a sequence can point to more than 
one table/column combination.

Or, I guess, you can have the relationship 1-1 for
the SERIAL type, but this should not prevent using
sequences across more than one table if you don't use SERIAL.
I often use a sequence for 3 or more tables in a system
so that I can use 'generic' functions on the tables
and produce reports without conficting primary keys..

:) Clark