Thread: Postgres error message limited to 70 char in sqlca

Postgres error message limited to 70 char in sqlca

From
"Philippe Sempé "
Date:
Hi,
 
1 ) Can I tune postgres to force using more than 70 characters in "sqlca.sqlerrm.sqlerrmc" ?
 
It's too short, i've got some message truncated like that:
"column 'flow_cons_date' is of type timestamp without time zo [code=-400]"
 
I'd like to have more information in my application log files !
 
I've tried to change the value in sqlca.h but there's still only 70 characters usefull.
 
2) I'm still looking for an answer to "socket command type unknow"
 
Thanks

Re: Postgres error message limited to 70 char in sqlca

From
Michael Meskes
Date:
On Fri, May 07, 2004 at 11:45:59AM +0200, Philippe Sempé wrote:
> 1 ) Can I tune postgres to force using more than 70 characters in "sqlca
> sqlerrm.sqlerrmc" ?

It's defined in .../include/sqlca.h:

#define SQLERRMC_LEN    70

> I've tried to change the value in sqlca.h but there's still only 70
> characters usefull.

Did you change this before you compile the libraries? If you just change
the user side, it won't help much.

> 2) I'm still looking for an answer to "socket command type unknow"
> this thread: http://archives.postgresql
> org/pgsql-interfaces/2004-05/msg00011.php

Sorry, never heard about this kind of failure. Does it still happen with
newer PostgreSQL versions?

Michael

--
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!