Re: [BUGS] multicolumn PRIMARY KEY introduces wrong 'not null' fields

2001-08-20 Thread Tom Lane
[EMAIL PROTECTED] writes: > 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. (A) it makes no sense otherwise, and (B) the SQL spec says so: A unique constraint is satisfied if and only if no two row

[BUGS] multicolumn PRIMARY KEY introduces wrong 'not null' fields

2001-08-20 Thread pgsql-bugs
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