Skip site navigation (1) Skip section navigation (2)

Error on deleting

From: Indibil <indibil(at)webmail(dot)co(dot)za>
To: "pgadmin-support(at)postgresql(dot)org(dot)pgsql-general"(at)postgresql(dot)org
Subject: Error on deleting
Date: 2004-03-30 17:20:24
Message-ID: c4ca8k$931$1@news.hub.org (view raw or flat)
Thread:
Lists: pgadmin-supportpgsql-general
Hi:

I have a PostgreSQL 7.2.2 database since 2 years working right until now.
When I try to delete a row from pgAdmin II , I get the message " ....cannot
uniquely identify, 2 rows match....." If I go on deleting the row, the 2
ones are deleted. Of Course the 2 rows don't match. They have different
primary key, OIDs, and so on.

This has happened several times in the last days. If I issue the SQL command
"Delete ......" no errors occurs. 

Please I need help, because the database is into production, and I am
receiving callings from angry users which can not delete rows from their
Visual Basic program ( they access the PostgreSQL database via this
program, and get the message " the record does not exist" when they are
trying to delete).

Thanks in advance, and sorry for my poor english.

Indibil

Responses

pgadmin-support by date

Next:From: Dave PageDate: 2004-03-30 18:01:57
Subject: Re: Error on deleting
Previous:From: Reshat SabiqDate: 2004-03-27 18:57:57
Subject: Re: [pgadmin-support] Automatic language selection

pgsql-general by date

Next:From: Dave PageDate: 2004-03-30 18:01:57
Subject: Re: Error on deleting
Previous:From: Steve ManesDate: 2004-03-30 17:16:50
Subject: Re: Can we have time based triggers in Postgresql??

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group