Bruce Stephens <bruce@cenderis.demon.co.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