Re: Making serial survive pg_dump - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: Making serial survive pg_dump
Date
Msg-id 077e01c213f8$52575ef0$fe01a8c0@jester
Whole thread Raw
In response to Re: Making serial survive pg_dump  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
> > I think that when SERIAL is used, the sequence should be tied
> > inextricably to the table which created it, and it should be
hidden from
> > use for other purposes (perhaps similar to the way a toast table
is). If
> > you *want* to use a sequence across several tables, then you don't
use
> > SERIAL, you create a sequence.
>
> Agreed.  Maybe an extra column in pg_attribute or something?

Since no other sequence will depend on a column, I could base it on
that.



pgsql-hackers by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: FEATURE REQUEST - More dynamic date type?
Next
From: Rocco Altier
Date:
Subject: Re: Non-standard feature request