Hi again,
After trying to use pg_get_catalog_foreign_keys() to replace what I had before,
I notice one ambiguity which I think is a serious problem in the machine-readable context.
The is_array OUT parameter doesn't say which of the possibly many fkcols that is the array column.
One example:
fktable | fkcols | pktable | pkcols | is_array
----------------------+-----------------------+--------------+-------------------+----------
pg_constraint | {conrelid,conkey} | pg_attribute | {attrelid,attnum} | t
Is the array "conrelid" or is it "conkey"? As a human, I know it's "conkey", but for a machine to figure out, one would need to join information_schema.columns and check the data_type or something similar.
Suggestions on how to fix:
* Make is_array an boolean[], and let each element represent the is_array value for each fkcols element.
* Change interface to be more like information_schema, and add a "ordinal_position" column, and return each column on a separate row.
I think I prefer the latter since it's more information_schema-conformant, but any works.
/Joel
