Index name collision

[Jeffl]

[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

[BJ Freeman]

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
>
>
>
>

[Jeffl]

1104

[Mike Z]

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 <[hidden email]>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
>
>
>
>