Re: pg_dump and DEFAULT column values - Mailing list pgsql-general

From Eric Ridge
Subject Re: pg_dump and DEFAULT column values
Date
Msg-id D3ADE25911614840BC69C72E3171E4ED028130@tcdiexch.tcdi.com
Whole thread Raw
In response to pg_dump and DEFAULT column values  ("Eric Ridge" <ebr@tcdi.com>)
List pgsql-general
> pg_dump has a hard time with circular dependencies :-(

but on the plus side, pg_dump is really fast!  much faster than dump
utilities of other databases I've seen.

> Have you considered using a sequence, rather than generating
> new values
> as shown above?  The approach you are using is extremely fragile:
> consider what happens if two backends try to insert at the same time.

a sequence it is!  thanks.

eric

pgsql-general by date:

Previous
From: jd@commandprompt.com (Joshua Drake)
Date:
Subject: Re: Sourceforge moving from PostgreSQL to Oracle
Next
From: "Eric Ridge"
Date:
Subject: Re: pg_dump and DEFAULT column values