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

6.0.0-beta1

11/6/25

Summary	PostgreSQL needs own 2.2_to_2.3 upgrade script
Queue	Kronolith
Queue Version	2.3
Type	Bug
State	Resolved
Priority	2. Medium
Owners	chuck (at) horde (dot) org
Requester	michael.menge (at) zdv (dot) uni-tuebingen (dot) de
Created	10/08/2008 (6238 days ago)
Due
Updated	10/09/2008 (6237 days ago)
Assigned	10/08/2008 (6238 days ago)
Resolved	10/09/2008 (6237 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

10/09/2008 03:35:16 PM	Chuck Hagenbuch	Comment #6 Assigned to Chuck Hagenbuch State ⇒ Resolved	Reply to this comment
Committed, thanks.

10/09/2008 03:35:11 PM	CVS Commit	Comment #5	Reply to this comment
Changes have been made in CVS for this ticket: http://cvs.horde.org/co.php/kronolith/scripts/upgrades/2.2_to_2.3.pgsql.sql?r=1.1

10/08/2008 02:15:36 PM	michael (dot) menge (at) zdv (dot) uni-tuebingen (dot) de	Comment #4	Reply to this comment
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:

10/08/2008 12:53:09 PM	Chuck Hagenbuch	Comment #3 State ⇒ Feedback	Reply to this comment
Can you please say _what_ errors?

10/08/2008 06:50:13 AM	michael (dot) menge (at) zdv (dot) uni-tuebingen (dot) de	Comment #2	Reply to this comment
sorry I forgot to check the patch ceckbox

10/08/2008 06:47:04 AM	michael (dot) menge (at) zdv (dot) uni-tuebingen (dot) de	Comment #1 Priority ⇒ 2. Medium Type ⇒ Bug Summary ⇒ PostgreSQL needs own 2.2_to_2.3 upgrade script Queue ⇒ Kronolith Milestone ⇒ Patch ⇒ No New Attachment: kronolith_2.2_to_2.3.pgsql.sql State ⇒ Unconfirmed	Reply to this comment
PostgreSQL shows Syntax errors with scripts/upgrades/2.2_to_2.3.sql