Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 40B1E1337B80 for ; Fri, 1 Apr 2011 12:09:44 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 64536-01 for ; Fri, 1 Apr 2011 15:09:33 +0000 (UTC) X-Greylist: delayed 00:05:09.057756 by SQLgrey-1.7.6 Received: from rs73.luxsci.com (rs73.luxsci.com [64.49.254.135]) by mail.postgresql.org (Postfix) with ESMTP id 5FDA21337B47 for ; Fri, 1 Apr 2011 12:09:33 -0300 (ADT) Received: from SenthilKumarG (NSG-Static-233.156.72.182.airtel.in [182.72.156.233] (may be forged)) (authenticated bits=0) by rs73.luxsci.com (8.13.8/8.13.8) with ESMTP id p31F4K7q030205 for ; Fri, 1 Apr 2011 10:04:22 -0500 Message-Id: <201104011504.p31F4K7q030205@rs73.luxsci.com> From: "Senthil Kumar G" To: Subject: DB Import Error... Date: Fri, 1 Apr 2011 20:34:28 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_405E_01CBF0AC.344D1860" X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: Acvwfhj2S0NLoHcmR9aVAau8aaMUWA== X-MimeOLE: Produced By Microsoft MimeOLE V6.1.7600.16543 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.609 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, MAY_BE_FORGED=0.29 X-Spam-Level: X-Archive-Number: 201104/22 X-Sequence-Number: 37203 This is a multi-part message in MIME format. ------=_NextPart_000_405E_01CBF0AC.344D1860 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi I am upgrading my staging environment from postgresql 8.2.3 to 9.0.3. I was able to do successfully. But, when i try to import the database which is created in 8.2.0 version to 9.0.3 version environment, i am getting following error. ERROR: constraint "xxxx" for relation "xxxx" already exist when i query it was not found. What could be the reason? What should i do to resolve this? Appreciate your quick answer. Thanks & Regards Senthil ------=_NextPart_000_405E_01CBF0AC.344D1860 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi

 

I am upgrading my staging environment from postgresql = 8.2.3 to 9.0.3.

 

I was able to do = successfully.

 

But, when i try to import the database which is = created in 8.2.0 version to 9.0.3 version environment, i am getting following = error.

 

ERROR:  constraint "xxxx” for relation "xxxx” already exist

 

when i query it was not = found.

 

What could be the reason? What should i do to resolve = this?

 

Appreciate your quick = answer.

 

Thanks & = Regards

Senthil

 

------=_NextPart_000_405E_01CBF0AC.344D1860--