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

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/7598
------------------------------------------------------------------------------
  Ticket             | 7598
  Updated By         | kristian.lance at crc.ca
  Summary            | scripts/upgrades/2.2_to_2.2.1.sql needs pgsql version
  Queue              | Mnemo
  Version            | 2.2.1
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


kristian.lance at crc.ca (2008-10-28 14:46) wrote:

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