Thread: Version 1.6.1
I just installed version 8.1 of PostgreSQL and version 1.6.1 of PG Admin.
In the new PG Admin some of the tables show blank (no columns, no headings) and the row anticipating information is also not shown.
In the older version, my method of testing triggers is to input the information into the tables manually. With the tables that don't show the anticipated next row this is not possible. In fact, when I attempt to enter information manually PG Admin shuts down.
Any help would be appreciated.
Bob Pawley
Bob Pawley wrote: > I just installed version 8.1 of PostgreSQL and version 1.6.1 of PG Admin. > > In the new PG Admin some of the tables show blank (no columns, no > headings) and the row anticipating information is also not shown. What OS are you running on? Do you have appropriate permissions to view the contents of those tables, *and* update them? > In the older version, my method of testing triggers is to input the > information into the tables manually. With the tables that don't show > the anticipated next row this is not possible. In fact, when I attempt > to enter information manually PG Admin shuts down. How on earth are you entering data if there's no new record row? Regards, Dave.
I am running on Win XP and I have permission. There are only some of the tables in this condition. Once I enter info (through a Delphi interface) the row appears - but only rows that have information. These tables also are missing the column headers until info is entered. This condition is present in both version 1.6.1 and the earlier version that came packaged with the Win 32 PostgreSQL installation. I didn't have this problem with the PG Admin that came with the PostgreSQL 8.0 version - so it may be that I have done something the new version doesn't like. Bob ----- Original Message ----- From: "Dave Page" <dpage@postgresql.org> To: "Bob Pawley" <rjpawley@shaw.ca> Cc: "PG Admin" <pgadmin-support@postgresql.org> Sent: Monday, December 04, 2006 11:41 AM Subject: Re: [pgadmin-support] Version 1.6.1 > Bob Pawley wrote: >> I just installed version 8.1 of PostgreSQL and version 1.6.1 of PG Admin. >> In the new PG Admin some of the tables show blank (no columns, no >> headings) and the row anticipating information is also not shown. > > What OS are you running on? Do you have appropriate permissions to view > the contents of those tables, *and* update them? > >> In the older version, my method of testing triggers is to input the >> information into the tables manually. With the tables that don't show the >> anticipated next row this is not possible. In fact, when I attempt to >> enter information manually PG Admin shuts down. > > How on earth are you entering data if there's no new record row? > > Regards, Dave. >
Bob Pawley wrote: > I am running on Win XP and I have permission. There are only some of the > tables in this condition. Once I enter info (through a Delphi interface) > the row appears - but only rows that have information. These tables also > are missing the column headers until info is entered. Ah, got it - fix committed. Would you like an updated .exe to test? > This condition is present in both version 1.6.1 and the earlier version > that came packaged with the Win 32 PostgreSQL installation. Are you sure? The change that broke it was this one: 2006-11-29 DP 1.6.1 Guard against permission denied errors in the edit grid per Howard Wang. So 1.6.0 should be unnaffected. Regards, Dave
Yes please send me the fix. I am sure. I didn't know of version 1.6.1 until I had the same problem with the Win installation version. Thanks for your help. Bob ----- Original Message ----- From: "Dave Page" <dpage@postgresql.org> To: "Bob Pawley" <rjpawley@shaw.ca> Cc: "PG Admin" <pgadmin-support@postgresql.org> Sent: Tuesday, December 05, 2006 2:15 AM Subject: Re: [pgadmin-support] Version 1.6.1 > Bob Pawley wrote: >> I am running on Win XP and I have permission. There are only some of the >> tables in this condition. Once I enter info (through a Delphi interface) >> the row appears - but only rows that have information. These tables also >> are missing the column headers until info is entered. > > Ah, got it - fix committed. Would you like an updated .exe to test? > >> This condition is present in both version 1.6.1 and the earlier version >> that came packaged with the Win 32 PostgreSQL installation. > > Are you sure? The change that broke it was this one: > > 2006-11-29 DP 1.6.1 Guard against permission denied errors in the edit > grid per Howard Wang. > > So 1.6.0 should be unnaffected. > > Regards, Dave > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend >