<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. 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!<br>
<br>
-T<br>
<br>
<font face="Courier, Courier">DELETE FROM ec_gift_certificates WHERE
gift_certificate_id = 9;<br>
DELETE 0<br>
<br>
SELECT gift_certificate_id FROM ec_gift_certificates WHERE
gift_certificate_id = 9;<br>
<br>
gift_certificate_id <br>
---------------------<br>
9<br>
(1 row)<br>
<br>
<br>
<br>
\d ec_gift_certificates<br>
Table "ec_gift_certificates"<br>
Attribute
|
Type |
Modifier <br>
------------------------+--------------------------+-------------<br>
gift_certificate_id |
integer
| not null<br>
gift_certificate_state | character varying(50) |
not null<br>
amount
|
numeric(30,6)
| not null<br>
amount_remaining_p |
character(1)
| default 't'<br>
issue_date
| timestamp with time zone | <br>
authorized_date |
timestamp with time zone | <br>
claimed_date
| timestamp with time zone | <br>
issued_by
|
integer
| <br>
purchased_by
|
integer
| <br>
expires
| timestamp with time zone | <br>
user_id
|
integer
| <br>
claim_check
| character varying(50) | <br>
certificate_message | character
varying(200) | <br>
certificate_to |
character varying(100) | <br>
certificate_from | character
varying(100) | <br>
recipient_email |
character varying(100) | <br>
voided_date
| timestamp with time zone | <br>
voided_by
|
integer
| <br>
reason_for_void |
character varying(4000) | <br>
last_modified
| timestamp with time zone | not null<br>
last_modifying_user |
integer
| not null<br>
modified_ip_address | character
varying(20) | not null<br>
Indices: ec_gc_by_amount_remaining,<br>
ec_gc_by_claim_check,<br>
ec_gc_by_state,<br>
ec_gc_by_user,<br>
ec_gift_certificates_pkey<br>
Constraints: ((amount_remaining_p = 'f'::bpchar) OR (amount_remaining_p =
't'::bpchar))<br>
((user_id NOTNULL) OR (claim_check NOTNULL))<br>
<br>
</font><x-sigsep><p></x-sigsep>
***********************************************<br>
Tara Cooper<br>
Payment Alliance, Inc.<br>
carat(at)pantz(dot)com</html>