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

2008-03-11 Thread Pedro Doria Meunier
Andrew, We've had zero problems with a highly-customized (optimized) Fedora 6 distro. That server serves 1000's of requests per minute and still performant. We've also used it with FC7 and 8 with no issues whatsoever... Josh is right: those RPMs sink right in... ;-) (although we've recompiled pgsq

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

2008-03-11 Thread Josh
Which Linux distro's support Postgres releases the best? Which are best suited in a server vs. development suite of tools? Andrew, I've always had excellent luck with CentOS, which is a clone of RedHat Enterprise Linux. The RPM's for RHEL that you find on the Postgres website drop right in

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

2008-03-11 Thread Andrew
Without wanting to start a religious debate on the merits of various Linux distro's, I'm still going to ask the subjective question, which is probably a recurring one, and perhaps not suitable for this forum. Which Linux distro's support Postgres releases the best? Which are best suited in a

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

2008-03-11 Thread Dave Page
On Tue, Mar 11, 2008 at 2:10 PM, Michael Eschweiler <[EMAIL PROTECTED]> wrote: > I compiled the wxWidgets with the -enable-unicode option. Therefore I followed > your advice and controlled if the devel packages are installed. > The postgresql- and gtk2-devels are installed but as I compiled the wx

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

2008-03-11 Thread Michael Eschweiler
First I tried once more with > ./configure --with-pgsql=/usr --with-wx=/usr/local but configure now stops with: checking for strchr... yes checking for PQexec in libpq.a... present checking for SSL_connect in libpq.a... present checking for krb5_free_principal in libpq.a... present checking lib

Re: [pgadmin-support] Adding columns NOT NULL

2008-03-11 Thread Dave Page
On Fri, Mar 7, 2008 at 10:30 AM, Laurent ROCHE <[EMAIL PROTECTED]> wrote: > > So I would suggest to generate the code: > ALTER TABLE my_table ADD COLUMN my_col boolean NOT NULL DEFAULT false; It actually does do this already if you add the column through the table dialogue. I've fixed the column d

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

2008-03-11 Thread Dave Page
On Sun, Mar 9, 2008 at 5:04 PM, Michael Eschweiler <[EMAIL PROTECTED]> wrote: > > Can you find the pg_config and wx-config programs on your machine? > > Where are they? > I found them: > /usr/bin/pg_config > /usr/local/bin/wx-config OK, so try running configure with something like the followin