Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: [JDBC] creating temporary table PostgreSql 8.1 and iBatis 2.3
- From: Kris Jurka <books(at)ejurka(dot)com>
- To: tomasz brymora <tomekpilot(at)yahoo(dot)com>
- Cc: 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: Fri, 22 Jun 2007 17:33:23 -0400 (EDT)
- Message-id: <Pine.BSO.4.64.0706221732260.21640@leary.csoft.net> <text/plain>
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
- Follow-Ups:
- References:
- creating temporary table PostgreSql 8.1 and iBatis 2.3
- From: tomasz brymora
- creating temporary table PostgreSql 8.1 and iBatis 2.3
- Prev by Date: creating temporary table PostgreSql 8.1 and iBatis 2.3
- Next by Date: Re: Possible bug (or I don't understand how foreign keys should work with partitions)
- Previous by thread: creating temporary table PostgreSql 8.1 and iBatis 2.3
- Next by thread: Re: [JDBC] creating temporary table PostgreSql 8.1 and iBatis 2.3
- Indexes: