Removing constraints

From: "Nathan Barnett" <nbarnett(at)cellularphones(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Removing constraints
Date: 2000-11-13 16:15:09
Message-ID: 71975481CD04D4118E57004033A2596E0DFB1F@ip205.82.136.216.in-addr.arpa
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

There is a constraint on my database that was created as part of a foreign
key. When I dropped the foreign key index, the constraint still remained
behind. How can I delete this constraint? It is unnamed and I figure I
need to remove some stuff from the system tables, but I don't know which
ones or what to delete. I'm using PostgreSQL v7.0.2. I looked through the
user guides, but couldn't find this info there.

---------------------------------------------
Nathan Barnett

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-11-13 16:18:05 Re: PL/Perl
Previous Message Poul L. Christiansen 2000-11-13 15:58:57 Re: PHPBuilder article -- Postgres vs MySQL