From: | Oliver Baden <obaden(at)olit(dot)de> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Delete icon deletes all records in pgadmin 1.61 |
Date: | 2007-01-04 19:52:01 |
Message-ID: | 459D5AE1.8030100@olit.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hi!
I have a table where the primary key is a serial but the position of the
primary key is not the first column. Today when showing all recordsets
with the command "show all rows" (in german: alle Zeilen anzeigen) I
wanted to delete one row and selected it with the mouse and after that
clicked the delete-icon. After a table-refresh all rows had been deleted
and I had to restore the table from our backup. I tried the same
behaviour in pgadmin 1.40 and it worked without a problem. So for me
pgadmin 1.61 behaves as if the table has no primary-key assigned when
the primary-key column is not the first column of the table and can not
build the where-statement for the delete-command properly. Has somebody
else seen this behaviour?
Thanks
Oliver
___________________________________________________________
Telefonate ohne weitere Kosten vom PC zum PC: http://messenger.yahoo.de
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2007-01-05 09:22:23 | Re: Infinite loop occurs sometimes when exporting |
Previous Message | Dave Page | 2007-01-04 16:37:02 | Re: Renamed tablespace not shown for DB until reconnect |