Re: [GENERAL] libpq error codes

2000-06-21 Thread Tom Lane
Denis Perchine <[EMAIL PROTECTED]> writes: > And you use PIPE, but I use sockets. If I just do psql -d db, all is > as you've said, but if I do psql -d db -h localhost the pictures is as > following: Works the same for me with either pipe or socket connection. I think something must be broken on

Re: [GENERAL] libpq error codes

2000-06-21 Thread Denis Perchine
> > If I shutdown postgres between queries I get: > > > query: 1024: 'select count(*) from pg_class' > > ResStatus: PGRES_FATAL_ERROR > > Status: 0 > > except: pqReadData() -- read() failed: errno=32 > > ïÂÏÒ×ÁÎÎÙÊ ËÁÎÁÌ > > What version are you running, and are you sure you are using libpq > c

Re: [GENERAL] Postgres with php3

2000-06-21 Thread Andrew McMillan
Carsten Huettl wrote: > In this situation of testing I start postgresql or the postmaster > manually. It works. I can login. Create dbs and a smple of tables. > But I cannot connct via the phpPGadmin thats the point of trouble. Is php loading the pgsql.so module? Does PHP on Red Hat use dynamic

Re: [GENERAL] Postgres with php3

2000-06-21 Thread Carsten Huettl
Date sent: Wed, 21 Jun 2000 09:36:26 +0200 From: "Poul L. Christiansen" <[EMAIL PROTECTED]> To: Carsten Huettl <[EMAIL PROTECTED]> Copies to: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject:Re: [GENERAL] Postgres with php

RE: [GENERAL] Win 9x support

2000-06-21 Thread Joost Kraaijeveld
> I see that postgre supports win32, but all I see mentioned is > NT. Does > postgre run on Win 9x? I don't want this as a production environment, > but need it for development. No, as far as I know it does not run on 95/98. Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel:

[GENERAL] Win 9x support

2000-06-21 Thread Matthew
I see that postgre supports win32, but all I see mentioned is NT. Does postgre run on Win 9x? I don't want this as a production environment, but need it for development. Matt

[GENERAL] Re: [NOVICE] Postgres with php3

2000-06-21 Thread Carsten Huettl
> I haven't played with apache so am not sure what php3 is. But I'm sure you > first need to get postgres running. Go to /usr/doc/ and read the README postgresql runs. I have created a sample of dbs for testing with some tables. It runs perfekt at this point. I can see the db files in the PGDAT

[GENERAL] Omnis Driver

2000-06-21 Thread gauss
Is there a way or has anybody connected an Omnis (Omnis Studio / www.omnis.net) front end to a PGSQL database. The RAD says it will connect to Oracle, sybase, Informix, DB2 and MySQL. Any suggestions? Bryon

[GENERAL] PHP3 support

2000-06-21 Thread K Parker
>I have setup a RH 6.2 box with postgres. >The httpd (apache) has support for php3. >But I don't know if the rh installation builds >in the php3 support in postgres. Here is the configuration setup from my own build of PHP3 (as an apache module, supporting PostgreSQL): Configure command: ./co

Re: [GENERAL] libpq error codes

2000-06-21 Thread Tom Lane
Denis Perchine <[EMAIL PROTECTED]> writes: > If I shutdown postgres between queries I get: > query: 1024: 'select count(*) from pg_class' > ResStatus: PGRES_FATAL_ERROR > Status: 0 > except: pqReadData() -- read() failed: errno=32 > ïÂÏÒ×ÁÎÎÙÊ ËÁÎÁÌ What version are you running, and are you sur

[GENERAL] boolean isn't boolean?

2000-06-21 Thread Marc Britten
why does a boolean value return a t or an f? this goes against everything i know, i'm doing a php app(first time php first time postgres, but i have extensive knowledge of oracle, sybase, and more than a bit of MS SQL 6.5 n 7, plus extensive knowledge of c/c++ and java and perl and elisp) and i

Re: [GENERAL] Help:How do you find that how much storage is taken by the database??

2000-06-21 Thread Sevo Stille
Ron Peterson wrote: > > NEERAJ BANSAL wrote: > > > > Hi, > > > > How do you find that how much storage the data in the database or tables > > is taking in bytes or any other format??? > > Is there any command which tells you this??? > > ls -l /usr/local/pgsql/data/base Which would give you the

[GENERAL] table contraints and pg_dump

2000-06-21 Thread Bryan White
I have been looking at the new syntax in create table such as unique and primary key constraints (new as in I just noticed it, I don't know when it was added). It seems to me there is a minor gotcha when using pg_dump/psql to reload a database. When indexes were created separately pg_dump would

Re: [GENERAL] Postgres with php3

2000-06-21 Thread Poul L. Christiansen
I don't think Postgres is started by default. Open linuxconf and make it start every time your Redhat starts. PgAdmin requires ODBC drivers on the windows machine, have you got them? HTH, Poul L. Christiansen Carsten Huettl wrote: > Hello, > > I have setup a RH 6.2 box with postgres. > The htt

[GENERAL] NT + cygipc + postgresql = boom!

2000-06-21 Thread Andrea Aime
Well, I'm here once again... I've managed to install pgsql 7.02 on my NT box NT 4.0, SP6) with the latest cygwin's release (1.1) and I am using cypipc 1.05... I keep getting "error semaphore semaphore not equal 0" each time I make a query, and sometimes the backend freezes... Joost was right, it s