From: Tom Lane <tgl@sss.pgh.pa.us>
To: Joel Burton <jburton@scw.org>
Cc: pgsql-interfaces@postgresql.org
Cc: psql-bugs@postgresql.org
Subject: Re: Pg7.1-beta and CVS psqlodbc.dll: No views
Date: Wed, 22 Nov 2000 23:34:09 -0500
Message-ID: <26152.974954049@sss.pgh.pa.us> (raw)
In-Reply-To: <3A1BEB71.28895.44245B38@localhost>
References: <3A1BEB71.28895.44245B38@localhost>
"Joel Burton" <jburton@scw.org> writes:
> 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).
That's correct now, but in prior releases relkind='r' was used for both
tables and views (you had to go looking for an ON SELECT rule to
discover that a view was a view). It seems pretty likely that the ODBC
driver hasn't been fixed to know about this change :-(. Feel free to
submit a patch...
regards, tom lane
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: tgl@sss.pgh.pa.us, jburton@scw.org, psql-bugs@postgresql.org
Subject: Re: Pg7.1-beta and CVS psqlodbc.dll: No views
In-Reply-To: <26152.974954049@sss.pgh.pa.us>
* 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