pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Matthew Price <pricem@juno.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Can't get rid of constraint
Date: Thu, 28 Feb 2002 13:27:49 -0800 (PST)
Message-ID: <20020228132352.F21767-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <20020228.160038.29488.1751@wm2.jersey.juno.com>

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.




view thread (2+ messages)

Message-ID: <20020228132352.F21767-100000@megazone23.bigpanda.com>
Permalink:  ../20020228132352.F21767-100000@megazone23.bigpanda.com/
Also on:    postgresql.org/message-id/20020228132352.F21767-100000@megazone23.bigpanda.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: sszabo@megazone23.bigpanda.com, pricem@juno.com
  Subject: Re: Can't get rid of constraint
  In-Reply-To: <20020228132352.F21767-100000@megazone23.bigpanda.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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