From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me
X-Spam-Level: 
X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00 autolearn=ham
	autolearn_force=no version=3.4.4
X-Google-Thread: 103376,89e2ed92b27de792
X-Google-NewGroupId: yes
X-Google-Attributes: gida07f3367d7,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII
Path: 
 g2news2.google.com!news2.google.com!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!news.glorb.com!news2.glorb.com!dotsrc.org!filter.dotsrc.org!news.dotsrc.org!not-for-mail
Date: Tue, 01 Mar 2011 09:34:28 +0100
From: =?ISO-8859-1?Q?Thomas_L=F8cke?= <tl@ada-dk.org>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
 rv:1.9.2.13) Gecko/20101210 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: comp.lang.ada
Subject: Re: Problem in GNATColl when using prepared queries:
 GNATCOLL.SQL.POSTGRES.GNADE.POSTGRESQL_ERROR
 is raised
References: <4d67ce9c$0$23765$14726298@news.sunsite.dk>
 <1on2yzc25jxpr.1offs3nb41fqk$.dlg@40tude.net>
 <4d67f3db$0$23762$14726298@news.sunsite.dk>
 <1dbprbhut7js1.jeytwwyjsya4$.dlg@40tude.net>
 <4d682437$0$23760$14726298@news.sunsite.dk>
 <1v42jcu30zmag$.1xz86498g3zsm.dlg@40tude.net>
 <4d6a6559$0$23761$14726298@news.sunsite.dk>
 <53b7f307-edd1-4e81-b50e-e70befc1a075@s18g2000vbe.googlegroups.com>
In-Reply-To: 
 <53b7f307-edd1-4e81-b50e-e70befc1a075@s18g2000vbe.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Message-ID: <4d6caf94$0$23757$14726298@news.sunsite.dk>
Organization: SunSITE.dk - Supporting Open source
NNTP-Posting-Host: 83.91.213.86
X-Trace: news.sunsite.dk
 DXC=`LXlh7FEmL1oDTKD0DTdP>YSB=nbEKnk;nM\f75cN1;41GQX8;5?Cn7RED9SjB8:69Qo^8G8>And=8D@:gN_ic77d<<FnKIjfC4
X-Complaints-To: staff@sunsite.dk
Xref: g2news2.google.com comp.lang.ada:18637
Date: 2011-03-01T09:34:28+01:00
List-Id: <comp.lang.ada>

On 2011-02-28 14:49, Emmanuel Briot wrote:
> Your analysis is correct.
> The fix here is actually trivial.
>
> in gnatcoll-sql-postgres-gnade.adb, replace the code for
>
>   function PQexecPrepared
>             (Conn : System.Address;
>              Name : String;
>              Nparams : Natural := 0;
>              Values  : CS.chars_ptr_array;
>              Lengths : System.Address := System.Null_Address;
>              Formats : System.Address := System.Null_Address;
>              Format  : Natural := 0) return System.Address;
>
> so that "Format" defaults to 1 instead of 0.
>
> That forces postgreSQL to return values as text instead of binary. The
> latter format is not supported by GNATCOLL (nor was it supported by
> GNADE). There is too much machine-dependent handling here.


This too works without a hitch using SVN revision 170922.

Thank you very much for fixing this.

I've signed up for the GPS maillist. Would that be a proper place to
report issues like this, or should I just use comp.lang.ada?

Personally I think GNATColl is awesome enough to have it's own maillist!

:o)

-- 
Thomas L�cke

Email: tl at ada-dk.org
Web: http//:ada-dk.org
http://identi.ca/thomaslocke