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