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
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 |