Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 80EF4633076 for ; Sat, 27 Mar 2010 21:53:49 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 91114-02 for ; Sun, 28 Mar 2010 00:53:38 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.postnewspapers.com.au (202-89-185-120.static.dsl.amnet.net.au [202.89.185.120]) by mail.postgresql.org (Postfix) with ESMTP id DB1D563305E for ; Sat, 27 Mar 2010 21:53:38 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mail.postnewspapers.com.au (Postfix) with ESMTP id 40FF5AE4F6; Sun, 28 Mar 2010 08:53:02 +0800 (WST) X-Virus-Scanned: Debian amavisd-new at postnewspapers.com.au Received: from mail.postnewspapers.com.au ([127.0.0.1]) by localhost (mail2.postnewspapers.com.au [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 1bJflIzOkBOG; Sun, 28 Mar 2010 08:52:56 +0800 (WST) Received: from [10.1.1.4] (203-206-15-93.dyn.iinet.net.au [203.206.15.93]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "Craig Ringer", Issuer "POST Certificate Authority" (verified OK)) by mail.postnewspapers.com.au (Postfix) with ESMTPSA id 7F4FDAE4F4; Sun, 28 Mar 2010 08:52:56 +0800 (WST) Message-ID: <4BAEA879.5060403@postnewspapers.com.au> Date: Sun, 28 Mar 2010 08:53:13 +0800 From: Craig Ringer User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-GB; rv:1.9.1.8) Gecko/20100227 Thunderbird/3.0.3 MIME-Version: 1.0 To: Sriram P CC: pgsql-jdbc@postgresql.org Subject: Re: org.postgresql.util.PSQLException: ERROR: relation "dual" does not exist Position: 42 References: <28050845.post@talk.nabble.com> In-Reply-To: <28050845.post@talk.nabble.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/70 X-Sequence-Number: 20410 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