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

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