From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Sergio Gabriel Rodriguez" <sgrodriguez(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: pg_dump/pg_restore |
Date: | 2008-04-08 21:30:05 |
Message-ID: | 8490.1207690205@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
"Sergio Gabriel Rodriguez" <sgrodriguez(at)gmail(dot)com> writes:
> I'm using postgresql 7.4, I have a problem with pg_dump/pg_restore. I
> want to back and restore only one schema from my db (I did it), but
> when I restore it, postgresql found errors in some views, this ones
> needs of others which can't be found because the script will generate
> them later. How can I make an orderer sql dump???
Switch to a newer PG version. If memory serves, 8.0 was the first
version in which pg_dump paid attention to dependencies rather than just
the order of original creation of views. In 7.x it wasn't hard to
cause problems by doing CREATE OR REPLACE VIEW.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Ashish Sharma | 2008-04-09 08:10:55 | SQL fast in PSQL, very slow using MS.NET driver |
Previous Message | Tino Schwarze | 2008-04-08 20:44:01 | Re: pg_dump/pg_restore |