Re: [GENERAL] database constraints

2004-10-06 Thread sklassen
* Ben <[EMAIL PROTECTED]> [2004-10-06 08:23:11 -0700]: > If I have have the table: > > create table foo > ( > a int references bar(id), > b int references baz(id) > ) > > ... how do I make sure one and only one of the columns a and b are > non-null? Is it even reasonable? ALTER TAB

Re: [GENERAL] error connecting to database

2004-10-01 Thread sklassen
* Alexander Cohen <[EMAIL PROTECTED]> [2004-10-01 14:42:07 -0400]: > Im trying to connect locally to a database on a running postgres > cluster. If i connect with psql, everything is fine and i can transact. > I i try and connect in my own app, i get this error: > > Could not connect to server:

Re: [GENERAL] Postgresql commands to display all functions and process/connections based on a database.

2004-10-01 Thread sklassen
* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [2004-09-28 17:28:25 -0400]: > . List all functions have been defined (e.g., defined through > pg/sql) within a database SELECT proname FROM pg_proc JOIN pg_language ON (pg_proc.prolang = pg_language.oid) WHERE pg_language.lanname = 'plpgsql'; -- Steven K