Hello,
The following patch fixes the reading of a bytea field from a PgSQL database.
Btw is there someone working on pg's blob storage?
Joao Morais
Mailing lists / fpc-pascal / 2008-05
pqconnection patch
2 messages · 2 people · –
- Joao Morais 1
- Joost van der Sluis 1
Reply by email Subscribe to this list Your subscription
Read-only archive. Use j and k to move between messages.
Op woensdag 28-05-2008 om 13:52 uur [tijdzone -0300], schreef Joao Morais:
The following patch fixes the reading of a bytea field from a PgSQL database.
Thanks, applied.
Btw is there someone working on pg's blob storage?
I don't know anything about pg's blob storage, except for the separate functions to store and read blob-fields, given an OID. Problem with that approach is that you can't tell if a field contains a blob or not. Because the field doesn't contain a blob but a reference to a blob. How can you detect that this a field in fact is such a reference?
So the only way to use pg's blob's is to let the programmer store the blob's. But it would be usefull if we build a wrapper around this, yes.
Joost.
Show quoted text 25 lines
Joao Morais
platte tekst document bijlage (pgconnection.pp.patch)
Index: packages/fcl-db/src/sqldb/postgres/pqconnection.pp
===================================================================
--- packages/fcl-db/src/sqldb/postgres/pqconnection.pp (revision 11085)
+++ packages/fcl-db/src/sqldb/postgres/pqconnection.pp (working copy)
@@ -103,6 +103,7 @@
SErrPrepareFailed = 'Preparation of query failed.';
const Oid_Bool = 16;
+ Oid_Bytea = 17;
Oid_Text = 25;
Oid_Oid = 26;
Oid_Name = 19;
@@ -395,6 +396,7 @@
end;
// Oid_text : Result := ftstring;
Oid_text : Result := ftBlob;
+ Oid_Bytea : Result := ftBlob;
Oid_oid : Result := ftInteger;
Oid_int8 : Result := ftLargeInt;
Oid_int4 : Result := ftInteger;
_______________________________________________
fpc-pascal maillist -
http://lists.freepascal.org/mailman/listinfo/fpc-pascal