X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 0F095D1BAF8 for ; Sun, 11 Apr 2004 19:00:12 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 39675-10 for ; Sun, 11 Apr 2004 19:00:17 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 91DA1D1B9EB for ; Sun, 11 Apr 2004 19:00:09 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i3BM0Doo017190; Sun, 11 Apr 2004 18:00:13 -0400 (EDT) To: Bret Hughes Cc: Stephan Szabo , postgresql sql list Subject: Re: trigger/for key help In-reply-to: <1081711155.6399.165.camel@bretsony> References: <1081662204.6609.72.camel@bretsony> <20040411080932.Q83278@megazone.bigpanda.com> <1081711155.6399.165.camel@bretsony> Comments: In-reply-to Bret Hughes message dated "11 Apr 2004 14:19:14 -0500" Date: Sun, 11 Apr 2004 18:00:13 -0400 Message-ID: <17189.1081720813@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/110 X-Sequence-Number: 17485 Bret Hughes writes: > elevating=# drop table test_types; > ERROR: could not find tuple for constraint 2041971 > I can find no reference to these oids anywhere. You haven't looked very hard then ;-). I expect this is because pg_depend has links from the table to the constraints it owns. You could probably remove the pg_depend entries to make it possible to drop the table. Use ALTER TABLE next time, eh? Hand manipulation of the system catalogs is *not* for those who don't know exactly what they are doing. regards, tom lane