From: | Steve Lane <slane(at)moyergroup(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Working with foreign key constraints |
Date: | 2002-10-19 19:36:13 |
Message-ID: | B9D71E5D.1788B%slane@moyergroup.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
All:
A couple of quick questions about foreign key constraints.
Any good way to view them in pgsql? A simple \dt will show me indexes, but
no constraints.
I understand that they're implemented with triggers. I've seen varying
accounts of how many. Two? Or three? I'm trying to drop some FK constraints,
with no luck. Dropping the two likely-looking triggers didn't do it -- still
got integrity violations on certain operations.
Any good source of data for this online? Did not find much at
techdocs.postgresql.org, or at least I looked in the wrong place.
Thanks,
Steve
=======================================================
Steve Lane
Vice President
The Moyer Group
833 West Chicago Ave Suite 203
Voice: (312) 433-2421 Email: slane(at)moyergroup(dot)com
Fax: (312) 850-3930 Web: http://www.moyergroup.com
=======================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Jais | 2002-10-19 21:03:12 | red hat graphical tools: rpms or tgz ?? |
Previous Message | Marcin Owsiany | 2002-10-19 17:17:13 | Security implications of (plpgsql) functions |