Re: [GENERAL] RE: cant connect

1999-04-11 Thread Gregory Maxwell
/usr/local/pgsql/data/pg_hba.conf On Sun, 11 Apr 1999, Vince Vielhaber wrote: > > redirected to general > - > > > We are trying to use psql on RedHat 5.2 to access a database on another > Redhat 5.2 box runing Postgres (started as user postgres: postmaster > > -

[GENERAL] RE: cant connect

1999-04-11 Thread Vince Vielhaber
redirected to general - We are trying to use psql on RedHat 5.2 to access a database on another Redhat 5.2 box runing Postgres (started as user postgres: postmaster -D /var/lib/pgsql -B 256 -i -d 3 &.) The backend start okay and we can access the data on the local

Re: [GENERAL] insert iff !exist

1999-04-11 Thread Karl DeBisschop
> How can you > > if(update row fails because doesn't exist, ie. returns 0)then(insert row) Depends on what interface you are using. In perl DBI, the return value of the a $dbh->do("update...") should be the nomber of rows inserted. Same with doing a sequence of $sth=$dbh->prepare("update