From psempe@partner.auchan.fr Fri May  7 09:46:22 2004
X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id BC546D1B4E6
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Fri,  7 May 2004 06:46:22 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 95269-02
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Fri,  7 May 2004 06:46:04 -0300 (ADT)
Received: from ilx997x003.auchan.com (varelay1.auchan.com [193.109.251.161])
	by svr1.postgresql.org (Postfix) with ESMTP id 69DD9D1ECC9
	for <pgsql-interfaces@postgresql.org>;
	Fri,  7 May 2004 06:46:00 -0300 (ADT)
Received: from relay-out.auchan.com (ilx997x003 [127.0.0.1])
	by ilx997x003.auchan.com (8.12.10/8.12.10) with ESMTP id i479NhVZ000482
	for <pgsql-interfaces@postgresql.org>; Fri, 7 May 2004 11:23:43 +0200
Received: from relay-in.auchan.com (localhost.localdomain [127.0.0.1])
	by relay-out.auchan.com (8.12.10/8.12.10) with ESMTP id i479k15M001441
	for <pgsql-interfaces@postgresql.org>; Fri, 7 May 2004 11:46:01 +0200
Received: from WNT99714444 ([128.240.111.98])
	by relay-in.auchan.com (8.12.10/8.12.10) with ESMTP id i479k0w4001418
	for <pgsql-interfaces@postgresql.org>; Fri, 7 May 2004 11:46:00 +0200
MIME-Version: 1.0
Message-Id: <409B5AD7.000037.02700@WNT99714444>
Date: Fri, 7 May 2004 11:45:59 +0200 (Paris, Madrid (heure d'été))
Content-Type: Multipart/Alternative;
	boundary="------------Boundary-00=_NG8C8ID3LVC000000000"
X-Mailer: IncrediMail (2501361)
From: "=?iso-8859-1?B?UGhpbGlwcGUgU2VtcOk=?=  " <psempe@partner.auchan.fr>
To: <pgsql-interfaces@postgresql.org>
Subject: Postgres error message limited to 70 char in sqlca
X-FID: FLAVOR00-NONE-0000-0000-000000000000
X-Priority: 3
X-Antivirus: avast! (VPS 0419-1, 06/05/2004), Outbound message
X-Antivirus-Status: Clean
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Amavis-Alert: BAD HEADER Non-encoded 8-bit data (char E9 hex) in message
	header 'Date'
	Date: ... 11:45:59 +0200 (Paris, Madrid (heure d'\351t\351))\n
	^
X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=HTML_50_60,
	HTML_MESSAGE, HTML_TAG_EXISTS_TBODY
X-Spam-Level: 
X-Archive-Number: 200405/18
X-Sequence-Number: 4910

--------------Boundary-00=_NG8C8ID3LVC000000000
Content-Type: Text/Plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,=0D
=0D
1 ) Can I tune postgres to force using more than 70 characters in "sqlca
sqlerrm.sqlerrmc" ?=0D
=0D
It's too short, i've got some message truncated like that:=0D
"column 'flow_cons_date' is of type timestamp without time zo [code=3D-400]=
"=0D
=0D
I'd like to have more information in my application log files !=0D
=0D
I've tried to change the value in sqlca.h but there's still only 70
characters usefull.=0D
=0D
2) I'm still looking for an answer to "socket command type unknow"=0D
this thread: http://archives.postgresql
org/pgsql-interfaces/2004-05/msg00011.php=0D
=0D
Thanks
--------------Boundary-00=_NG8C8ID3LVC000000000
Content-Type: Text/HTML;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"IncrediMail 1.0" name=3DGENERATOR>
<!--IncrdiXMLRemarkStart>
<IncrdiX-Info>
<X-FID>FLAVOR00-NONE-0000-0000-000000000000</X-FID>
<X-FVER>4.0</X-FVER>
<X-CNT>;</X-CNT>
</IncrdiX-Info>
<IncrdiXMLRemarkEnd-->
</HEAD>
<BODY style=3D"BACKGROUND-POSITION: 0px 0px; FONT-SIZE: 12pt; MARGIN: 5px 1=
0px 10px; FONT-FAMILY: Arial" bgColor=3D#ffffff background=3D"" scroll=3Dye=
s ORGYPOS=3D"0">
<TABLE id=3DINCREDIMAINTABLE cellSpacing=3D0 cellPadding=3D2 width=3D"100%"=
 border=3D0>
<TBODY>
<TR>
<TD id=3DINCREDITEXTREGION style=3D"FONT-SIZE: 12pt; CURSOR: auto; FONT-FAM=
ILY: Arial" width=3D"100%">
<DIV>Hi,</DIV>
<DIV>&nbsp;</DIV>
<DIV>1 ) Can I tune postgres to force using more than 70 characters in "sql=
ca.sqlerrm.sqlerrmc" ?</DIV>
<DIV>&nbsp;</DIV>
<DIV>It's too short, i've got some message truncated like that:</DIV>
<DIV>"column 'flow_cons_date' is of type timestamp without time zo [code=3D=
-400]"</DIV>
<DIV><STRONG><EM></EM></STRONG>&nbsp;</DIV>
<DIV>I'd like to have more information in my application log files !</DIV>
<DIV>&nbsp;</DIV>
<DIV>I've tried to change the value in sqlca.h but there's still only 70 ch=
aracters usefull.</DIV>
<DIV>&nbsp;</DIV>
<DIV>2) I'm still looking for an answer to "socket command type unknow"</DI=
V>
<DIV>this thread: <A href=3D"http://archives.postgresql.org/pgsql-interface=
s/2004-05/msg00011.php">http://archives.postgresql.org/pgsql-interfaces/200=
4-05/msg00011.php</A></DIV>
<DIV>&nbsp;</DIV>
<DIV>Thanks</DIV></TD></TR>
<TR>
<TD id=3DINCREDIFOOTER width=3D"100%">
<TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"100%">
<TBODY>
<TR>
<TD width=3D"100%"></TD>
<TD id=3DINCREDISOUND vAlign=3Dbottom align=3Dmiddle></TD>
<TD id=3DINCREDIANIM vAlign=3Dbottom align=3Dmiddle></TD></TR></TBODY></TAB=
LE></TD></TR></TBODY></TABLE></BODY></HTML>
--------------Boundary-00=_NG8C8ID3LVC000000000--




From meskes@postgresql.org Sat May  22 11:34:36 2004
X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 90408D1B16A
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Sat, 22 May 2004 08:34:36 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 56745-05
	for <pgsql-interfaces-postgresql.org@localhost.postgresql.org>;
	Sat, 22 May 2004 08:34:19 -0300 (ADT)
Received: from moutng.kundenserver.de (moutng.kundenserver.de
	[212.227.126.176])
	by svr1.postgresql.org (Postfix) with ESMTP id 63585D1B1DA
	for <pgsql-interfaces@postgresql.org>;
	Sat, 22 May 2004 08:34:15 -0300 (ADT)
Received: from [212.227.126.207] (helo=mrelayng.kundenserver.de)
	by moutng.kundenserver.de with esmtp (Exim 3.35 #1)
	id 1BRUla-0000ng-00; Sat, 22 May 2004 13:34:14 +0200
Received: from [80.142.167.62] (helo=fam-meskes.de)
	by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1)
	id 1BRUla-0007sN-00; Sat, 22 May 2004 13:34:14 +0200
Received: from feivel (feivel.fam-meskes.de [172.26.14.14])
	by fam-meskes.de (Postfix) with ESMTP
	id DE00A10EF53; Sat, 22 May 2004 13:34:47 +0200 (CEST)
Received: by feivel (Postfix, from userid 1000)
	id CDAF44AE74; Sat, 22 May 2004 13:34:12 +0200 (CEST)
Date: Sat, 22 May 2004 13:34:12 +0200
From: Michael Meskes <meskes@postgresql.org>
To: Philippe =?utf-8?B?U2VtcMOp?= <psempe@partner.auchan.fr>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Postgres error message limited to 70 char in sqlca
Message-ID: <20040522113412.GB5714@1>
Mail-Followup-To: Philippe =?utf-8?B?U2VtcMOp?= <psempe@partner.auchan.fr>,
	pgsql-interfaces@postgresql.org
References: <409B5AD7.000037.02700@WNT99714444>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <409B5AD7.000037.02700@WNT99714444>
User-Agent: Mutt/1.5.6i
Content-Transfer-Encoding: quoted-printable
X-Provags-ID: kundenserver.de abuse@kundenserver.de
	auth:da5cff6069dd6897c77170232368d0ba
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=RCVD_IN_NJABL,
	RCVD_IN_SORBS
X-Spam-Level: 
X-Archive-Number: 200405/29
X-Sequence-Number: 4921

On Fri, May 07, 2004 at 11:45:59AM +0200, Philippe Semp=C3=A9 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

--=20
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!