Ticket #766 (closed defect: fixed)

Opened 2 years ago

Last modified 2 years ago

Load (register) WMS doesn't work..

Reported by: marc Owned by: dev
Priority: major Milestone: 2.7 release
Component: administration Version: 2.7 rc1
Keywords: Cc: marc

Description

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

Change History

  Changed 2 years ago by astrid_emde

* hi marc: I will fix this

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

  Changed 2 years ago by astrid_emde

  • status changed from new to closed
  • resolution set to fixed

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

  Changed 2 years ago by marc

  • cc marc added
  • status changed from closed to reopened
  • resolution fixed deleted

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

follow-up: ↓ 5   Changed 2 years ago by 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

in reply to: ↑ 4   Changed 2 years ago by 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...

  Changed 2 years ago by astrid_emde

  • status changed from reopened to closed
  • resolution set to fixed

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
Note: See TracTickets for help on using tickets.