Skip site navigation (1) Skip section navigation (2)

Re: Problem with ODBC in current CVS?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Stephens <bruce(at)cenderis(dot)demon(dot)co(dot)uk>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Problem with ODBC in current CVS?
Date: 2000-08-28 23:36:00
Message-ID: 19494.967505760@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-interfaces
Bruce Stephens <bruce(at)cenderis(dot)demon(dot)co(dot)uk> writes:
> select relname,usename,relhasrules from pg_class,pg_user 
>         where relkind = 'r' and relname !~ '^pg_|^dd_' and
>         relname !~ '^xinv[0-9]+' and
>         int4out(usesysid) = int4out(relowner)order by relname

> which returns no rows when I try it by hand.  These int4out's look
> iffy to me.

They're pretty bogus all right.  I think usesysid=relowner should
work fine.  Try making the appropriate change in
src/interfaces/odbc/info.c and let us know how it goes...

			regards, tom lane

In response to

pgsql-interfaces by date

Next:From: Tom LaneDate: 2000-08-29 00:59:05
Subject: Re: Problem with ODBC in current CVS?
Previous:From: Bruce StephensDate: 2000-08-28 21:55:09
Subject: Re: Problem with ODBC in current CVS?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group