undeleteable records
От | Tara Cooper |
---|---|
Тема | undeleteable records |
Дата | |
Msg-id | 5.0.2.1.2.20010802142455.01f3e240@mail.pantz.com обсуждение исходный текст |
Ответы |
Re: undeleteable records
(Tom Lane <tgl@sss.pgh.pa.us>)
|
Список | pgsql-general |
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 recordby specifying a different field value, with the same results, as well as trying all of this with multiple records inthe same table. None of the records will delete. I've copied the table, the select statement showing the record I wantto delete in that table, and the delete statement itself. I'm currently using postgres-sql 7.1 rc2. (I know, I know...butit's a development server.) Thanks!<br /><br /> -T<br /><br /><font face="Courier, Courier">DELETE FROM ec_gift_certificatesWHERE gift_certificate_id = 9;<br /> DELETE 0<br /><br /> SELECT gift_certificate_id FROM ec_gift_certificatesWHERE 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 timezone | <br /> claimed_date | timestamp with time zone | <br /> issued_by | integer | <br /> purchased_by | integer | <br /> expires | timestampwith time zone | <br /> user_id | integer | <br /> claim_check | charactervarying(50) | <br /> certificate_message | character varying(200) | <br /> certificate_to | charactervarying(100) | <br /> certificate_from | character varying(100) | <br /> recipient_email | charactervarying(100) | <br /> voided_date | timestamp with time zone | <br /> voided_by | integer | <br /> reason_for_void | character varying(4000) | <br /> last_modified | timestampwith 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><p> ***********************************************<br/> Tara Cooper<br /> Payment Alliance, Inc.<br /> carat@pantz.com
В списке pgsql-general по дате отправления: