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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Foreign Keys
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: psql -l