pg_dump: Sorted output, referential integrity statements

From: Christof Petig <christof(at)petig-baender(dot)de>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_dump: Sorted output, referential integrity statements
Date: 2001-12-06 11:05:16
Message-ID: 3C0F50EC.D57AC8B7@petig-baender.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

While daily using pg_dump for a while the need for the following
features grew significantly.
I finally came to the point of implementing them myself ;-)

- pg_dump outputs the data unsorted but to manage the data in a version
control system you need it consistently sorted. So a flag to sort by
either primary key or left to right would be of great value. (--sorted
?)

- pg_dump outputs referential constraints as 3 triggers (near to two
different tables) per constraint. A mode which outputs the original
statement (alter table ... add constraint) would be more sql standard
conformant, portable and readable. But ... you might get into trouble if
the referenced table creation command is output later.

If we call this switch --sql-standard it might also prefer the short
(standard compliant) form for index creation [create index X on Y(Z,W)]
and some other things.

So, I'm kindly asking for your opinion regarding this two features.
Does anybody plan to implement them? Do you have reasons against?

Christof

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gunnar Rønning 2001-12-06 12:32:42 Re: java stored procedures
Previous Message Hannu Krosing 2001-12-06 10:52:44 Re: Licensing