You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ofbiz.apache.org by Jeff Lowery <je...@mavericklabel.com> on 2012/07/06 20:41:45 UTC

Index name collision

[ProductStoreContactMechPurpose]: SQL Exception while executing the following:
     [java] CREATE INDEX PRT_CNT_MCH_PRS_TP ON public.PRODUCT_STORE_CONTACT_MECH_PURPOSE (LAST_UPDATED_TX_STAMP)
     [java] Error was: org.postgresql.util.PSQLException: ERROR: relation "prt_cnt_mch_prs_tp" already exists

Is this a generated index name?  I can't find it in any entity files.  What would be the best way to change it?

-- Jeff

Re: Index name collision

Posted by Mike <mz...@gmail.com>.

That index belongs to party_contact_mech_purpose.

 public | prt_cnt_mch_prs_tp             | index | ofbiz |
party_contact_mech_purpose
 public | prt_cnt_mch_prs_ts             | index | ofbiz |
party_contact_mech_purpose

Are you just trying to load seed data?  My guess is you are trying to load
an entity with a duplicate key.


On Fri, Jul 6, 2012 at 11:41 AM, Jeff Lowery <je...@mavericklabel.com>wrote:

> [ProductStoreContactMechPurpose]: SQL Exception while executing the
> following:
>      [java] CREATE INDEX PRT_CNT_MCH_PRS_TP ON
> public.PRODUCT_STORE_CONTACT_MECH_PURPOSE (LAST_UPDATED_TX_STAMP)
>      [java] Error was: org.postgresql.util.PSQLException: ERROR: relation
> "prt_cnt_mch_prs_tp" already exists
>
> Is this a generated index name?  I can't find it in any entity files.
>  What would be the best way to change it?
>
> -- Jeff
>
>
>
>

Re: Index name collision

Posted by Jeffl <je...@mavericklabel.com>.

1104

--
View this message in context: http://ofbiz.135035.n4.nabble.com/Index-name-collision-tp4634525p4634714.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: Index name collision

Posted by BJ Freeman <bj...@free-man.net>.

what version of Ofbiz are you using.

Jeff Lowery sent the following on 7/6/2012 11:41 AM:
> [ProductStoreContactMechPurpose]: SQL Exception while executing the following:
>       [java] CREATE INDEX PRT_CNT_MCH_PRS_TP ON public.PRODUCT_STORE_CONTACT_MECH_PURPOSE (LAST_UPDATED_TX_STAMP)
>       [java] Error was: org.postgresql.util.PSQLException: ERROR: relation "prt_cnt_mch_prs_tp" already exists
>
> Is this a generated index name?  I can't find it in any entity files.  What would be the best way to change it?
>
> -- Jeff
>
>
>
>