[imp] migration problems from 2.2 to 3.0

[Werner Reisberger]

On Sat, Mar 09, 2002 at 01:22:46PM -0500, Chuck Hagenbuch wrote:
> > Some more problems are minor. The pgsql tables definitions for categories.sql
> > and prefs.sql in horde 2.0 are broken (null instead of "not null").
> 
> Sorry, I have no idea what you mean by this. Which nulls? Or not nulls?

In category.sql is the line

  category_data VARCHAR(2048) null,

in prefs is the line

  pref_value      text null,

This does not work with postgresql (at least with my pgsql v. 6.4.2).

Does this mean "default null" or is "not" missing? I assumed the latter and
it worked for me.

 Werner