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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-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.
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Nasby | 2007-06-22 21:29:28 | Re: Dynamic Log tigger (plpgsql) |
Previous Message | Daniel van Ham Colchete | 2007-06-22 21:23:44 | Possible bug (or I don't understand how foreign keys should work with partitions) |
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2007-06-22 21:33:23 | Re: [JDBC] creating temporary table PostgreSql 8.1 and iBatis 2.3 |
Previous Message | Kris Jurka | 2007-06-22 21:05:02 | Re: a simple example of XA (not working) |