Re: View all rows not updated properly if program

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"