Re: How foreign key info is stored

Ken Williams <ken@mathforum.org> writes:
> 1) In postgres 7.1.3, how can I access the foreign key relationships
> among tables?

The only way is to reverse-engineer it from the contents of pg_trigger.
7.3's contrib/adddepend will help you with this.

> 2) Is foreign key definition working properly via 'ALTER TABLE <table>
> ADD ...' in 7.3.2?

No, there's a bug there --- ALTER ADD COLUMN neglects to process any
foreign-key clauses you might have written.  This is fixed for 7.3.3.

            regards, tom lane