Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id 1F59D4759B3 for ; Thu, 28 Feb 2002 16:27:54 -0500 (EST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id BD4D2D600; Thu, 28 Feb 2002 13:27:49 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id B0F5D5BFB; Thu, 28 Feb 2002 13:27:49 -0800 (PST) Date: Thu, 28 Feb 2002 13:27:49 -0800 (PST) From: Stephan Szabo To: Matthew Price Cc: Subject: Re: Can't get rid of constraint In-Reply-To: <20020228.160038.29488.1751@wm2.jersey.juno.com> Message-ID: <20020228132352.F21767-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200202/458 X-Sequence-Number: 6879 On Thu, 28 Feb 2002, Matthew Price wrote: > Howdy, > I had a table in my database that reference another like: > > create table a (1 int, 2 int); > create table b (1 int references a(1)); > > recently i had to do a: > drop table b; > > now i can't: > delete from a where 1='5'; > > because i get: > ERROR: Relation 'b' does not exist > > How do I get rid of this zombie constraint? There are two triggers on a that do the constraint, if you drop the triggers with drop trigger (you'll need to double quote the names) you should be fine.