Interesting, How would I specify the order of the tables on the commandline
To Thomas: I decided to separate the schema/data export/import to make sure the schema was at least being created correctly... How can I export one table by itself? Not just table, but a view/trigger, etc... Is it even possible to export them separately? -Jonathan <quote who="Chris Travers"> > Thomas F. O'Connell wrote: > >> >> >> Jonathan, >> >> The implicit indexes are no big deal; they're just a sign of indexes >> getting created by PRIMARY KEYs on your tables. >> >> I'm not sure why you're getting errors. Is there a reason you did the >> schema dump separately from the data dump rather than a monolithic >> dump/restore? >> > I seem to remember encountering an issue some time ago with pg_dump > dumping tables in an order that prevented them from being reloaded. > > The solution was to specify the order of the tables in the commandline. > > Hope this helps. > Chris Travers > Metatron Technology Consulting > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match