creating temporary table PostgreSql 8.1 and iBatis 2.3

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.