psql problem - Mailing list pgsql-general

From Gary Fu
Subject psql problem
Date
Msg-id i2abqb$2lne$1@news.hub.org
Whole thread Raw
Responses Re: psql problem  (Andy Colson <andy@squeakycode.net>)
Re: psql problem  (Ireneusz Pluta <ipluta@wp.pl>)
List pgsql-general
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 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 large size of
the script file.  I tried 'psql < script.sql' and 'cat script.sql |
psql' with the same result.

However, I tried it on another client host (CentOS 5.5 32 bits), I don't
see this problem.

Any idea and suggestion ?

Thanks,
Gary

pgsql-general by date:

Previous
From: "Edmundo Robles L."
Date:
Subject: Question about SCO openserver and postgres...
Next
From: Howard Rogers
Date:
Subject: Re: Bitmask trickiness