Re: Reconstructing FKs in pg_dump

Поиск
Список
Период
Сортировка
От Matthew T. O'Connor
Тема Re: Reconstructing FKs in pg_dump
Дата
Msg-id 008b01c2669b$9d369800$0a00a8c0@zeut2k
обсуждение исходный текст
Ответ на Reconstructing FKs in pg_dump  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Reconstructing FKs in pg_dump  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
From: "Tom Lane" <tgl@sss.pgh.pa.us>
> However, if we are going to put that kind of knowledge into pg_dump,
> it would only be a small further step to have it dump these triggers
> as ALTER TABLE ADD CONSTRAINT commands instead.  Which would be a lot
> better for forward compatibility than dumping the raw triggers.

There was some talk of adding Rod Taylor's identifies upgrade script to
contrib, or mentioning it in the release.  I think that it upgrades Foreign
key, Unique, and Serial constraints, is that relevant here?  Could it be
used (or modified) to handle this situation?  Just a thought.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Cause of missing pg_clog files
Следующее
От: Alvaro Herrera
Дата:
Сообщение: version mismatch detection doesn't work