To: "Joel Burton" <jburton@scw.org>
cc: pgsql-interfaces@postgresql.org, psql-bugs@postgresql.org
Subject: Re: Pg7.1-beta and CVS psqlodbc.dll: No views 
In-reply-to: <3A1BEB71.28895.44245B38@localhost> 
References: <3A1BEB71.28895.44245B38@localhost>
Comments: In-reply-to "Joel Burton" <jburton@scw.org>
	message dated "Wed, 22 Nov 2000 15:51:13 -0500"
Date: Wed, 22 Nov 2000 23:34:09 -0500
Message-ID: <26152.974954049@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

"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