Thread: org.postgresql.util.PSQLException: ERROR: relation "dual" does not exist Position: 42

While im using postgresql with jdbc i m getting following error

org.postgresql.util.PSQLException: ERROR: relation "dual" does not exist
Position: 42

could you plz help me out how to fix this issue
--
View this message in context:
http://old.nabble.com/org.postgresql.util.PSQLException%3A-ERROR%3A-relation-%22dual%22-does-not-exist-Position%3A-42-tp28050845p28050845.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

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