It's been a couple of years since I did anything with Delphi7 and postgres,
but here are some things to try:
I don't think that adodb contains the appropriate driver to correctly
access postgresql. (I could be wrong, however). We ended up using an open
source system we installed into Delphi for the connections to the db. (
http://sourceforge.net/projects/zeoslib/ )
Also, we had the same problem with Blob data. We had to forego using the
bytea datatype and used oid specifically for storage of Blob data.
Hope this helps,
Derrick
----- Original Message -----
From: "Péter" <tyrial@freemail.hu>
To: <pgsql-novice@postgresql.org>
Sent: Sunday, October 09, 2005 2:58 PM
Subject: [NOVICE] delphi+adodb+postgresql+bytea
>
> Hi,
>
> I would like to use postgresql via adodb (delphi7), inserting and
> retrieving binary data using bytea field.
> Unfortunately I got error messages like:
> SELECT -> 'Query returned unhandled type 17'
> INSERT -> 'invalid type' (ftBlob/ftBytes/ftVarBytes)
>
> Did any of You have experience using bytea?
>
> Thanks for you help.
>
>
>
> ____________________________________________________________________________________________
> Kisbabád lesz? Kisbabád született? Tele vagy kérdésekkel, és nem tudod,
> hol találsz választ?
> Kukkants be a Babázóba! - www.babazo.hu
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
>
>