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

Re: [JDBC] creating temporary table PostgreSql 8.1 and iBatis 2.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: tomasz brymora <tomekpilot(at)yahoo(dot)com>, pgsql-jdbc(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [JDBC] creating temporary table PostgreSql 8.1 and iBatis 2.3
Date: 2007-06-22 22:05:52
Message-ID: 28706.1182549952@sss.pgh.pa.us (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-generalpgsql-jdbc
Kris Jurka <books(at)ejurka(dot)com> writes:
> On Fri, 22 Jun 2007, tomasz brymora wrote:
>> I've build a script in pgAdmin 3 ( os x 10.4 on ppc) that does a select, 
>> some left outer joins and puts the results into a temporary table. Works 
>> great when I run in pgAdmin.
>> 
>> Then I try to use in an iBatis sqlmap as a 'select' and get this when 
>> trying to execute it:
>> 
>> org.postgresql.util.PSQLException: ERROR: must be member of role 
>> "postgres"

> Knowing the SQL that it actually executed would be valuable.

Indeed.  A quick scan of the backend source says that that message is
only issued if you try to give away ownership of something to a role you
are not a member of (this means ALTER OWNER and the options of CREATE
DATABASE/CREATE SCHEMA that give the object some other owner than
yourself).  So there's something you didn't tell us about what that
script does.

			regards, tom lane

In response to

pgsql-jdbc by date

Next:From: Gregory StarkDate: 2007-06-23 11:33:30
Subject: Re: Log files cluttered with jdbc3/4 for pg8.2
Previous:From: Kris JurkaDate: 2007-06-22 21:38:55
Subject: Re: Bug report and patch: PreparedStatement.setObject(int, Object) does not infer java.lang.Byte

pgsql-general by date

Next:From: jef peeraerDate: 2007-06-22 22:13:03
Subject: Re: permission denied for schema
Previous:From: Tom LaneDate: 2007-06-22 21:58:37
Subject: Re: permission denied for schema

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