Re: command length? - Mailing list pgsql-novice

From stev knowles
Subject Re: command length?
Date
Msg-id 3.0.3.32.20020628150832.013cba50@pop3.norton.antivirus
Whole thread Raw
In response to Re: command length?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: command length?
Re: command length?
List pgsql-novice
>Stev,
>
>> is there a limit to how long a *line* can be in a command? i understand
>> that a command can continue across several lines, but is there a limit to
>> the length of a line?
>
>No, there is no limit.  Well, maybe 32,565 characters, but not less than
that.

i am using a C interface into the database, based on the example code.
occasionally, one of my INSERT's fails, with: INSERT command failed:
PGRES_FATAL_ERROR.

other inserts work correctly. re-entering the data doesnt seem to help, and
a comparison with a successful INSERT doesnt yield anything obvious. is
there any way to get a more granular answer for what it didnt like?





pgsql-novice by date:

Previous
From: "James Kelty"
Date:
Subject: Re: NFS/NAS
Next
From: Josh Berkus
Date:
Subject: Re: command length?