Bug#364462: dbscheme.sql give an error (not unique)

[Michelle Konzack]

Package: libnss-pgsql1
Version: 1.3
Severity: normal

Error description:

psql -U pampgsql system -f dbscheme.sql
psql:/usr/share/doc/libnss-pgsql1/examples/dbschema.sql:7: NOTICE:  CREATE 
TABLE will create implicit sequence "groups_gid_seq" for "serial" column 
"groups.gid"
psql:/usr/share/doc/libnss-pgsql1/examples/dbschema.sql:7: NOTICE:  CREATE 
TABLE / PRIMARY KEY will create implicit index "groups_pkey" for table "groups"
CREATE TABLE
psql:/usr/share/doc/libnss-pgsql1/examples/dbschema.sql:21: NOTICE:  CREATE 
TABLE will create implicit sequence "accounts_uid_seq" for "serial" column 
"accounts.uid"
psql:/usr/share/doc/libnss-pgsql1/examples/dbschema.sql:21: NOTICE:  CREATE 
TABLE / PRIMARY KEY will create implicit index "accounts_pkey" for table 
"accounts"
CREATE TABLE
psql:/usr/share/doc/libnss-pgsql1/examples/dbschema.sql:29: NOTICE:  CREATE 
TABLE / PRIMARY KEY will create implicit index "usergroups_pkey" for table 
"usergroups"
psql:/usr/share/doc/libnss-pgsql1/examples/dbschema.sql:29: ERROR:  there is no 
unique constraint matching given keys for referenced table "accounts"

Attached I have a corrected one which gives no error

Greetings
    Michelle


-- System Information
Debian Release: 3.1
Kernel Version: Linux samba3.private 2.4.27-2-386 #1 Mon May 16 16:47:51 JST 
2005 i686 GNU/Linux


Versions of the packages libnss-pgsql1 depends on:

CREATE TABLE "groups" (
        "gid" serial NOT NULL UNIQUE,
        "name" character varying(16) NOT NULL,
        "descr" character varying,
        "passwd" character varying(20),
        PRIMARY KEY ("gid")
);

CREATE TABLE "accounts" (
        "uid" serial NOT NULL UNIQUE,
        "login" character varying(8) NOT NULL,
        "passwd" character varying(30) NOT NULL,
        "shell" character varying DEFAULT '/bin/bash' NOT NULL,
        "homedir" character varying NOT NULL,
        "pwdexpire" timestamp,
        "enabled" bool DEFAULT 't' NOT NULL,
        "subnet" character varying(8),
        "modemserial" character varying(20),
        "deleted" bool DEFAULT 'f',
        PRIMARY KEY ("login")
);

CREATE TABLE "usergroups" (
        "gid" int4 NOT NULL,
        "uid" int4 NOT NULL,
        PRIMARY KEY ("gid", "uid"),
        CONSTRAINT "ug_gid_fkey" FOREIGN KEY ("gid") REFERENCES "groups"("gid"),
        CONSTRAINT "ug_uid_fkey" FOREIGN KEY ("uid") REFERENCES 
"accounts"("uid")
);