Обсуждение: View all rows not updated properly if program deletes all rows

I'm using PgAdmin 1.6.1 against PG 8.2.0, both running on Windows XP.  I 
have a test Java program that inserts and deletes rows into a single 
table; I vary the operation of the program by commenting out various 
parts.  Before running the program, I open a view window on this table 
by selecting "View all rows".  When I configure the program to just 
insert rows and click the refresh icon, all the inserted rows show up. 
If I configure the program to insert then delete *some* rows, when I 
click the refresh icon, the remaining rows are properly shown.  However, 
if I configure the program to insert then delete all rows, clicking the 
refresh icon doesn't do anything.

If I go back to the main window and tell it to count the rows in this 
table, it correctly reports zero.  If I close the original view window 
then open a new one, it also correctly displays no data.

-- 
Guy Rouillier

Guy Rouillier wrote:
> I'm using PgAdmin 1.6.1 against PG 8.2.0, both running on Windows XP.  
> I have a test Java program that inserts and deletes rows into a single 
> table; I vary the operation of the program by commenting out various 
> parts.  Before running the program, I open a view window on this table 
> by selecting "View all rows".  When I configure the program to just 
> insert rows and click the refresh icon, all the inserted rows show up. 
> If I configure the program to insert then delete *some* rows, when I 
> click the refresh icon, the remaining rows are properly shown.  
> However, if I configure the program to insert then delete all rows, 
> clicking the refresh icon doesn't do anything.
>
> If I go back to the main window and tell it to count the rows in this 
> table, it correctly reports zero.  If I close the original view window 
> then open a new one, it also correctly displays no data.
>

Hi Guy,

This is a known bug in this version which is apparently fixed in PgAdmin 
1.6.2 (not yet released) - also notice if you delete all rows in a 
table, close the original view and re-open, it shows no data - but you 
can't insert new rows either (no columns/new row placeholder.)

-- 
Andy Shellam
NetServe Support Team

the Mail Network
"an alternative in a standardised world"

Guy Rouillier wrote:
> I'm using PgAdmin 1.6.1 against PG 8.2.0, both running on Windows XP.  I 
> have a test Java program that inserts and deletes rows into a single 
> table; I vary the operation of the program by commenting out various 
> parts.  Before running the program, I open a view window on this table 
> by selecting "View all rows".  When I configure the program to just 
> insert rows and click the refresh icon, all the inserted rows show up. 
> If I configure the program to insert then delete *some* rows, when I 
> click the refresh icon, the remaining rows are properly shown.  However, 
> if I configure the program to insert then delete all rows, clicking the 
> refresh icon doesn't do anything.
> 
> If I go back to the main window and tell it to count the rows in this 
> table, it correctly reports zero.  If I close the original view window 
> then open a new one, it also correctly displays no data.
> 

This is caused by a known bug that has been fixed already. Thanks for 
the report though.

Regards, Dave.

Dave Page wrote:

> This is caused by a known bug that has been fixed already. Thanks for 
> the report though.

Thanks, Dave and Andy, I'll look for the 1.6.2 update.  Is the 
tablespace rename issue I reported earlier also fixed in the upcoming 
release?

-- 
Guy Rouillier

Guy Rouillier wrote:
> Dave Page wrote:
> 
>> This is caused by a known bug that has been fixed already. Thanks for 
>> the report though.
> 
> Thanks, Dave and Andy, I'll look for the 1.6.2 update.  Is the 
> tablespace rename issue I reported earlier also fixed in the upcoming 
> release?
> 

I haven't looked at that yet.

Regards, Dave.