Re: [GENERAL] psql problem

2010-07-28 Thread Greg Smith
Tom Lane wrote: The openssl installation I'm testing with is openssl-1.0.0a-1.fc13.x86_64 I don't know offhand what RHEL/CentOS 5.x are using but it's probably quite a lot older. Here's a CentOS 5.5 install that's kept up to date: $ rpm -qi openssl Name: openssl

Re: [GENERAL] psql problem

2010-07-28 Thread Gary Fu
On 07/27/2010 10:20 PM, Tom Lane wrote: Gary Fugary...@sigmaspace.com writes: Below is an example that I created. It works okay, but when I add any character in the comment or in the table definition, it fails (hangs). I checked the server process (with ps command), and I can see that

Re: [GENERAL] psql problem

2010-07-27 Thread Tom Lane
Gary Fu gary...@sigmaspace.com writes: Below is an example that I created. It works okay, but when I add any character in the comment or in the table definition, it fails (hangs). I checked the server process (with ps command), and I can see that connection is 'idle'. By the way, the size

Re: [GENERAL] psql problem

2010-07-25 Thread Ireneusz Pluta
Gary Fu pisze: I have a script to create a table with some comments in front. When I use the command 'psql -f script.sql' to load it, it hangs. However, if I remove the comments, OR remove some of the columns from the table, it works okay. It looks like to me, the psql will hang with

Re: [GENERAL] psql problem

2010-07-23 Thread Gary Fu
On 07/22/2010 09:02 PM, Andy Colson wrote: On 07/22/2010 04:03 PM, Gary Fu wrote: Hi, System information: - psql 8.4.4 on a client with CentOS 5.5 (64 bits) - postgres 8.4.4 on the server with CentOS 5.5 (64 bits) - the client is connected with vpn I have a script to create a table with some

[GENERAL] psql problem

2010-07-22 Thread Gary Fu
Hi, System information: - psql 8.4.4 on a client with CentOS 5.5 (64 bits) - postgres 8.4.4 on the server with CentOS 5.5 (64 bits) - the client is connected with vpn I have a script to create a table with some comments in front. When I use the command 'psql -f script.sql' to load it, it

Re: [GENERAL] psql problem

2010-07-22 Thread shakahsha...@gmail.com
On Jul 22, 5:03 pm, Gary Fu gary...@sigmaspace.com wrote: Hi, System information: - psql 8.4.4 on a client with CentOS 5.5 (64 bits) - postgres 8.4.4 on the server with CentOS 5.5 (64 bits) - the client is connected with vpn I have a script to create a table with some comments in front.  

Re: [GENERAL] psql problem

2010-07-22 Thread Andy Colson
On 07/22/2010 04:03 PM, Gary Fu wrote: Hi, System information: - psql 8.4.4 on a client with CentOS 5.5 (64 bits) - postgres 8.4.4 on the server with CentOS 5.5 (64 bits) - the client is connected with vpn I have a script to create a table with some comments in front. When I use the command

Re: [GENERAL] PSQL Problem

2000-03-20 Thread Alfred Perlstein
* Tomas TPS Ulej [EMAIL PROTECTED] [000319 20:19] wrote: root@[master /usr/ports/databases/p5-DBI] # psql setup Connection to database 'setup' failed. connectDB() -- connect() failed: No such file or directory Is the postmaster running at 'localhost' and accepting connections on Unix socket

RE: [GENERAL] PSQL Problem

2000-03-13 Thread Tomas TPS Ulej
On Sun, Mar 12, 2000 at 04:52:15PM +0100, Tomas TPS Ulej wrote: root@[master /usr/ports/databases/p5-DBI] # psql setup Connection to database 'setup' failed. connectDB() -- connect() failed: No such file or directory Is the postmaster running at 'localhost' and accepting connections on

[GENERAL] psql problem describing tables

2000-01-19 Thread Sarah Officer
I am running postgres 6.5.3 on an SGI. I haven't done much except create a few tables and indexes. When I enter psql and type '\d', all my tables and indexes are listed. When I type '\d tablename' however, I get the following message: \d Images ERROR: typeidTypeRelid: Invalid type - oid = 0