pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedCan't get rid of constraint
2+ messages / 2 participants
[nested] [flat]
* Can't get rid of constraint
@ 2002-02-28 21:00 Matthew Price <pricem@juno.com>
2002-02-28 21:27 ` Re: Can't get rid of constraint Stephan Szabo <sszabo@megazone23.bigpanda.com>
0 siblings, 1 reply; 2+ messages in thread
From: Matthew Price @ 2002-02-28 21:00 UTC (permalink / raw)
To: 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/.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Can't get rid of constraint
2002-02-28 21:00 Can't get rid of constraint Matthew Price <pricem@juno.com>
@ 2002-02-28 21:27 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
0 siblings, 0 replies; 2+ messages in thread
From: Stephan Szabo @ 2002-02-28 21:27 UTC (permalink / raw)
To: Matthew Price <pricem@juno.com>; +Cc: pgsql-sql
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-02-28 21:27 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-02-28 21:00 Can't get rid of constraint Matthew Price <pricem@juno.com>
2002-02-28 21:27 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox