| Lists: | Postg사설 토토SQL : Postg사설 |
|---|
| From: | " Philippe Sempé " <psempe(at)partner(dot)auchan(dot)fr> |
|---|---|
| To: | <pgsql-interfaces(at)postgresql(dot)org> |
| Subject: | Postgres error message limited to 70 char in sqlca |
| Date: | 2004-05-07 09:45:59 |
| Message-ID: | 409B5AD7.000037.02700@WNT99714444 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | Postg사설 토토SQL : Postg사설 |
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
| From: | Michael Meskes <meskes(at)postgresql(dot)org> |
|---|---|
| To: | Philippe Sempé <psempe(at)partner(dot)auchan(dot)fr> |
| Cc: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: Postgres error message limited to 70 char in sqlca |
| Date: | 2004-05-22 11:34:12 |
| Message-ID: | 20040522113412.GB5714@1 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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(at)jabber(dot)org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!