Oliver Baden wrote: > 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?
I'm sorry that you've lost data :-( I've been testing this with a copy of pg_class, in which I used relfilenode as a primary key and couldn't reproduce the problem. I then changed the primary key to be relfilenode and relisshared (non-consecutive columns, neither of which are at the beginning or end) and that worked as expected as well. Can you still reproduce the problem (on a test database of course!). If so, can you share the table definition please? Thanks, Dave. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings