[
https://jira.nuxeo.com/browse/NXP-7596?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Work on NXP-7596 started by Benoit Delbosc.
> PostgreSQL nx_init_ancestors fails when invoked twice
> -----------------------------------------------------
>
> Key: NXP-7596
> URL: https://jira.nuxeo.com/browse/NXP-7596
> Project: Nuxeo Enterprise Platform
> Issue Type: Bug
> Components: Core SQL Storage
> Affects Versions: 5.4.2
> Environment: PostgreSQL
> Reporter: Benoit Delbosc
> Assignee: Benoit Delbosc
> Fix For: 5.4.3
>
>
> There is a typo in the function that prevent to run it twice
> {code}
> ERROR: trigger "nx_trig_ancestos_update" for relation "hierarchy" already
> exists
> État SQL :42710
> Contexte : SQL function "nx_ancestors_create_triggers" statement 6
> SQL statement "SELECT nx_ancestors_create_triggers()"
> PL/pgSQL function "nx_init_ancestors" line 6 at PERFORM
> {code}
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
ECM-tickets@lists.nuxeo.com
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
