pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Pg7.1-beta and CVS psqlodbc.dll: No views 2+ messages / 2 participants [nested] [flat]
* Pg7.1-beta and CVS psqlodbc.dll: No views @ 2000-11-22 20:51 Joel Burton <jburton@scw.org> 0 siblings, 1 reply; 2+ messages in thread From: Joel Burton @ 2000-11-22 20:51 UTC (permalink / raw) To: pgsql-interfaces; psql-bugs@postgresql.org 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) ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Pg7.1-beta and CVS psqlodbc.dll: No views @ 2000-11-23 04:34 Tom Lane <tgl@sss.pgh.pa.us> parent: Joel Burton <jburton@scw.org> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2000-11-23 04:34 UTC (permalink / raw) To: Joel Burton <jburton@scw.org>; +Cc: pgsql-interfaces; psql-bugs@postgresql.org "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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-11-23 04:34 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2000-11-22 20:51 Pg7.1-beta and CVS psqlodbc.dll: No views Joel Burton <jburton@scw.org> 2000-11-23 04:34 ` Tom Lane <tgl@sss.pgh.pa.us>
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