Skip site navigation (1) Skip section navigation (2)

Re: pg_dump and restore problem with function as DEFAULT-Constraint

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Markus Schulz <msc(at)antzsystem(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump and restore problem with function as DEFAULT-Constraint
Date: 2007-02-27 17:29:51
Message-ID: 21526.1172597391@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Markus Schulz <msc(at)antzsystem(dot)de> writes:
> i have some trouble with dumping and restoring a database with 
> postgresql 7.4.7-6sarge4 (debian sarge).
> ...
> What can i do to enforce the order of plpgsql functions prior to all 
> table structures?

Update to PG 8.x --- IIRC 8.0 was the first release in which pg_dump
really understood about dependencies properly.  7.x is dumping basically
in creation order, which falls down as soon as you start using ALTER
TABLE to create dependencies that weren't there originally.

			regards, tom lane

In response to

pgsql-general by date

Next:From: Richard HuxtonDate: 2007-02-27 17:47:46
Subject: Re: Building a record in a function
Previous:From: A. KretschmerDate: 2007-02-27 17:28:51
Subject: Re: pg_dump and restore problem with function as DEFAULT-Constraint

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group