multicolumn PRIMARY KEY introduces wrong 'not null' fields

Поиск
Список
Период
Сортировка
От pgsql-bugs@postgresql.org
Тема multicolumn PRIMARY KEY introduces wrong 'not null' fields
Дата
Msg-id 200108210144.f7L1iKC91768@hub.org
обсуждение исходный текст
Ответы Re: multicolumn PRIMARY KEY introduces wrong 'not null' fields  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Lamar Owen
Дата:
Сообщение: Re: Building 7.1.3 with PL/Perl support on RedHat
Следующее
От: Tom Lane
Дата:
Сообщение: Re: multicolumn PRIMARY KEY introduces wrong 'not null' fields