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
