On 11/24/2011 04:59 AM, Dave Page wrote:
On Thu, Nov 24, 2011 at 9:53 AM, Colin Beckingham<col...@start.ca>  wrote:


On 11/24/2011 03:52 AM, Nick Rogers wrote:

I use pgAdmin v1.14.0 multiple databases stored on multiple servers. I
am able to use the GUI to insert rows and edit existing rows. But when
it comes to deleting rows, I am forced to manually type in the SQL to
delete the rows because the "Delete" toolbar button is disabled as well
as the "Delete" item in the "Edit" menu. This is the case for all of the
servers I connect to, including localhost. Why is this happening?

Thanks!

I get this as well. However if the table has OIDs then the delete button
activates no problem.

It needs either a primary key or OIDs to allow deletes. By default,
you'll get a guru hint warning you that you need one of them when you
first open a table without, but it's possible to suppress that hint
and then forget about it 12 months later :-)


Correctamundo. Thanks for the reminder.

It seems a bit strict... Presumably lots of thinking went into this - without a unique key, any delete statement might delete multiple duplicate rows without a limit statement, which might or might not be what the user intended.

--
---
Colin Beckingham

--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Reply via email to