Load (register) WMS doesn't work..

[marc]

..with postgres database < 8.3 because columnType "uuid" is used in several Tables
see ​changeset

[astrid_emde]

• hi marc: I will fix this

the new sql is not part of the update.sh and install.sh yet

[astrid_emde]

added /update_2.7rc1_to_2.7rc2_pgsql_%USEDBENC%.sql to the install.* and update.* in trunc und 2.7

[marc]

Hi Astrid,

the update script itself is not the problem.
I work with Postgres 8.2.13.
This Postgres Version dosn't support columnType 'uuid'.
so the update script throw an error.

ERROR:  type "uuid" does not exist

Now we're using this column in our prepared statements while register a WMS
​see

[astrid_emde]

the new column uuid is now part of the install.sh and update.sh it is added in the file update_2.7rc1_to_2.7rc2_pgsql_$DBENCODING.sql

[arsgeografica]

Replying to astrid_emde:

the new column uuid is now part of the install.sh and update.sh it is added in the file update_2.7rc1_to_2.7rc2_pgsql_$DBENCODING.sql

update.sh and update.bat still need to be modified to include the new sql script! right now the svn wont let me commit, so i add this info here...

[astrid_emde]

Done

• added update_2.7rc1_to_2.7rc2_pgsql_$DBENCODING.sql to *.sh and *.bat
• if datatype uuid does not exist new columns of type varchar are created