|
|
|
| The following comment has been added to this issue: |
[ Permlink ] |
|
Author: Olivier Grisel
Date: 04/03/07 21:58
Comment:
Note: the IF EXISTS extension is not standard and was only introduced as of version 8.2 in postgresql.
Not using the IF EXISTS extension makes the transaction fail under postgres. I am not sure whether directory init is run as a single transaction or not by default though.
Anyway, using DROP TABLE IF EXISTS is still better than DROP TABLE continent IF EXISTS.
|
|
The directories definition in Nuxeo 5 always use this syntax :
DROP TABLE continent IF EXISTS;
This syntax doesn't work in PostGres and should be written like this :
DROP TABLE IF EXISTS continent ;
It also work in HSQL and MySQL. It should be better to use the las t syntax since the migration towards Postgres needs to override those files.
|
|
|
|
![]() |
|
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
