From: "Joel Burton" <jburton@scw.org>
Organization: Support Center of Washington
To: pgsql-interfaces@postgresql.org, psql-bugs@postgresql.org
Date: Wed, 22 Nov 2000 15:51:13 -0500
MIME-Version: 1.0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT
Subject: Pg7.1-beta and CVS psqlodbc.dll: No views
Message-ID: <3A1BEB71.28895.44245B38@localhost>

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)