| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2004-03-30 18:01:57 | Re: Error on deleting |
| Previous Message | Reshat Sabiq | 2004-03-27 18:57:57 | Re: [pgadmin-support] Automatic language selection |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2004-03-30 18:01:57 | Re: Error on deleting |
| Previous Message | Steve Manes | 2004-03-30 17:16:50 | Re: Can we have time based triggers in Postgresql?? |