Re: [ADMIN] pg_dump object dump-order; Part II

2007-08-28 Thread Tom Lane
KL <[EMAIL PROTECTED]> writes: > Right, the error occurs in exactly such a simple > example, but I'm not above to provide details galore ... This seems to be the relevant detail: > CREATE TABLE event ( > event_id integer DEFAULT nextval('event_id_seq') NOT NULL, This isn't what you showed be

[ADMIN] pg_dump object dump-order; Part II

2007-08-28 Thread KL
Greetings In advance I'd like to apoligize to start a new thread, but I couldn't figure out how to reply to Mr. Lane's thread-sensitive. Mr. Lane kindly replied (in a highly appreciated patronizing way :) I will point out, however, that the given script does not in fact fail to load in any Pos

Re: [ADMIN] pg_dump object dump-order

2007-08-28 Thread Tom Lane
KL <[EMAIL PROTECTED]> writes: > pg_dump seems to dump objects strictly alphabetically, No, it doesn't ... at least not if you are running 8.0 or later. It looks at dependencies to see what has to be dumped first. (It does prefer alpha order when there's no dependency constraint.) There are vario

[ADMIN] pg_dump object dump-order

2007-08-28 Thread KL
Greetings I'm working with PostgreSQL for quite some time now but only yesterday ran into a specific problem, as - so far - I have always used customized backup/restore-scripts. PROBLEM: pg_dump seems to dump objects strictly alphabetically, I presume. Hence a table "events" is always dumped _b