pg_constraint missing many entries?

Поиск
Список
Период
Сортировка
От Jeff Boes
Тема pg_constraint missing many entries?
Дата
Msg-id 0687bc5bd66d644bc992c688abf337b0@news.teranews.com
обсуждение исходный текст
Ответы Re: pg_constraint missing many entries?  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
Almost all of my foreign key definitions are NOT present in
pg_constraint. However, they do exist as triggers. It appears that *new*
foreign keys, whether defined in new tables or added on via "ALTER
TABLE" commands, make it into pg_constraint, but the "old" stuff that
was present from before our 7.3 upgrade, exists only as triggers.

1) Is this a bug?

2) Is there any way to "refresh" pg_constraint? (I'm experimenting with
a tool that graphs a schema, and it needs a bit of code written to
determine from a table and column name whether that column is a foreign
key, and to what table. pg_constraint where contype = 'f' seems to be
the ticket, but on my database it's inadequate.)


--
Jeff Boes                                      vox 269.226.9550 ext 24
Database Engineer                                     fax 269.349.9076
Nexcerpt, Inc.                                 http://www.nexcerpt.com
            ...Nexcerpt... Extend your Expertise


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

Предыдущее
От: "Dann Corbit"
Дата:
Сообщение: Re: snort, acid and postgres
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: pg_constraint missing many entries?