From: | Ed Loehr <eloehr(at)austin(dot)rr(dot)com> |
---|---|
To: | Tara Cooper <carat(at)pantz(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: undeleteable records |
Date: | 2001-07-18 23:01:12 |
Message-ID: | 3B561538.D82D9027@austin.rr.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tara Cooper wrote:
>
> 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. I've
> copied the table, the select statement showing the record I want to
> delete in that table, and the delete statement itself. I'm currently
> using postgres-sql 7.1 rc2. (I know, I know...but it's a development
> server.) Thanks!
>
> -T
>
> DELETE FROM ec_gift_certificates WHERE gift_certificate_id = 9;
> DELETE 0
>
> SELECT gift_certificate_id FROM ec_gift_certificates WHERE
> gift_certificate_id = 9;
>
> gift_certificate_id
> ---------------------
> 9
> (1 row)
Looks strange. Any delete triggers setup on ec_gift_certificates? What
does your server log show?
Regards,
Ed Loehr
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Clift | 2001-07-18 23:12:50 | Re: replication? |
Previous Message | Ed Loehr | 2001-07-18 22:56:10 | Unexpected ALTER TABLE behavior |