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

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

From
"Joel Burton"
Date:
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)


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

From
Tom Lane
Date:
"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