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