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> (raw)
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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: bruce@cenderis.demon.co.uk
Subject: Re: Problem with ODBC in current CVS?
In-Reply-To: <87pumtnl0r.fsf@cenderis.demon.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox