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

creating temporary table PostgreSql 8.1 and iBatis 2.3

From: tomasz brymora <tomekpilot(at)yahoo(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Cc: pgsql-general(at)postgresql(dot)org
Subject: creating temporary table PostgreSql 8.1 and iBatis 2.3
Date: 2007-06-22 21:29:24
Message-ID: 991681.73756.qm@web56610.mail.re3.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-jdbc
Greetings!

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"

Other than that queries run fine. 
I'm thinking the problem is on the db admin side of things, but I'm at a loss as to how to start fixing it.

I'll greatly appreciate any feedback.

Thank you in advance.

Responses

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2007-06-22 21:33:23
Subject: Re: [JDBC] creating temporary table PostgreSql 8.1 and iBatis 2.3
Previous:From: Kris JurkaDate: 2007-06-22 21:05:02
Subject: Re: a simple example of XA (not working)

pgsql-general by date

Next:From: Jim NasbyDate: 2007-06-22 21:29:28
Subject: Re: Dynamic Log tigger (plpgsql)
Previous:From: Daniel van Ham ColcheteDate: 2007-06-22 21:23:44
Subject: Possible bug (or I don't understand how foreign keys should work with partitions)

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