Re: Is this logical? - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Is this logical?
Date
Msg-id 20060909164314.J77543@megazone.bigpanda.com
Whole thread Raw
In response to Is this logical?  ("Behrang Saeedzadeh" <behrangsa@gmail.com>)
List pgsql-general
On Sun, 10 Sep 2006, Behrang Saeedzadeh wrote:

> But "not null" is in contradiction with "default null" so the create
> statement should not proceed successfuly IMHO.

The fact that the default value isn't going to pass a constraint means
that it's invalid to not provide a value or use default, yes, but I don't
agree that it's necessarily a real contradiction in the definition,
especially given that AFAIK there's no way to opt out of having a default
(apart from a construct like the one given).


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Idle in transaction state.
Next
From: Dave Cramer
Date:
Subject: Re: Idle in transaction state.