Open daniel-perry opened 8 years ago
OID's are actually used all over PostgreSQL for many things; in this case, OIDs are being used for denoting the type of the data, which is a very common use. Basically I have no type conversion defined for PostgreSQL's RECORD
type (which is itself just a placeholder for the type of any record). I'm not sure if I even have a good idea of what to do with record types off the top of my head.
Eventually I do need to address all OIDs so these problems stop happening. I have been unable to work on PostgreSQL due to other projects dominating my time, but this will change March 1 and I'll devote most of my time to PostgreSQL again. In the meantime, I'm open to PRs if you have an idea on how to deal with RECORD types.
I have the following database:
https://physionet.org/mimic2/demo/
I can run simple queries fine, when I run a more complicated query like this:
I get the following error:
This query works fine in both psql and via psycopg2.
Digging around it appears OID's are a little used feature of PosgreSQL (http://www.postgresql.org/docs/8.4/interactive/runtime-config-compatible.html#GUC-DEFAULT-WITH-OIDS), which might be why PostgreSQL.jl is having trouble converting a result using OID. But since psycopg2 supports them, I though it was worth opening the issue.
Julia version: Version 0.4.2 (2015-12-06 21:47 UTC)