[JIRA] Created: (NXP-707) Directories SQL syntax only works with HSQL

Damien Metzler (JIRA NUXEO) Sun, 04 Mar 2007 10:07:15 -0800

Issue (View Online)

Key:	NXP-707
Issue Type:	Improvement
Status:	Open
Priority:	Minor
Assignee:	Thierry Delprat
Reporter:	Damien Metzler
Environment:	Windows XP Jboss 4.0.4.GA Nuxeo 5 trunk

Operations

View all

View comments

View history

Directories SQL syntax only works with HSQL
Updated: 04/03/07 19:06 Created: 04/03/07 19:06

Project:	Nuxeo Enterprise Platform 5
Components:	Directory

Description

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.

This message was automatically generated by Atlassian JIRA Enterprise Edition, Version: 3.7.2-186 - Bug/feature request.
If you think it was sent incorrectly, contact one of this server's administrators.

_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets

[JIRA] Created: (NXP-707) Directories SQL syntax only works with HSQL

Reply via email to