Issue 21133 - Postgres table joins using unixODBC fails
Summary: Postgres table joins using unixODBC fails
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: Frank Schönheit
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-10-13 21:38 UTC by hjmanalam
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description hjmanalam 2003-10-13 21:38:27 UTC 
using debian sid and the latest PG & odbc-postgresql (7.3.4-7), unixodbc(2.2.4-8), i 
can query data fine on a remote PG database (ver 7.3.2r1-6) as long as the data is 
in one table, but as soon as I try to join tables, I get an error pop-up: 
 
[unixODBC]ERROR: Column Reference "ctid" is ambiguous 
 
Is this an error coming from the unixODBC lib or is it referring to a problem that OOo 
has with unixODBC?  In any case, is there a fix or workaround?
Comment 1 hjmanalam 2003-10-14 01:28:36 UTC 
OK - after a half day of chasing down rumors and deciphering ODBC
trivia, it looks like the reason for this is that OOo wants to use
something called 'dynamic cursors' to increase the efficiency of the
query and either postgres or the version of unixODBC that I'm using,
doesn't like using them.  The fix is to include the following lines in
the DSN stanza of your /etc/odbc.ini file:

EnableScrollableCursors = No
UpdatableCursors = No
SelectLoops = No

These were all inserted at the same time, so I'm not sure which of
them actually did the trick, but I also had to restart the whole
system (not only OOo), as restarting OOo by itself didn't do the
trick.  If you know what service actually reads this file, I'd like to
know.
Comment 2 hans_werner67 2004-02-02 12:58:01 UTC 
change subcomponent to 'none'
Comment 3 Frank Schönheit 2005-02-17 12:10:10 UTC 
closing