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)
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 |