From: Bruce Stephens <bruce@cenderis.demon.co.uk>
To: pgsql-interfaces@postgresql.org
Subject: Problem with ODBC in current CVS?
Date: 28 Aug 2000 22:17:08 +0100
Message-ID: <87pumtnl0r.fsf@cenderis.demon.co.uk>
User-Agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.2 (Nike)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Lines: 19

I've been trying to get StarOffice 5.2 working with PostgreSQL grabbed
directly from CVS, and have been having no end of problems (I'm sure I
had this working with StarOffice 5.1 months ago, but I don't remember
how, alas).  (It probably doesn't help that I don't really understand
what ODBC is doing.)

Anyway, using the iodbc driver manager and libpsqlodbc, I seem to be
getting close.  StarOffice connects but shows no tables.  From the
libpsqlodbc log file, it appears to be trying this:

select relname,usename,relhasrules from pg_class,pg_user 
        where relkind = 'r' and relname !~ '^pg_|^dd_' and
        relname !~ '^xinv[0-9]+' and
        int4out(usesysid) = int4out(relowner)order by relname

which returns no rows when I try it by hand.  These int4out's look
iffy to me.  Aren't usesysid and relowner int2?  Why does it need to
do any conversion anyway?  Why not just usesysid=relowner?  What am I
missing?