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. Aren't usesysid and relowner int2? Why does it need to
> do any conversion anyway? Why not just usesysid=relowner? What am I
> missing?
Hmm. If I remove the int4out calls from src/interfaces/odbc/info.c,
then things work. Is this the right thing to do, or have I got
something broken elsewhere which I should fix?
(The regressions pass, BTW, and I'm using a pretty generic box: Debian
unstable, i386, gcc-2.95.2.)