Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e7SNaCC64769 for ; Mon, 28 Aug 2000 19:36:12 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id TAA19497; Mon, 28 Aug 2000 19:36:00 -0400 (EDT) To: Bruce Stephens cc: pgsql-interfaces@postgresql.org Subject: Re: Problem with ODBC in current CVS? In-reply-to: <87pumtnl0r.fsf@cenderis.demon.co.uk> References: <87pumtnl0r.fsf@cenderis.demon.co.uk> Comments: In-reply-to Bruce Stephens message dated "28 Aug 2000 22:17:08 +0100" Date: Mon, 28 Aug 2000 19:36:00 -0400 Message-ID: <19494.967505760@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200008/180 Bruce Stephens 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