Re: support virtual generated column not null constraint

Поиск
Список
Период
Сортировка
От Navneet Kumar
Тема Re: support virtual generated column not null constraint
Дата
Msg-id CANzA6sqsVeN-p8dqtM7v4376neOE74CDLfZKwvWG7zb7a+btZQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: support virtual generated column not null constraint  (Navneet Kumar <thanit3111@gmail.com>)
Список pgsql-hackers


This scenario fails
1. CREATE TABLE person (
    id INT GENERATED BY DEFAULT AS IDENTITY,
    first_name VARCHAR(50) NOT NULL,
    last_name VARCHAR(50) NOT NULL
);

2. INSERT INTO person (first_name, last_name)
VALUES ('first', 'last');

3. ALTER TABLE person
ADD COLUMN full_name VARCHAR(100) GENERATED ALWAYS AS (first_name || ' ' || last_name) VIRTUAL;

Forgot to mention NOT NULL constraint in above query.

3. ALTER TABLE person
ADD COLUMN full_name VARCHAR(100) NOT NULL GENERATED ALWAYS AS (first_name || ' ' || last_name) VIRTUAL;

ERROR:  column "full_name" of relation "person" contains null values
 

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