[SQL] pgtop, display PostgreSQL processes in `top' style

2005-04-30 Thread Cosimo Streppone
Hi everybody, I'm currently working on something like a `mytop' clone, also written in Perl with DBI + DBD::Pg interface. mytop is a command line utility that displays mysql server status and clients connected modeled after `top' unix utility. (http://mytop.sourceforge.net). What I'd like to achiev

Re: [SQL] multi-column unique constraints with nullable columns

2005-04-30 Thread Stephan Szabo
On Sat, 30 Apr 2005, Tornroth, Phill wrote: > >I believe you can add partial unique indexes to cover the case where a > >column is null, but if you have multiple nullable columns you need to > >worry about you end up with a bunch of indexes. > > Hmmm. I hadn't thought of that, thanks. Yes, the ind

Re: [SQL] Build issues: "-static" builds resulting initdb problems

2005-04-30 Thread Tom Lane
"Metin Ozisik" <[EMAIL PROTECTED]> writes: > The purpose of using static linking is to reduce dependencies to > shared-libraries (dependencies to different types and versions of Linux), so > an instance of postgreSQL, say built on Suse 9.0, would still work on > Mandrake 10.1. Yes it gets a bit

Re: [SQL] PHP postgres connections

2005-04-30 Thread Volkan YAZICI
Hi, On 4/29/05, Mauro Bertoli <[EMAIL PROTECTED]> wrote: > I need to connect to 2 differents Postgres 8.0.0 > databases located in the same machine using the same > PHP script with an "db wrapper object" instance > (pg_Connect)... simply a PHP page with contemporarily > 2 database connections...