| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Tara Cooper <carat(at)pantz(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: undeleteable records |
| Date: | 2001-07-17 20:49:45 |
| Message-ID: | 26457.995402985@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tara Cooper <carat(at)pantz(dot)com> writes:
> <html>
> Has anyone encountered a problem where a delete sql statement works (no
> parser errors) but always returns a "DELETE 0" value, even when
> I'm sure the record I'm selecting for delete is in the table? I
> have also tried deleting the same record by specifying a different field
> value, with the same results, as well as trying all of this with multiple
> records in the same table. None of the records will delete.
Please don't send HTML mail to the lists...
I wonder whether you haven't got a foreign key relationship that forbids
the delete. Or a miswritten user-defined ON DELETE trigger.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | will trillich | 2001-07-17 20:50:20 | Re: bit operations |
| Previous Message | Tom Lane | 2001-07-17 20:47:46 | Re: Foreign Keys |