[Tickets #7454] Re: PostgreSQL needs own 2.2_to_2.3 upgrade script

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/7454
------------------------------------------------------------------------------
  Ticket             | 7454
  Updated By         | michael.menge at zdv.uni-tuebingen.de
  Summary            | PostgreSQL needs own 2.2_to_2.3 upgrade script
  Queue              | Kronolith
  Version            | 2.3
  Type               | Bug
  State              | Feedback
  Priority           | 2. Medium
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


michael.menge at zdv.uni-tuebingen.de (2008-10-08 10:15) wrote:

Postgesql has a different Syntax for ALTER TABLE

psql:2.2_to_2.3.sql:1: FEHLER:  Fehler »Syntaxfehler« bei »CHANGE« bei  
Zeichen 30
psql:2.2_to_2.3.sql:1: ZEILE 1: ALTER TABLE kronolith_shares CHANGE  
share_owner share_owner ...
psql:2.2_to_2.3.sql:1:                                       ^
psql:2.2_to_2.3.sql:2: FEHLER:  Fehler »Syntaxfehler« bei »CHANGE« bei  
Zeichen 36
psql:2.2_to_2.3.sql:2: ZEILE 1: ALTER TABLE kronolith_shares_users  
CHANGE user_uid user_uid ...
psql:2.2_to_2.3.sql:2:                                             ^
psql:2.2_to_2.3.sql:3: FEHLER:  Fehler »Syntaxfehler« bei »CHANGE« bei  
Zeichen 37
psql:2.2_to_2.3.sql:3: ZEILE 1: ALTER TABLE kronolith_shares_groups  
CHANGE group_uid group_u...
psql:2.2_to_2.3.sql:3: