pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postgres error message limited to 70 char in sqlca
2+ messages / 2 participants
[nested] [flat]

* Postgres error message limited to 70 char in sqlca
@ 2004-05-07 09:45  =?iso-8859-1?B?UGhpbGlwcGUgU2VtcOk=?=   <psempe@partner.auchan.fr>
  0 siblings, 1 reply; 2+ messages in thread

From: Philippe Sempé @ 2004-05-07 09:45 UTC (permalink / raw)
  To: pgsql-interfaces

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"
this thread: http://archives.postgresql
org/pgsql-interfaces/2004-05/msg00011.php

Thanks

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Postgres error message limited to 70 char in sqlca
@ 2004-05-22 11:34  Michael Meskes <meskes@postgresql.org>
  parent: =?iso-8859-1?B?UGhpbGlwcGUgU2VtcOk=?=   <psempe@partner.auchan.fr>
  0 siblings, 0 replies; 2+ messages in thread

From: Michael Meskes @ 2004-05-22 11:34 UTC (permalink / raw)
  To: Philippe Sempé <psempe@partner.auchan.fr>; +Cc: pgsql-interfaces

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!



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-05-22 11:34 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-05-07 09:45 Postgres error message limited to 70 char in sqlca =?iso-8859-1?B?UGhpbGlwcGUgU2VtcOk=?=   <psempe@partner.auchan.fr>
2004-05-22 11:34 ` Michael Meskes <meskes@postgresql.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox