Re: [pgadmin-support] Complete breakdown of pgadmin when trying to connect to server or modify properties of tables of views

2008-03-07 Thread Michael Eschweiler
Hi Dave, many thanks for quick answer! > - Run pgAdmin from the command line, with a command like: > G_SLICE=always-malloc pgadmin3 & This works fine > - Recompile pgAdmin. That's what I tried, too. Sorry, forgot to mention it. I downloaded the source-rpm for my distribution and installed it.

[pgadmin-support] Re: [BUGS] BUG #3829: Wrong index reporting from pgAdmin III (v1.8.0 rev 6766-6767)

2008-03-07 Thread Bruce Momjian
Added to TODO: * Add a function like pg_get_indexdef() that report more detailed index information http://archives.postgresql.org/pgsql-bugs/2007-12/msg00166.php --- Dave Page wrote: > Tom Lane wrote: > >> We use the

Re: [pgadmin-support] Compiling PgAdmin 1.8.x on Debian LennyAMD64?

2008-03-07 Thread RuiDC
Hi, i have followed the instructions and the build and install worked fine for me after installing the stated dependencies (on Ubuntu 7.10 - amd64). Furthermore, i managed to get pgadmin3 it to work fine after install (at least as far as creating a new table, column, key, inserting a row and sel

Re: [pgadmin-support] Adding columns NOT NULL

2008-03-07 Thread Tino Wildenhain
Hi, Laurent ROCHE wrote: Hi, There is a little anomaly in the way adding an extra column is treated in pgAdmin III 1.8.2. ... particularly if this is a NOT NULL column. When adding the column my_col with a DEFAULT value, the code generated will be: ALTER TABLE my_table ADD COLUMN my_col bo

Re: [pgadmin-support] Complete breakdown of pgadmin when trying to connect to server or modify properties of tables of views

2008-03-07 Thread Dave Page
On Fri, Mar 7, 2008 at 11:14 AM, Michael Eschweiler <[EMAIL PROTECTED]> wrote: > Hi there, > On opensuse 10.2 I installed postgresql and pgadmin from the distribution. > Postgresql 8.1.11 > pgadmin3 1.6.3 > Recently I found that pgadmin didn't work properly: It opened the connection > to the serve

[pgadmin-support] Complete breakdown of pgadmin when trying to connect to server or modify properties of tables of views

2008-03-07 Thread Michael Eschweiler
Hi there, On opensuse 10.2 I installed postgresql and pgadmin from the distribution. Postgresql 8.1.11 pgadmin3 1.6.3 Recently I found that pgadmin didn't work properly: It opened the connection to the server and to a particular database, I can see the data of the tables and views but when I tri

[pgadmin-support] Adding columns NOT NULL

2008-03-07 Thread Laurent ROCHE
Hi, There is a little anomaly in the way adding an extra column is treated in pgAdmin III 1.8.2. ... particularly if this is a NOT NULL column. When adding the column my_col with a DEFAULT value, the code generated will be: ALTER TABLE my_table ADD COLUMN my_col boolean; ALTER TABLE my_table ALT