Re: creating temporary table PostgreSql 8.1 and iBatis 2.3

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

Knowing the SQL that it actually executed would be valuable.

Kris Jurka