Package: libnss-pgsql1
Version: 1.3
Severity: minor
Tags: patch
accounts.uid is not the primary key, so usergroups.uid cannot be a
foreign key. Either accounts.uid needs to be the primary key, or
groups.uid needs to not be a foreign key. I've attached a patch for
each.
-- System Information:
Debian Release: testing/unstable
APT prefers unstable
APT policy: (500, 'unstable')
Architecture: amd64 (x86_64)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.15-1-amd64-k8
Locale: LANG=C, LC_CTYPE=C (charmap=UTF-8) (ignored: LC_ALL set to en_GB.UTF-8)
Versions of packages libnss-pgsql1 depends on:
ii libc6 2.3.6-3 GNU C Library: Shared libraries an
ii libpq4 8.1.3-1 PostgreSQL C client library
libnss-pgsql1 recommends no packages.
-- no debconf information
*** dbschema.sql 2006-03-04 23:30:16.000000000 +0000
--- dbschema-new1.sql 2006-03-04 23:31:13.000000000 +0000
***************
*** 25,29 ****
"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")
);
--- 25,28 ----
*** dbschema.sql 2006-03-04 23:30:16.000000000 +0000
--- dbschema-new2.sql 2006-03-04 23:31:26.000000000 +0000
***************
*** 17,23 ****
"subnet" character varying(8),
"modemserial" character varying(20),
"deleted" bool DEFAULT 'f',
! PRIMARY KEY ("login")
);
CREATE TABLE "usergroups" (
--- 17,23 ----
"subnet" character varying(8),
"modemserial" character varying(20),
"deleted" bool DEFAULT 'f',
! PRIMARY KEY ("uid")
);
CREATE TABLE "usergroups" (
