undeleteable records

From: Tara Cooper <carat(at)pantz(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: undeleteable records
Date: 2001-08-02 18:39:10
Message-ID: 5.0.2.1.2.20010802142455.01f3e240@mail.pantz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<html>
Has anyone encountered a problem where a delete sql statement works (no
parser errors) but always returns a &quot;DELETE 0&quot; value, even when
I'm sure the record I'm selecting for delete is in the table?&nbsp; 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.&nbsp; 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.&nbsp; 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>
&nbsp;gift_certificate_id <br>
---------------------<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
9<br>
(1 row)<br>
<br>
<br>
<br>
\d ec_gift_certificates<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Table &quot;ec_gift_certificates&quot;<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Attribute&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;
Modifier&nbsp;&nbsp; <br>
------------------------+--------------------------+-------------<br>
&nbsp;gift_certificate_id&nbsp;&nbsp;&nbsp; |
integer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| not null<br>
&nbsp;gift_certificate_state | character varying(50)&nbsp;&nbsp;&nbsp; |
not null<br>
&nbsp;amount&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
|
numeric(30,6)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| not null<br>
&nbsp;amount_remaining_p&nbsp;&nbsp;&nbsp;&nbsp; |
character(1)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| default 't'<br>
&nbsp;issue_date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| timestamp with time zone | <br>
&nbsp;authorized_date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
timestamp with time zone | <br>
&nbsp;claimed_date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| timestamp with time zone | <br>
&nbsp;issued_by&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
|
integer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| <br>
&nbsp;purchased_by&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
|
integer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| <br>
&nbsp;expires&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| timestamp with time zone | <br>
&nbsp;user_id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
|
integer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| <br>
&nbsp;claim_check&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| character varying(50)&nbsp;&nbsp;&nbsp; | <br>
&nbsp;certificate_message&nbsp;&nbsp;&nbsp; | character
varying(200)&nbsp;&nbsp; | <br>
&nbsp;certificate_to&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
character varying(100)&nbsp;&nbsp; | <br>
&nbsp;certificate_from&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | character
varying(100)&nbsp;&nbsp; | <br>
&nbsp;recipient_email&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
character varying(100)&nbsp;&nbsp; | <br>
&nbsp;voided_date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| timestamp with time zone | <br>
&nbsp;voided_by&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
|
integer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| <br>
&nbsp;reason_for_void&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |
character varying(4000)&nbsp; | <br>
&nbsp;last_modified&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| timestamp with time zone | not null<br>
&nbsp;last_modifying_user&nbsp;&nbsp;&nbsp; |
integer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
| not null<br>
&nbsp;modified_ip_address&nbsp;&nbsp;&nbsp; | character
varying(20)&nbsp;&nbsp;&nbsp; | not null<br>
Indices: ec_gc_by_amount_remaining,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
ec_gc_by_claim_check,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ec_gc_by_state,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ec_gc_by_user,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
ec_gift_certificates_pkey<br>
Constraints: ((amount_remaining_p = 'f'::bpchar) OR (amount_remaining_p =
't'::bpchar))<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
((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>

Attachment Content-Type Size
unknown_filename text/html 5.3 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ing. Roberto Andrade Fonseca 2001-08-02 19:27:49 Looking for an Apache log to pgsql module
Previous Message Vivek Khera 2001-08-02 18:10:29 Re: Importing Mysql DUMPS into Postgresql