Laurent Martelli ([EMAIL PROTECTED]) 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 this is 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
