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

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: BUG #15500: Cannot set NULL to a field with ENUM type
Дата
Msg-id 20181113145637.nyxrtmb5pwcct5pa@alvherre.pgsql
обсуждение исходный текст
Ответ на BUG #15500: Cannot set NULL to a field with ENUM type  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
On 2018-Nov-13, PG Bug reporting form wrote:

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

This is not a NULL value -- it's a string that says NULL.  Try with

INSERT INTO public.schedule (id, week_day, minute, hour)
 VALUES (DEFAULT, NULL, DEFAULT, DEFAULT);

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15500: Cannot set NULL to a field with ENUM type
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: BUG #15460: Error while creating index or constraint