Tickets :: Comment on [#7597] scripts/upgrades/2.2_to

* Your Email Address
* Spam protection	Enter the letters below: .__ . .. .\ /. . [__)\| \|\|__\| >< \|__\| \| \\|/\\|\| \|/ \\| \|
Comment	> In the kronolith/scripts/upgrades/2.2_to_2.3.sql file, the following > 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
Attachment
Watch this ticket