6.0.0-beta1
▾
Tasks
New Task
Search
Photos
Wiki
▾
Tickets
New Ticket
Search
dev.horde.org
Toggle Alerts Log
Help
7/25/25
H
istory
A
ttachments
C
omment
W
atch
Download
Comment on [#7600] scripts/upgrades/2.2.1_to_2.3.sql needs pgsql version
*
Your Email Address
*
Spam protection
Enter the letters below:
. .. ,.___. ..__. |\/| \./ [__ | || | | | | [___|__||__\
Comment
> In the turba/scripts/upgrades/2.2.1_to_2.3.sql file, the following > > 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
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