Re: cannot delete bug

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kemin Zhou <kemin(dot)zhou(at)ferring(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: cannot delete bug
Date: 2002-09-17 22:31:00
Message-ID: 12017.1032301860@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Kemin Zhou <kemin(dot)zhou(at)ferring(dot)com> writes:
> kzdb=# select id from mytable where id=7224;
> id
> ------
> 7224
> (1 row)

> kzdb=# delete from mytable where id=7224;
> ERROR: Relation 41073353 does not exist

Have you got any rules, triggers, or foreign keys linking to or from
that table?

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-09-17 22:43:44 Re: How to select and result row number??
Previous Message Bruce Momjian 2002-09-17 22:21:17 Re: How to select and result row number??