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
|
| Список | 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 по дате отправления: