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

From Lincoln Yeoh
Subject Re: Is this logical?
Date
Msg-id 5.2.1.1.1.20060911001247.02e46888@localhost
Whole thread Raw
In response to Is this logical?  ("Behrang Saeedzadeh" <behrangsa@gmail.com>)
List pgsql-general
At 01:12 AM 9/10/2006 +0330, Behrang Saeedzadeh wrote:

>Hi,
>
>Shouldn't this create statement trigger an error?
>
>  create table bar (col1 int not null default null);

No.

>Shouldn't I be forbidden to insert null values into a non null column?

Yes.

Use "not null default null" when you want to force apps/people etc to
explicitly specify values when inserting.

Link.


pgsql-general by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Reinstall problem of PostgreSQL in Windows XP
Next
From: Alvaro Herrera
Date:
Subject: Re: pg_dump and cluster