Return-Path: X-Original-To: apmail-ofbiz-user-archive@www.apache.org Delivered-To: apmail-ofbiz-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 34E7C181F5 for ; Wed, 23 Sep 2015 11:08:46 +0000 (UTC) Received: (qmail 97370 invoked by uid 500); 23 Sep 2015 11:08:39 -0000 Delivered-To: apmail-ofbiz-user-archive@ofbiz.apache.org Received: (qmail 97339 invoked by uid 500); 23 Sep 2015 11:08:39 -0000 Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ofbiz.apache.org Delivered-To: mailing list user@ofbiz.apache.org Received: (qmail 97326 invoked by uid 99); 23 Sep 2015 11:08:38 -0000 Received: from Unknown (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 23 Sep 2015 11:08:38 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 7F1E2F6E9B for ; Wed, 23 Sep 2015 11:08:38 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.002 X-Spam-Level: * X-Spam-Status: No, score=1.002 tagged_above=-999 required=6.31 tests=[KAM_LAZY_DOMAIN_SECURITY=1, RP_MATCHES_RCVD=0.001, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-us-west.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id bR2NnsDxvO0k for ; Wed, 23 Sep 2015 11:08:32 +0000 (UTC) Received: from mail.ecomify.de (mail.ecomify.de [178.77.98.9]) by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with ESMTPS id A4CBB237F8 for ; Wed, 23 Sep 2015 11:08:31 +0000 (UTC) Received: from localhost (mail.ecomify.de [127.0.0.1]) by mail.ecomify.de (Postfix) with ESMTP id 9BFBC283 for ; Wed, 23 Sep 2015 13:08:23 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at ecomify.de Received: from mail.ecomify.de ([127.0.0.1]) by localhost (lvps178-77-98-9.dedicated.hosteurope.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 0_ZHbtXt3AjK for ; Wed, 23 Sep 2015 13:08:18 +0200 (CEST) Subject: Re: Error was: org.postgresql.util.PSQLException: ERROR: relation "tablename" already exists To: user@ofbiz.apache.org References: From: Michael Brohl Organization: ecomify GmbH Message-ID: <56028821.9050903@ecomify.de> Date: Wed, 23 Sep 2015 13:08:17 +0200 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; protocol="application/pkcs7-signature"; micalg=sha-256; boundary="------------ms030900010205090409070109" --------------ms030900010205090409070109 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable Hi Derek, I guess your relation name/fk-name is the same as your table name,=20 that's not allowed. You might want to provide your entity definition so=20 we can see what's wrong with it. Michael Brohl ecomify GmbH www.ecomify.de Am 23.09.15 um 08:13 schrieb Derek Lew: > Hi > > =20 > > I have created a new entity, but everytime I am getting the following e= rror, > how do I set it in such a way that it will check if the entity is there= and > don't create anymore? > > Error was: org.postgresql.util.PSQLException: ERROR: relation "tablenam= e" > already exists > > =20 > > Best regards. > =20 > Derek Lew =E5=88=98=E7=BB=8D=E9=9B=84 > > =20 > > --------------ms030900010205090409070109 Content-Type: application/pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIAGCSqGSIb3DQEHAqCAMIACAQExDzANBglghkgBZQMEAgEFADCABgkqhkiG9w0BBwEAAKCC DI0wggY0MIIEHKADAgECAgEeMA0GCSqGSIb3DQEBBQUAMH0xCzAJBgNVBAYTAklMMRYwFAYD VQQKEw1TdGFydENvbSBMdGQuMSswKQYDVQQLEyJTZWN1cmUgRGlnaXRhbCBDZXJ0aWZpY2F0 ZSBTaWduaW5nMSkwJwYDVQQDEyBTdGFydENvbSBDZXJ0aWZpY2F0aW9uIEF1dGhvcml0eTAe Fw0wNzEwMjQyMTAxNTVaFw0xNzEwMjQyMTAxNTVaMIGMMQswCQYDVQQGEwJJTDEWMBQGA1UE ChMNU3RhcnRDb20gTHRkLjErMCkGA1UECxMiU2VjdXJlIERpZ2l0YWwgQ2VydGlmaWNhdGUg U2lnbmluZzE4MDYGA1UEAxMvU3RhcnRDb20gQ2xhc3MgMSBQcmltYXJ5IEludGVybWVkaWF0 ZSBDbGllbnQgQ0EwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDHCYPMzi3YGrEp pC4Tq5a+ijKDjKaIQZZVR63UbxIP6uq/I0fhCu+cQhoUfE6ERKKnu8zPf1Jwuk0tsvVCk6U9 b+0UjM0dLep3ZdE1gblK/1FwYT5Pipsu2yOMluLqwvsuz9/9f1+1PKHG/FaR/wpbfuIqu54q zHDYeqiUfsYzoVflR80DAC7hmJ+SmZnNTWyUGHJbBpA8Q89lGxahNvuryGaC/o2/ceD2uYDX 9U8Eg5DpIpGQdcbQeGarV04WgAUjjXX5r/2dabmtxWMZwhZna//jdiSyrrSMTGKkDiXm6/3/ 4ebfeZuCYKzN2P8O2F/Xe2AC/Y7zeEsnR7FOp+uXAgMBAAGjggGtMIIBqTAPBgNVHRMBAf8E BTADAQH/MA4GA1UdDwEB/wQEAwIBBjAdBgNVHQ4EFgQUU3Ltkpzg2ssBXHx+ljVO8tS4UYIw HwYDVR0jBBgwFoAUTgvvGqRAW6UXaYcwyjRoQ9BBrvIwZgYIKwYBBQUHAQEEWjBYMCcGCCsG AQUFBzABhhtodHRwOi8vb2NzcC5zdGFydHNzbC5jb20vY2EwLQYIKwYBBQUHMAKGIWh0dHA6 Ly93d3cuc3RhcnRzc2wuY29tL3Nmc2NhLmNydDBbBgNVHR8EVDBSMCegJaAjhiFodHRwOi8v d3d3LnN0YXJ0c3NsLmNvbS9zZnNjYS5jcmwwJ6AloCOGIWh0dHA6Ly9jcmwuc3RhcnRzc2wu Y29tL3Nmc2NhLmNybDCBgAYDVR0gBHkwdzB1BgsrBgEEAYG1NwECATBmMC4GCCsGAQUFBwIB FiJodHRwOi8vd3d3LnN0YXJ0c3NsLmNvbS9wb2xpY3kucGRmMDQGCCsGAQUFBwIBFihodHRw Oi8vd3d3LnN0YXJ0c3NsLmNvbS9pbnRlcm1lZGlhdGUucGRmMA0GCSqGSIb3DQEBBQUAA4IC AQAKgwh9eKssBly4Y4xerhy5I3dNoXHYfYa8PlVLL/qtXnkFgdtY1o95CfegFJTwqBBmf8py TUnFsukDFUI22zF5bVHzuJ+GxhnSqN2sD1qetbYwBYK2iyYA5Pg7Er1A+hKMIzEzcduRkIMm CeUTyMyikfbUFvIBivtvkR8ZFAk22BZy+pJfAoedO61HTz4qSfQoCRcLN5A0t4DkuVhTMXIz uQ8CnykhExD6x4e6ebIbrjZLb7L+ocR0y4YjCl/Pd4MXU91y0vTipgr/O75CDUHDRHCCKBVm z/Rzkc/b970MEeHt5LC3NiWTgBSvrLEuVzBKM586YoRD9Dy3OHQgWI270g+5MYA8GfgI/EPT 5G7xPbCDz+zjdH89PeR3U4So4lSXur6H6vp+m9TQXPF3a0LwZrp8MQ+Z77U1uL7TelWO5lAp sbAonrqASfTpaprFVkL4nyGH+NHST2ZJPWIBk81i6Vw0ny0qZW2Niy/QvVNKbb43A43ny076 khXO7cNbBIRdJ/6qQNq9Bqb5C0Q5nEsFcj75oxQRqlKf6TcvGbjxkJh8BYtv9ePsXklAxtm8 J7GCUBthHSQgepbkOexhJ0wP8imUkyiPHQ0GvEnd83129fZjoEhdGwXV27ioRKbj/cIq7JRX un0NbeY+UdMYu9jGfIpDLtUUGSgsg2zMGs5R4jCCBlEwggU5oAMCAQICAwxOfTANBgkqhkiG 9w0BAQUFADCBjDELMAkGA1UEBhMCSUwxFjAUBgNVBAoTDVN0YXJ0Q29tIEx0ZC4xKzApBgNV BAsTIlNlY3VyZSBEaWdpdGFsIENlcnRpZmljYXRlIFNpZ25pbmcxODA2BgNVBAMTL1N0YXJ0 Q29tIENsYXNzIDEgUHJpbWFyeSBJbnRlcm1lZGlhdGUgQ2xpZW50IENBMB4XDTE0MTIxODEy MjYzOFoXDTE1MTIxOTA4NTcxMVowZzEZMBcGA1UEDRMQeWoxaXVrNzVJRDRKUGU5YTEhMB8G A1UEAwwYbWljaGFlbC5icm9obEBlY29taWZ5LmRlMScwJQYJKoZIhvcNAQkBFhhtaWNoYWVs LmJyb2hsQGVjb21pZnkuZGUwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDDP/OO Rw+9req0u96sp2o3gAKuKzkLl/cN2uDEwxyy8miPAX4WqT68ig6gfUgkz3WHkfZ94TsEoE3P NZhdFczS64uWSDwkyBAVeM+spzt3LR92i4mkbw3GXg4splnS/+VvDSKiAljrS3iz2jx/usz9 +a+q00xWn0aM1oqspia66jEMAi41SJsIjasZiXys3vl2GWplkZPVjZU0XXWQRSErLPOlKZJQ lHA71qWUw7VFuMYTztQqsfYMPI/4SSNXXBK/WRQmNZba1JM3tsPQw2Be2qMonq8bfsKAF8vp PH7NGANPg8w3bbUqVJJpav/9l257teBVp8qpwoXiF4iW5eGTAgMBAAGjggLeMIIC2jAJBgNV HRMEAjAAMAsGA1UdDwQEAwIEsDAdBgNVHSUEFjAUBggrBgEFBQcDAgYIKwYBBQUHAwQwHQYD VR0OBBYEFCX/VPldfteESKZ9o6D1IJgmyJ+QMB8GA1UdIwQYMBaAFFNy7ZKc4NrLAVx8fpY1 TvLUuFGCMCMGA1UdEQQcMBqBGG1pY2hhZWwuYnJvaGxAZWNvbWlmeS5kZTCCAUwGA1UdIASC AUMwggE/MIIBOwYLKwYBBAGBtTcBAgMwggEqMC4GCCsGAQUFBwIBFiJodHRwOi8vd3d3LnN0 YXJ0c3NsLmNvbS9wb2xpY3kucGRmMIH3BggrBgEFBQcCAjCB6jAnFiBTdGFydENvbSBDZXJ0 aWZpY2F0aW9uIEF1dGhvcml0eTADAgEBGoG+VGhpcyBjZXJ0aWZpY2F0ZSB3YXMgaXNzdWVk IGFjY29yZGluZyB0byB0aGUgQ2xhc3MgMSBWYWxpZGF0aW9uIHJlcXVpcmVtZW50cyBvZiB0 aGUgU3RhcnRDb20gQ0EgcG9saWN5LCByZWxpYW5jZSBvbmx5IGZvciB0aGUgaW50ZW5kZWQg cHVycG9zZSBpbiBjb21wbGlhbmNlIG9mIHRoZSByZWx5aW5nIHBhcnR5IG9ibGlnYXRpb25z LjA2BgNVHR8ELzAtMCugKaAnhiVodHRwOi8vY3JsLnN0YXJ0c3NsLmNvbS9jcnR1MS1jcmwu Y3JsMIGOBggrBgEFBQcBAQSBgTB/MDkGCCsGAQUFBzABhi1odHRwOi8vb2NzcC5zdGFydHNz bC5jb20vc3ViL2NsYXNzMS9jbGllbnQvY2EwQgYIKwYBBQUHMAKGNmh0dHA6Ly9haWEuc3Rh cnRzc2wuY29tL2NlcnRzL3N1Yi5jbGFzczEuY2xpZW50LmNhLmNydDAjBgNVHRIEHDAahhho dHRwOi8vd3d3LnN0YXJ0c3NsLmNvbS8wDQYJKoZIhvcNAQEFBQADggEBAIWHNw9WVyl77VqJ qEiZ9YsWuHLr4EcSvweQlfM7zax2x94sCD+dcPV0AFkbjeZT6f5hAgtOFBZPItTzi7K4nUzs +nx0ZCMzsVg+137LZQyHWDgUoY5yIoS3kjkXAyXZx+yBVspFTBVxZnmcTQsC5FXVatJK5xh/ BLS4QwoESTv+FCI3wPmMI+Cn4AhFyFZAzyPNlFLEUGZssn6W+ZfSsC4S50dzfiDpXQ2StX4F kWVRt/WwFFomQst1vpOH/8cXmOXCrcuyHUnNZf7MWWp9B9JtKjWQMMPTZZ1CM8IAaQ+b9oSR QF2gKA2K+qNwfPtUddFK0/luH4/9l0uy9o7fCa0xggPtMIID6QIBATCBlDCBjDELMAkGA1UE BhMCSUwxFjAUBgNVBAoTDVN0YXJ0Q29tIEx0ZC4xKzApBgNVBAsTIlNlY3VyZSBEaWdpdGFs IENlcnRpZmljYXRlIFNpZ25pbmcxODA2BgNVBAMTL1N0YXJ0Q29tIENsYXNzIDEgUHJpbWFy eSBJbnRlcm1lZGlhdGUgQ2xpZW50IENBAgMMTn0wDQYJYIZIAWUDBAIBBQCgggIpMBgGCSqG SIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcNAQkFMQ8XDTE1MDkyMzExMDgxN1owLwYJ KoZIhvcNAQkEMSIEICtJ6dZoaG+kTTgV7SHGTZ8pgryzLpDgosIzvGrTkO7lMGwGCSqGSIb3 DQEJDzFfMF0wCwYJYIZIAWUDBAEqMAsGCWCGSAFlAwQBAjAKBggqhkiG9w0DBzAOBggqhkiG 9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZIhvcNAwICASgwgaUGCSsG AQQBgjcQBDGBlzCBlDCBjDELMAkGA1UEBhMCSUwxFjAUBgNVBAoTDVN0YXJ0Q29tIEx0ZC4x KzApBgNVBAsTIlNlY3VyZSBEaWdpdGFsIENlcnRpZmljYXRlIFNpZ25pbmcxODA2BgNVBAMT L1N0YXJ0Q29tIENsYXNzIDEgUHJpbWFyeSBJbnRlcm1lZGlhdGUgQ2xpZW50IENBAgMMTn0w gacGCyqGSIb3DQEJEAILMYGXoIGUMIGMMQswCQYDVQQGEwJJTDEWMBQGA1UEChMNU3RhcnRD b20gTHRkLjErMCkGA1UECxMiU2VjdXJlIERpZ2l0YWwgQ2VydGlmaWNhdGUgU2lnbmluZzE4 MDYGA1UEAxMvU3RhcnRDb20gQ2xhc3MgMSBQcmltYXJ5IEludGVybWVkaWF0ZSBDbGllbnQg Q0ECAwxOfTANBgkqhkiG9w0BAQEFAASCAQCw+JPSAkfVdLAbMTiGs9HRJk5We4PRBD0oF6kU OzJUqo/69IEqJVtCJPbg9yo90A5UUOp3zk8A+wJFUtk6/+PWYiCihitl6vBi5X2vlMLy/Ifu K7Jcj9X/67f6OEC7/paUDBB4tX2uhAJ2dNQnXNdjpsQpWCzBFtnfqTxhtKiBv9CuBbp3HGKf CIQ/Rt9vZq1+WTfyb1D0cnM5JmGpLb3CFvKByyMT9NNPTGSJPiGiZTuwHMuYBZwoB+bEKQkY 4qQaHuEohdhpTd5TCtWzwTfRjcaVGF9QbLCl2EGoTODAa72osOsFK2fVDqHvDaLwXwtERDlP 3lPK60wY7mExJf+FAAAAAAAA --------------ms030900010205090409070109--