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
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
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
