BUG #15500: Cannot set NULL to a field with ENUM type

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #15500: Cannot set NULL to a field with ENUM type
Дата
Msg-id 15500-2ebc24774d08db26@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #15500: Cannot set NULL to a field with ENUM type  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15500
Logged by:          Ivan Shibkikh
Email address:      ivan.shib@gmail.com
PostgreSQL version: 11.1
Operating system:   Alpine Linux
Description:

1. Created a new type:
> create type day_of_week as enum ('Sunday', 'Monday', 'Tuesday',
'Wednesday', 'Thursday', 'Friday', 'Saturday');

2. Created a new table:
> CREATE TABLE public.schedule
(
    id SERIAL PRIMARY KEY NOT NULL,
    week_day day_of_week DEFAULT NULL,
    minute integer DEFAULT 0,
    hour integer DEFAULT 0
);

3. Insert a new record:
> INSERT INTO "public"."schedule" ("id", "week_day", "minute", "hour")
VALUES (DEFAULT, 'NULL', DEFAULT, DEFAULT);

Result:
[42804] ERROR: column "week_day" is of type day_of_week but expression is of
type character varying
Hint: You will need to rewrite or cast the expression.
Position: 87

Why I cannot set NULL to ENUM field?


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Usage of pg_waldump
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #15500: Cannot set NULL to a field with ENUM type