Re: org.postgresql.util.PSQLException: ERROR: relation "dual" does not exist Position: 42 - Mailing list pgsql-jdbc

From Craig Ringer
Subject Re: org.postgresql.util.PSQLException: ERROR: relation "dual" does not exist Position: 42
Date
Msg-id 4BAEA879.5060403@postnewspapers.com.au
Whole thread Raw
In response to org.postgresql.util.PSQLException: ERROR: relation "dual" does not exist Position: 42  (Sriram P <sriramkumar1985@gmail.com>)
List pgsql-jdbc
On 27/03/2010 4:19 PM, Sriram P wrote:
>
> While im using postgresql with jdbc i m getting following error
>
> org.postgresql.util.PSQLException: ERROR: relation "dual" does not exist
> Position: 42

You're using code written for Oracle. You need to fix your SQL so it'll
run on PostgreSQL.

If you want help with that, you'll have to post the SQL and some other
basic information. See:
   http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

--
Craig Ringer

pgsql-jdbc by date:

Previous
From: Nookala Satish Kumar
Date:
Subject: Glassfish ignoring "ssl" property in connection pool of PostgreSQL
Next
From: abyss
Date:
Subject: SHARE HAPPINESS!