multicolumn PRIMARY KEY introduces wrong 'not null' fields - Mailing list pgsql-bugs

Laurent Martelli (laurent@bearteam.org) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
multicolumn PRIMARY KEY introduces wrong 'not null' fields

Long Description
If you have a primary key on several columns, each of these columns is given the 'not null' modifier. I can't see why
thisis required. In the example below, the 'Type' column is made 'not null'. 

Sample Code
CREATE TABLE test (
        Type integer,
        PictureID integer NOT NULL REFERENCES pictures(PictureID),
        Value character varying(128) NOT NULL,
    PRIMARY KEY (Type,PictureID,Value));


No file was uploaded with this report