Hello, I recently found a bug on open source ZeosLib Database components for Lazarus (Object Pascal) which is when ZeosLib is used with PostgreSQL database server. Bug was that library simply removes any uuid column from select result set. Problem is now solved and current SVN includes fixes (fix was to first define uuid field type in library then read 16 bytes for uuid defined columns and finally convert byte information to string representation for displaying on the result set).
However, my additional tests on latest SNV version of the library resulted that there is a new bug while inserting values to uuid columns. Provided uuid value to be inserted is wrong in relevant columns. Considering string representation of uuid, only last section of the inserted uuid is correct. Discussing with ZeosLib developers and they are not sure how to pass that uuid value to libpq while saving. Current questions are; - Should it be direct string representation or 16 byte raw value? - If 16 byte raw value, is there any special way to build that 16 bytes from string representation? As nobody can be sure on ZeosLib side and I could not find such information on libpq documents on PostgreSQL web site. I decided to ask here for help. Thanks & regards, Ertan Küçükoğlu -- Sent via pgsql-general mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general