Re: [GENERAL] PQfformat question and retrieving bytea data in C

t, so I changed bytea_output to 'hex', and DBD::Pg is also happy now (I also read that the hex format is more efficient). -- Jason Armstrong -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] PQfformat question and retrieving bytea data in C

-- 30da00090132420520203137323030 This is the data I'm expecting to get back. Is the '00' (third byte) causing the problem? The data looks the same at a certain place (ie it starts with the same byte 30, then the C code has 22 bytes whereas the db hex dump has 7 bytes, then

[GENERAL] Importing oracle data dump files to postgresql

Does anyone know of utilities that will enable importing oracle data pump files (produced via expdp) into postgresql? Note that I do not have an installation of Oracle, only the binary output file produced. -- Jason Armstrong -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

[GENERAL] Index on parent/child hierarchy

aster AS t3 ON t4.parent=t3.id INNER JOIN uuid.master AS t2 ON t3.parent=t2.id INNER JOIN uuid.master AS t1 ON t2.parent=t1.id WHERE t1.id=UUID Apart from creating a separate table to keep track of the counts, is there a good way to index the table to help? Regards, -- Jason Armstrong -- Sen

Re: [GENERAL] Workqueue performance

erforming. I decided to do this in application code instead, via IPC. -- Jason Armstrong -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Workqueue performance

h data to process by a view which shows just the entries which are in the workqueue table. But then I will have to deal with cleaning all these entries up at some point, which could get complicated in itself. Thanks for any ideas. -- Jason Armstrong -- Sent via pgsql-general mai

[GENERAL] Table name from directory

How do I get the name of a database from a directory on disk (eg $datadir/base/16494)? -- Jason Armstrong -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Excluding null return values from functions

27;field', 'value') as result from mydata where result is not null; -- Jason Armstrong -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Returning bigint from C extension

t index it, or sort on it either. (And, as a side note, is the above code the correct way to use bytea data from C?) Regards, -- Jason Armstrong -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general