#6 setup-postgres.pl error (+fix)

[Anonymous]

In a previously posted bug, the setup-postgres.pl
script chokes in certain instances (I'm assuming with
certain newer versions of postgres) due to the fact
that UL_GROUP.GROUP_ID and UL_USER.USER_ID are not
explicitly specified to be unique. They can be
specified as primary keys:

create table UL_USER (
USER_ID serial PRIMARY KEY,
GROUP_ID int4 references UL_GROUP (GROUP_ID),
LOGIN text unique,
PASSWORD text,
EMAIL text unique
);

or simply as unique:

create table UL_GROUP (
GROUP_ID serial unique,
GROUP_NAME text
);

and the problem is fixed.

-Andrew