|
|
|
| The following comment has been added to this issue: |
[ Permlink ] |
|
Author: Thierry Delprat
Date: 15/05/07 12:42
Comment:
One of the main problem is that the SQL contains to much stuff :
- drop tables
- create tables
- populate tables
The Create Table should not be in a script : the SQLDirectory descriptor contains anything we need to create the table :
- table name
- schema
- id field (for PK)
The Drop table should be generated as well.
The SetupTable should :
- try a select * from table : to see if the table exists and check to columns in the results
- if results do not match : drop and recreate the table, then load the script
|
|
- Some SQL directories have scripts set to "always" : this should never be the case in the trunk
- SQL scripts fails in PGSQL < 8.2
- Table structure detection fails on PGSQL (error even when the tables are created by hand, because the script is executed)
|
|
|
|
![]() |
|
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
