Error connecting to PostgreSQL 8.3.4 database

[nescafe2002]

Test Connection: Connection successful

On expanding data connection or running query bound to connection, the following error appears:

_NpgsqlException - 42601: syntax error at or near ""TableCatalog""_

Sniffed problematic SQL query:

SELECT table_catalog "TableCatalog", table_name "TableName" 
FROM information_schema.tables 
WHERE table_type='BASE TABLE' AND table_schema='public'

Suggested fix:

Change this line:

SELECT table_catalog "TableCatalog", table_name "TableName"

Into:

SELECT table_catalog AS "TableCatalog", table_name AS "TableName"

Probably more files could be 'fixed' this way?

[fknx]

I've applied the fix you suggested and tested it with PostgreSQL 8.3.23 and it seems to work fine. I've release a new version (0.1.1) containing the fix.

It would be great if you could verify whether this solves your issue.

[nescafe2002]

Tested, issue is solved. Thanks.