Pg7.1-beta and CVS psqlodbc.dll: No views

From: "Joel Burton" <jburton(at)scw(dot)org>
To: pgsql-interfaces(at)postgresql(dot)org, psql-bugs(at)postgresql(dot)org
Subject: Pg7.1-beta and CVS psqlodbc.dll: No views
Date: 2000-11-22 20:51:13
Message-ID: 3A1BEB71.28895.44245B38@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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(at)scw(dot)org
Support Center of Washington (www.scw.org)

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Michael Miyabara-McCaskey 2000-11-22 23:13:48 RE: ODBC Windows driver corrupts data?
Previous Message Tony Nakamura 2000-11-22 03:02:11 Re: Tomcat & JDBC