I've recently come across a couple of minor problems(?) in the ODBC driver:
1) When querying a view eg:
SELECT * FROM pg_tables;
the driver will always attempt (and fail) to retrieve the oid column thus
returning an ODBC call failed error. This occurs whether the 'Show OID
Column' is selected or not. I can see the obvious overhead in checking
whether or not a query is on a view or table - is the current behaviour the
best solution or is there another way around this (other than specifying
column names in queries)?
2) Under OID options, if you uncheck 'Show Column', the 'Fake Index' option
will correctly be greyed out. If it is ticked when it is greyed though, the
driver will still connect with: showoid='0',fakeoidindex='1'. Can this cause
any problems?
Regards,
Dave.
--
Dave Page, Network & Systems Manager, The Vale Housing Association Ltd.
dpage@vale-housing.co.uk
http://www.vale-housing.co.uk (Work)
http://www.pgadmin.freeserve.co.uk/ (Home of pgAdmin)
Beer can be a permanent solution - but only if you have enough of it!