Re: command length?

>
>Stev,
>
>> 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?
>
>Yes.   Watch the PostgreSQL Log file, assuming that you started Postgres
with 
>a log file.   If you didn't, then re-start Postgres with the output funneled 
>to a log.  If necessary, up the debug level.


thanx. i used psql to load the record one field (OK, 5 fields:) at a time,
and figured it out. the problem records have words like "don't" in them,
which is screwing with the delimiters on the command line i am passing in,
so i need to change them to be "don\'t".

but thanks, i will turn on the log, it should help in the future . . . .

BTW, i appreciate the quick answers to postings here . . . .






---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html