Re: undeleteable records
| От | wsheldah@lexmark.com |
|---|---|
| Тема | Re: undeleteable records |
| Дата | |
| Msg-id | 200107172115.RAA18279@interlock2.lexmark.com обсуждение исходный текст |
| Ответ на | undeleteable records (Tara Cooper <carat@pantz.com>) |
| Список | pgsql-general |
What I noticed was that the select came up with one row, with an apparently
blank gift_certificate_id. That field was declared as INT NOT NULL, yet it
shows up blank. Wouldn't that indicate that something got in there that wasn't
supposed to?
Tom Lane <tgl%sss.pgh.pa.us@interlock.lexmark.com> on 07/17/2001 04:49:45 PM
To: Tara Cooper <carat%pantz.com@interlock.lexmark.com>
cc: pgsql-general%postgresql.org@interlock.lexmark.com (bcc: Wesley
Sheldahl/Lex/Lexmark)
Subject: Re: [GENERAL] undeleteable records
Tara Cooper <carat@pantz.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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
В списке pgsql-general по дате отправления: