Luís Sousa wrote: > Hi all, > > I'm using PostgreSQL 7.4.7-6sarge2 (debian) > > Using the schema below, doing a pg_dump -Fc, delete all data, and a > pg_restore -a, the sequence of inserting data isn't correct issuing an > error. > Could this be a bug? Not a bug -- rather a known deficiency. pg_dump 8.0 and beyond knows how to sort stuff so that these problems do not occur, but 7.4 doesn't. The typical workaround was to use pg_restore -l/-L to generate the list of objects to restore and sort them appropiately, then do the actual restore. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
