From: | "Dario Scopesi" <dario(at)ventia(dot)com> |
---|---|
To: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | ERROR: Could not locate the record for deletion in the database! |
Date: | 2001-11-06 21:32:39 |
Message-ID: | NDBBLGKKMKIFHPGIGELKGEEBCFAA.dario@ventia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
(pgAdmin2, 1.1.59)
When I try to delete a record from a table/view data (select the record,
press delete button), this error message is shown:
"Could not locate the record for deletion in the database!"
This is the table definition:
CREATE TABLE "partners" (
"id" int8 NOT NULL,
"firstname" text NOT NULL,
"lastname" text NOT NULL,
"company" text,
"username" text NOT NULL,
"country" text NOT NULL,
"state" text,
"hear" text,
"regdate" timestamp NOT NULL,
"email" text NOT NULL,
CONSTRAINT "partners_pkey" PRIMARY KEY ("id")
);
and this is the log (level: debug)
07/11/2001 8:21:10 AM - Counting matching records...
07/11/2001 8:21:10 AM - SQL (desknow): SELECT count(*) AS count FROM
"partners" WHERE "id" = '119706' AND "firstname" = 'Dario' AND "lastname" =
'gva' AND "company" = 'company' AND "username" = 'dtest4' AND "country" =
'country' AND "state" = 'state' AND "hear" = 'hear' AND "regdate" =
'2001-10-20 18:16:01' AND "email" = 'dario(at)nowhere(dot)com'
07/11/2001 8:21:10 AM - Done - 0.37 Secs.
Looks like it can't find the record (btw, being a primary key there,
wouldn't it be easier to limit the WHERE clause to it?)
Has it anything to do with 'text' type fields?
Regards
Dario Scopesi
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2001-11-07 10:23:54 | Re: ERROR: Could not locate the record for dele |
Previous Message | Dave Page | 2001-11-06 12:09:15 | Re: Invalid procedure call or argument |