Re: psql problem

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

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 anything,
since I tried another case (with different comment and table) and the
problem still happens but the size 1484 is not the break point.

I think this may be CentOS(64 bits)/ssh related, since I don't have the
problem with CentOS(32 bits) and we have the same application to install
the tables with the same command on mandriva.

Thanks,
Gary

Sample file:

/*

=head1 NAME

ProblemFiles

=head1 DESCRIPTION

The ProblemFiles table is used to store the file names that have
problem to be handled by PollAndArchive and VerifyFiles programs.

=head1 FIELDS

ProblemId - The Id for the problem file
FileName - The full file name with problem
Reason - The reason for the file to be inserted
IsDN - This FileName is a DN (DDR or DS) file
DNFile - The DN file for the FileName in problem
DNType - The DN type (1 for DDR, 2 for DS, 0 for Unknown)
FtpPath - The ftp incoming path for the problem file, so we know
where to get
the file again if necessary
Adhoc - None for sd3e normal subscription,
SD3E for sd3e adhoc (handled as subscription)
Land/Ocean/Atmosphere/Ozone/Sounder/NICSE for peates' ad-hoc
CkSum - Th checksum of the file (only for file with DDR file on Reason :
Missing, Duplicate, so that they can be verified again if
necessary
test test test tt

=cut

*/

--
-- Name: ProblemFiles Type: Table
--

create table ProblemFiles
(
ProblemId serial primary key,
FileName varchar(256) not null,
Reason varchar(16) not null,
IsDN int not null default 0,
DNFile varchar(256) null,
DNType int not null default 1,
InsertTime timestamp not null default now()
);