Re: Question about NOT NULL and default values.

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Question about NOT NULL and default values.
Дата
Msg-id dcc563d10810162105m5e44b72fke9fcde4d96dc6288@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Question about NOT NULL and default values.  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Ответы Re: Question about NOT NULL and default values.  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Список pgsql-general
On Thu, Oct 16, 2008 at 10:01 PM, Stephan Szabo
<sszabo@megazone.bigpanda.com> wrote:
> On Fri, 17 Oct 2008, Tim Uckun wrote:
>
>> Is there a way to change this behavior so that an attempt to set the
>> column to NULL will result in the default value being put in the
>> field?
>
> I don't think so specifically with default, but you could use a before
> trigger instead that would put in a value in the new row if NULL was
> given.

I'm pretty sure that will fail as the primary key or not null
constraint comes first.

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

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Question about NOT NULL and default values.
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Question about NOT NULL and default values.