Re: Problem in GNATColl when using prepared queries: GNATCOLL.SQL.POSTGRES.GNADE.POSTGRESQL_ERROR is raised

["Thomas Løcke" <tl@ada-dk.org>]

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