Bug 103280

Summary: unixODBC doesn't work with PostgreSQL
Product: [Retired] Red Hat Linux Beta Reporter: Chris Ricker <chris.ricker>
Component: unixODBCAssignee: Fernando Nasser <fnasser>
Status: CLOSED RAWHIDE QA Contact: David Lawrence <dkl>
Severity: medium Docs Contact:
Priority: medium    
Version: beta1CC: marius.andreiana
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2003-10-15 22:48:26 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Chris Ricker 2003-08-28 15:05:14 UTC
Out of the box, unixODBC doesn't work with PostgreSQL

/etc/odbcinst.ini has

[PostgreSQL]
Description     = ODBC for PostgreSQL
Driver      = /usr/lib/libodbcpsql.so
Setup       = /usr/lib/libodbcpsqlS.so
FileUsage       = 1

However, /usr/lib/libodbcpsql.so (symlink to .so.2) only exists if
unixODBC-devel is installed

Either unixODBC needs to require unixODBC-devel (which would be very lame) or
the symlink needs to be moved from the unixODBC-devel package to the unixODBC
package

Comment 1 Bill Nottingham 2003-08-28 19:18:01 UTC
Or, the INI file edited to mention the actual file name?

Comment 2 Chris Ricker 2003-08-28 19:28:28 UTC
That would work (and is what I've done), but most documentation (and the
ODBCConfig program, which would also have to be updated) do it without the .1 / .2

Comment 3 Chris Ricker 2003-10-15 22:48:26 UTC
This looks fixed by today's rawhide -- now /usr/lib/libodbcpsql.so is in
unixODBC instead of unixODBC-devel

thanks!