Discussion:
org.postgresql.util.PSQLException: ERROR: relation "dual" does not exist Position: 42
Sriram P
2010-03-27 08:19:12 UTC
Permalink
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.
--
Sent via pgsql-jdbc mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
Craig Ringer
2010-03-28 00:53:13 UTC
Permalink
Post by Sriram P
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
--
Sent via pgsql-jdbc mailing list (pgsql-***@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
Loading...