| Summary | scripts/upgrades/2.2_to_2.3.sql needs pgsql version |
| Queue | Kronolith |
| Queue Version | 2.3 |
| Type | Bug |
| State | Duplicate |
| Priority | 1. Low |
| Owners | |
| Requester | kristian.lance (at) crc (dot) ca |
| Created | 10/28/08 (6372 days ago) |
| Due | |
| Updated | 10/28/08 (6372 days ago) |
| Assigned | |
| Resolved | 10/28/08 (6372 days ago) |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | |
| Patch | No |
State ⇒ Duplicate
bug #7454.State ⇒ Unconfirmed
Priority ⇒ 1. Low
Type ⇒ Bug
Summary ⇒ scripts/upgrades/2.2_to_2.3.sql needs pgsql version
Queue ⇒ Kronolith
Milestone ⇒
Patch ⇒ No
queries are not accepted by Postgresql:
ALTER TABLE kronolith_shares CHANGE share_owner share_owner VARCHAR(255);
ALTER TABLE kronolith_shares_users CHANGE user_uid user_uid VARCHAR(255);
ALTER TABLE kronolith_shares_groups CHANGE group_uid group_uid VARCHAR(255);
These will work with MySQL, but there should be a 2.2_to_2.3.pgsql.sql
file containing the following PostgreSQL-compatible queries:
ALTER TABLE kronolith_shares ALTER COLUMN share_owner TYPE VARCHAR(255);
ALTER TABLE kronolith_shares_users ALTER COLUMN user_uid TYPE VARCHAR(255);
ALTER TABLE kronolith_shares_groups ALTER COLUMN group_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