[horde] horde webmail upgrade issue

[tom burkart]

Quoting Jan Schneider <jan at horde.org>:

>> [ ERROR! ] Reading the existing table structure failed. Error messages:
>> MDB2_Schema Error: schema validation error
>> default value of "pref_scope" is incorrect: "''::character varying" is
>> larger than "16"
>>
>> The actual table definition is as follows (PostgreSQL 8.3.5, SUSE 11.1):
>> CREATE TABLE horde_prefs (
>>     pref_uid character varying(255) NOT NULL,
>>     pref_scope character varying(16) DEFAULT ''::character varying NOT NULL,
> What does this line mean, I'm not a PostgreSQL expert? This is what is
> causing the problem though, and I wonder if it is some weird psql
> stuff, or if MDB2 is broken.
I am not a PostgreSQL expert either, however, from my reading it is an  
explicit type cast.

Maybe it is needed as two ' represents a literal ' in SQL, hence it  
may be needed to disambiguate this case.

tom