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

From Christopher Kings-Lynne
Subject Re: Making serial survive pg_dump
Date
Msg-id GNELIHDDFBOCMGBFGEFOKEMACCAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Making serial survive pg_dump  ("Rod Taylor" <rbt@zort.ca>)
List pgsql-hackers
> Currently serial is dumped as a sequence and appropriate default
> statement.
>
> With my upcoming dependency patch serials depend on the appropriate
> column.  Drop the column (or table) and the sequence goes with it.
> The depencency information does not survive the pg_dump / restore
> process however as it's recreated as the table and individual
> sequence.

What happens is the sequence is shared between several tables (eg. invoice
numbers or something)

Chris



pgsql-hackers by date:

Previous
From: Bear Giles
Date:
Subject: Re: First cut at SSL documentation
Next
From: "Rod Taylor"
Date:
Subject: Re: Making serial survive pg_dump