Re: Constraints & pg_dump

Tom,

> Isn't this already solved by dumping in dependency order?
>
> regards, tom lane

Nope. Problem is, the table depends on the function, and the function
depends on the table. pg_dump (in 7.4.1, at least) will dump the table
first, *with the constraint*, and then the function ... causing table
creation to fail.

And this isn't come cross-table function either; the constraint that they're
implementing is partial uniqueness, which is appropriate for a constraint.

I personally think that the simplest way to do this ... and deal with most
custom-function-constraint issues ... is to push all constraints containing a
user-defined function to the end of the file with the foriegn keys.

(this is for the Bricolage project)

--
Josh Berkus
Aglio Database Solutions
San Francisco