Postgres Pro
Downloads
Home   >   mailing lists

Thread: Select multiple rows for delete does too good of a job

Select multiple rows for delete does too good of a job

From
Scott Dunbar
Date:
Hi all,<br /> I'm using pgAdmin III version 1.10.0 from the Ubuntu 9.10 64 bit package.  I bring the contents of a
tableby right clicking on the table name and selecting "View Data" and either "View Top 100 Rows" or "View All Rows". 
Ihave a very small table with about 10 rows in it.  I then select two or more rows and right click to select "Delete". 
Thedialog that comes up shows something like "Are you sure you wish to delete the 1027272344 selected rows?".  The
numbervaries but is always no where near the correct number.  Sometimes it works and deletes what I selected. 
Sometimesit core dumps.  And once in a while it deletes everything, selected or not.<br /><br /> I understand that
thereare more recent versions of pgAdmin available and I'll compile one to try it on a newer ones too but I wanted to
seeif anyone else can reproduce this.<br /><br /> Thanks for any help.<br /><br /><br /><div class="moz-signature">--
<br/><span style="font-weight: bold;">Scott Dunbar</span><br /><span>Xigole Systems, Inc.</span><br /><span>Enterprise
softwareconsulting, development, and hosting</span><br /><span>303·667·6343</span><br /></div>

Re: Select multiple rows for delete does too good of a job

From
Guillaume Lelarge
Date:
Le 17/03/2010 22:59, Scott Dunbar a écrit :
> Hi all,
> I'm using pgAdmin III version 1.10.0 from the Ubuntu 9.10 64 bit
> package.  I bring the contents of a table by right clicking on the table
> name and selecting "View Data" and either "View Top 100 Rows" or "View
> All Rows".  I have a very small table with about 10 rows in it.  I then
> select two or more rows and right click to select "Delete".  The dialog
> that comes up shows something like "Are you sure you wish to delete the
> 1027272344 selected rows?".  The number varies but is always no where
> near the correct number.  Sometimes it works and deletes what I
> selected.  Sometimes it core dumps.  And once in a while it deletes
> everything, selected or not.
> 
> I understand that there are more recent versions of pgAdmin available
> and I'll compile one to try it on a newer ones too but I wanted to see
> if anyone else can reproduce this.
> 

AFAIR, there was an issue like this one fixed in a recent release. Can
you try on a 1.10.2 release?


-- 
Guillaume.http://www.postgresqlfr.orghttp://dalibo.com