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 :-) -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
