6.0.0-beta1
▾
Tasks
New Task
Search
Photos
Wiki
▾
Tickets
New Ticket
Search
dev.horde.org
Toggle Alerts Log
Help
10/20/25
H
istory
A
ttachments
C
omment
W
atch
Download
Comment on [#7598] scripts/upgrades/2.2_to_2.2.1.sql needs pgsql version
*
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
N
ew Ticket
M
y Tickets
S
earch
Q
uery Builder
R
eports
Saved Queries
Open Bugs
Bugs waiting for Feedback
Open Bugs in Releases
Open Enhancements
Enhancements waiting for Feedback
Bugs with Patches
Enhancements with Patches
Release Showstoppers
Stalled Tickets
New Tickets
Horde 5 Showstoppers