Re: BUG #5053: domain constraints still leak

Поиск
Список
Период
Сортировка
От Sam Mason
Тема Re: BUG #5053: domain constraints still leak
Дата
Msg-id 20090914155850.GY5407@samason.me.uk
обсуждение исходный текст
Ответ на Re: BUG #5053: domain constraints still leak  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: BUG #5053: domain constraints still leak  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-bugs
On Mon, Sep 14, 2009 at 10:54:07AM -0500, Kevin Grittner wrote:
> Sam Mason <sam@samason.me.uk> wrote:
> > the deeper problem seems to be that the table was created as:
> >
> >   create table test (a tstdom);
> >
> > and not as:
> >
> >   create table test (a tstdom not null);
>
> Given that tstdom is declared as NOT NULL, is this difference
> considered a *feature* or is it an implementation quirk?

That's why I pointed it out!

Based on my reading of the SQL spec (and reading about Codd's
descriptions of domains) I'd say it was a bug/implementation quirk.

--
  Sam  http://samason.me.uk/

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: BUG #5053: domain constraints still leak
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: invalid page header in block 502758 of relation base/16388/16403