| Subject: | Creating column_info fails with Postgres 7.1.2 |
Hello,
When I try to create your view Postgres 7.1.2, it fails with the following error:
ERROR: No such attribute or function 'objsubid'
####
I have a couple suggestions to improve this interface.
1. Have you looked at using the functions in DBD::Pg to get the data you want? This code generates an array of hashrefs almost how you want:
my $attrs = $dbh->func($table, 'table_attributes')
It doesn't return comments now, but perhaps it could be patched to do that, or your application could store comments in the application rather than the DB comment fields.
I think DBD::Pg is designed so that it uses different code with different versions of Postgres,
perhaps providing better compatibility than your hardcoded view of the system tables.
2. It would be nice if it wasn't required to create a DB view to use module. One option would be to use DBD::Pg as described above. Other options might include using complex select statements instead, or silenty creating the view for the user if it doesn't already exist (but perhaps using a less common name like "_html_formengine_col_info"... or something.
Thanks!
Mark