From: Joel Burton <jburton@scw.org>
To: pgsql-interfaces@postgresql.org
To: psql-bugs@postgresql.org
Subject: Pg7.1-beta and CVS psqlodbc.dll: No views
Date: Wed, 22 Nov 2000 15:51:13 -0500
Message-ID: <3A1BEB71.28895.44245B38@localhost> (raw)
I'm using 7.1beta (gotta love those views with unions, distincts,
etc.!). As has been noted earlier, the 6.50 ODBC driver (current
stable version) does not work w/7.1beta.
So, I compiled last night's CVS sources to create a new
psqlodbc.dll. This works *great* -- for tables. I don't see any of the
views (I did w/Pg7.0.2 and the stable 7.50 ODBC driver).
I can see through the ODBC trace that the driver gets the tables
with
select relname, usename, relhasrules from pg_class, pg_user where
relkind = 'r' and usesysid = relowner order by relname
(relkind='r' is for normal tables, 'v' is for views).
Is this an intended change? Something I did? Something I/someone
else can fix?
I do read this list, but always appreciate a 'cc' so I don't miss any
reponses. TIA.
BTW, the improvements to the ODBC driver also include a fix so that
referential integrity errors are reported properly as errors. No more
"looks like it worked, but really didn't". Thanks to everyone who
fixed this!
--
Joel Burton, Director of Information Systems -*- jburton@scw.org
Support Center of Washington (www.scw.org)
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: jburton@scw.org, psql-bugs@postgresql.org
Subject: Re: Pg7.1-beta and CVS psqlodbc.dll: No views
In-Reply-To: <3A1BEB71.28895.44245B38@localhost>
* 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