From: Bruce Stephens <bruce@cenderis.demon.co.uk>
To: pgsql-interfaces@postgresql.org
Subject: Re: Problem with ODBC in current CVS?
References: <87pumtnl0r.fsf@cenderis.demon.co.uk>
Date: 28 Aug 2000 22:55:09 +0100
In-Reply-To: Bruce Stephens's message of "28 Aug 2000 22:17:08 +0100"
Message-ID: <878ztht5j6.fsf@cenderis.demon.co.uk>
Lines: 20
User-Agent: Gnus/5.0808 (Gnus v5.8.8) XEmacs/21.2 (Nike)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

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.  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.)