Re: [SQL] Problems invoking psql. Help please.

2002-11-18 Thread Tom Lane
Hugh Esco <[EMAIL PROTECTED]> writes: > Any ideas on what my next steps should be would be greatly appreciated. Start over: delete your PG installation and reinstall the Debian package. It seems very clear that you've got an incomplete package. regards, tom lane

Re: [SQL] Problems invoking psql. Help please.

2002-11-18 Thread Hugh Esco
Thank you so much, Mallah, Tomasz Myrta, Luis Sousa, Achilleus Mantzios, Tom Lane, Bill Eaton and Oliver Elphick. I have chmod 755 my readpgenv file, and then copied the shell script suggested by Tomasz Myrta into that file, yielding these results: biko:/usr/lib/postgresql/bin# cd /usr/bin biko:

Re: [SQL] Trees: maintaining pathnames

2002-11-18 Thread Dan Langille
On 18 Nov 2002 at 1:09, [EMAIL PROTECTED] wrote: > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > NotDashEscaped: You need GnuPG to verify this message > > > Instead of storing the path in each row, why not let Postgres > take care of computing it with a function? Then make a view > and

Re: [SQL] Problems invoking psql. Help please.

2002-11-18 Thread Oliver Elphick
On Sun, 2002-11-17 at 20:24, [EMAIL PROTECTED] wrote: > > You seem to have a very bizarre setup there --- there is no such thing > > as "readpgenv" in the standard Postgres distribution, and > > /usr/lib/postgresql/bin/ isn't the standard place to put the executable > > files either. Perhaps the a

Re: [SQL] Problems invoking psql. Help please.

2002-11-18 Thread Luis Sousa
Hi there, I'm using debian woody. If you post your configuration files that are in /etc/postgresql/ maybe i can help you. Regards, Luis Sousa Hugh Esco wrote: Hey folks: I am able to consistently start and stop the postgreSQL server and to access it across our office network with pgAdmin II.