pg_dump: Sorted output, referential integrity statements
От | Christof Petig |
---|---|
Тема | pg_dump: Sorted output, referential integrity statements |
Дата | |
Msg-id | 3C0F50EC.D57AC8B7@petig-baender.de обсуждение исходный текст |
Ответы |
Re: pg_dump: Sorted output, referential integrity statements
Re: pg_dump: Sorted output, referential integrity |
Список | 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
В списке pgsql-hackers по дате отправления: