identify referential integrity triggers unassociated with foreign key constraints
От | Bill MacArthur |
---|---|
Тема | identify referential integrity triggers unassociated with foreign key constraints |
Дата | |
Msg-id | 4B291CC3.7080903@dhs-club.com обсуждение исходный текст |
Ответы |
Re: identify referential integrity triggers unassociated with foreign key constraints
|
Список | pgsql-admin |
Hello, We started using Postgres back around 7.1. We've done dump and reloads to get us up to where we are now at 8.1. Over time it would seem that the guts of foreign key constraints have changed, for the better. Soon we want to move to thelatest version, but in the process, I would like to update all the old style "foreign keys" to the newest. By old style,I mean we have RI triggers on various tables like "RI_ConstraintTrigger_3495148". In pgadmin, these do not show upas triggers, neither do they show up as foreign keys as some of the system table relationships that exist now for identifyingthese sort of things did not exist when these "foreign keys" were first setup. (These constraints still work,you just can't tell they are they using pgadmin) Using \d tablename shows them in a list of triggers but not as Foreign-keyconstraints. Occasionally I have taken to dropping some of these triggers and mucking with the system tables like pg_trigger and so forth,but those experiences are horrid. Things have never been hosed, but I know there has to be a better way. What I would like to do is to identify these almost invisible "foreign key" triggers so that they can be dropped sanely andthen create new, named constraints can be identified using ordinary tools. Is this possible? Many thanks, Bill MacArthur
В списке pgsql-admin по дате отправления: