Skip site navigation (1) Skip section navigation (2)

Re: Delete function disabled

From: Colin Beckingham <colbec(at)start(dot)ca>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: Nick Rogers <nrogers64(at)hotmail(dot)com>, pgadmin-support(at)postgresql(dot)org
Subject: Re: Delete function disabled
Date: 2011-11-24 11:02:51
Message-ID: 4ECE245B.2050903@start.ca (view raw or flat)
Thread:
Lists: pgadmin-support

On 11/24/2011 04:59 AM, Dave Page wrote:
> On Thu, Nov 24, 2011 at 9:53 AM, Colin Beckingham<colbec(at)start(dot)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

In response to

Responses

pgadmin-support by date

Next:From: Dave PageDate: 2011-11-24 11:06:25
Subject: Re: Delete function disabled
Previous:From: Dave PageDate: 2011-11-24 09:59:56
Subject: Re: Delete function disabled

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group