| From: | Andy Colson <andy(at)squeakycode(dot)net> |
|---|---|
| To: | Gary Fu <gary(dot)fu(at)sigmaspace(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: psql problem |
| Date: | 2010-07-23 01:02:40 |
| Message-ID: | 4C48EA30.90304@squeakycode.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 '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
Line endings?
How about a sample?
What comment style: -- /* (* # ; ' //
-Andy
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2010-07-23 02:28:45 | Re: Finding last checkpoint time |
| Previous Message | Noah Misch | 2010-07-22 22:41:39 | Changing pg_attribute.attislocal |