| From: | Jeff Boes <jboes(at)nexcerpt(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | pg_constraint missing many entries? |
| Date: | 2003-11-17 20:20:54 |
| Message-ID: | 0687bc5bd66d644bc992c688abf337b0@news.teranews.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lynn.Tilby | 2003-11-17 20:39:02 | AUTOCOMMIT didn't work... |
| Previous Message | Jeremy Hefner | 2003-11-17 20:14:32 | snort, acid and postgres |