Received: from wm2.jersey.juno.com (wm2.jersey.juno.com [64.136.16.222]) by postgresql.org (Postfix) with ESMTP id 53506475C09 for ; Thu, 28 Feb 2002 16:00:58 -0500 (EST) Received: from cookie.juno.com by cookie.juno.com for <"/TkDBi7JJ2b6tmw2z88AAMgAaleinsaq+Jr2NH7Qj8PVWRCaivBnfQ=="> Received: (from pricem@juno.com) by wm2.jersey.juno.com (jqueuemail) id GURXR46E; Thu, 28 Feb 2002 16:00:38 EST X-Original-From: "Matthew Price" Date: Thu, 28 Feb 2002 21:00:12 GMT To: pgsql-sql@postgresql.org Cc: Subject: Can't get rid of constraint X-Mailer: Juno Webmail Version 1.0 From: Matthew Price Message-Id: <20020228.160038.29488.1751@wm2.jersey.juno.com> X-Archive-Number: 200202/457 X-Sequence-Number: 6878 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? Thanks, Matthew ________________________________________________________________ GET INTERNET ACCESS FROM JUNO! Juno offers FREE or PREMIUM Internet access for less! Join Juno today! For your FREE software, visit: http://dl.www.juno.com/get/web/.