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... Firstly

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 bulky

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 indexes

[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