Re: [GENERAL] [JDBC] creating temporary table PostgreSql 8.1 and iBatis 2.3

2007-06-22 Thread Kris Jurka
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

Re: [GENERAL] [JDBC] creating temporary table PostgreSql 8.1 and iBatis 2.3

2007-06-22 Thread Tom Lane
Kris Jurka [EMAIL PROTECTED] writes: 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