| Subject: | Problem with ODBC and PostgreSQL |
When accessing a PostgreSQL v8.2 database from a Win32 box using the
psqlODBC driver v8.03.04.00 along with DBIx::Class running on
ActiveState Perl v5.8.9; the following error appears:
unknown database Postgresql - using GenericSubQ dialect at
C:/Perl/site/lib/SQL/Abstract/Limit.pm line 406.
This error can be fixed when the following code is inserted into
_find_database_from_dbh() at line 365:
$driver = 'pg', last CASE if $name =~ /postgresql/i;
The database type is now recognized and paged results work properly.