Re: [GENERAL] psql problem

2010-07-28 Thread Gary Fu
On 07/27/2010 10:20 PM, Tom Lane wrote: Gary Fu 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

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-27 Thread Tom Lane
Gary Fu 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 1484 may not mean

Re: [GENERAL] psql problem

2010-07-24 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 lar

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 c

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 'p

Re: [GENERAL] psql problem

2010-07-22 Thread shakahsha...@gmail.com
On Jul 22, 5: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

[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 hangs

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 > s

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 > connec

Re: [GENERAL] psql problem describing tables

2000-01-19 Thread Sarah Officer
Let me clarify. The reason there is not data in my table is because I haven't inserted any yet. I inserted a row of data. It gets selected correctly, but I still can't describe the table. So the problem doesn't seem to be related to having an empty table. Sarah Sarah Officer wrote: > > I am

[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

[GENERAL] psql problem

1998-07-29 Thread John E. Garrott
Background: I recently upgraded my P166 Slackware based Linux system to glibc. Among other things: Kernel 2.0.35 XFree86 3.3.2 egcs 1.0.3a glibc 2.0.6 ncurses 4.2 tcl/tk 8.0 I decided, since my database is still small, to upgrade to postgres6.3.