-tfo
-- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005
On Nov 19, 2004, at 7:24 PM, Tom Lane wrote:
Steve Crawford <[EMAIL PROTECTED]> writes:This appears to have all gone well execpt that one view is missing. I've restored that view by hand but am curious if this is a PG bug or failure of the nut behind the wheel.
The view involves the union of many tables and its creation failed because creation of one of the tables does not take place until later in the dump file.
This is a longstanding pg_dump bug: it's not very bright about order of
creation of objects. (In this case I surmise that you created the view,
and later altered it to reference a table that didn't exist when the
view was originally created.)
As of 8.0 pg_dump examines dependency information and should theoretically
always get this right, but in prior versions it's a real hazard.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
