Tickets :: [#7598] scripts/upgrades/2.2_to_2.2.1.sql needs pgsql version

Summary	scripts/upgrades/2.2_to_2.2.1.sql needs pgsql version
Queue	Mnemo
Queue Version	2.2.1
Type	Bug
State	Resolved
Priority	1. Low
Owners
Requester	kristian.lance (at) crc (dot) ca
Created	10/28/2008 (6254 days ago)
Due
Updated	10/28/2008 (6254 days ago)
Assigned
Resolved	10/28/2008 (6254 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

10/28/2008 10:34:08 PM	Jan Schneider	Comment #3 State ⇒ Resolved	Reply to this comment
This script has already been added.

10/28/2008 06:46:32 PM	kristian (dot) lance (at) crc (dot) ca	Comment #2	Reply to this comment
Correction: In the mnemo/scripts/upgrades/2.2_to_2.2.1.sql file, the following... [Show Quoted Text - 16 lines][Hide Quoted Text] In the kronolith/scripts/upgrades/2.2_to_2.2.1.sql file, the following queries are not accepted by Postgresql: ALTER TABLE mnemo_shares CHANGE share_owner share_owner VARCHAR(255); ALTER TABLE mnemo_shares_users CHANGE user_uid user_uid VARCHAR(255); These will work with MySQL, but there should be a 2.2_to_2.2.1.pgsql.sql file containing the following PostgreSQL-compatible queries: ALTER TABLE mnemo_shares ALTER COLUMN share_owner TYPE VARCHAR(255); ALTER TABLE mnemo_shares_users ALTER COLUMN user_uid TYPE VARCHAR(255); This is covered by Changing a Column's Data Type on the following PostgreSQL reference page: http://www.postgresql.org/docs/8.3/static/ddl-alter.html#AEN2337

10/28/2008 06:31:24 PM	kristian (dot) lance (at) crc (dot) ca	Comment #1 Priority ⇒ 1. Low Patch ⇒ No Milestone ⇒ Queue ⇒ Mnemo Summary ⇒ scripts/upgrades/2.2_to_2.2.1.sql needs pgsql version Type ⇒ Bug State ⇒ Unconfirmed	Reply to this comment
In the kronolith/scripts/upgrades/2.2_to_2.2.1.sql file, the following queries are not accepted by Postgresql: ALTER TABLE mnemo_shares CHANGE share_owner share_owner VARCHAR(255); ALTER TABLE mnemo_shares_users CHANGE user_uid user_uid VARCHAR(255); These will work with MySQL, but there should be a 2.2_to_2.2.1.pgsql.sql file containing the following PostgreSQL-compatible queries: ALTER TABLE mnemo_shares ALTER COLUMN share_owner TYPE VARCHAR(255); ALTER TABLE mnemo_shares_users ALTER COLUMN user_uid TYPE VARCHAR(255); This is covered by Changing a Column's Data Type on the following PostgreSQL reference page: http://www.postgresql.org/docs/8.3/static/ddl-alter.html#AEN2337