search

mariuz / perl-dbd-firebird

Perl DBI driver for Firebird
15 stars 9 forks source link

dbi link is requiring table_info column_info and quote #33

Closed mariuz closed 3 years ago

mariuz commented 12 years ago

Hello I am trying to use your firebird DBI driver for firebird (perl-dbd-firebird). We are currently using firebird very much in our company. These are mainly versions 1.5 and 2.1, 2.5 (i hope it will work with your driver). I want to use your driver for connecting using dbi link (for postgresql). The problem is that dbi link is requiring table_info column_info and quote. And as far as i found out, your driver does not have needed 'column_info' method. Do you think you would be able to add this support? Unfortunately I am not perl guy, so I cannot handle this development stuff easily.

The code which dblink is using for testing dbi driver capabilities is also @github: https://github.com/davidfetter/DBI-Link/blob/master/dbi_link.sql#L1063

Unfortunatelly the code is 2 years old, but it is our only hope to connect internaly from postgres to firebird :)

regards!

Mariusz Białończyk

pilcrow commented 12 years ago

FWIW the code in question appears to check only COLUMN_NAME, ORDINAL_POSITION, and TYPE_NAME from column_info(), all of which are easy/tedious to find. The invocation is column_info(undef, $exact_schema, $exact_table_name, '%'). (Not sure what $exact_schema would be for our favorite schema-less DB. ;) )