Can't get rid of constraint

From: Matthew Price <pricem(at)juno(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Can't get rid of constraint
Date: 2002-02-28 21:00:12
Message-ID: 20020228.160038.29488.1751@wm2.jersey.juno.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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/.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2002-02-28 21:27:49 Re: Can't get rid of constraint
Previous Message Ross J. Reedstrom 2002-02-28 19:46:32 Re: LIKE with no wildcards problem