BUG #8131: Not Null column should set default value when inserting or setting null

From: Hajo(at)Lemcke(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #8131: Not Null column should set default value when inserting or setting null
Date: 2013-05-02 08:18:17
Message-ID: E1UXoiX-0006om-Bv@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 8131
Logged by: Hajo Lemcke
Email address: Hajo(at)Lemcke(dot)com
PostgreSQL version: 9.2.4
Operating system: Win-7
Description:

I would like to have the default value replace a given null value if the
column is specified with not null and default.

The SQL specification only requires to set the default value when the column
is omitted on insert or update.

I think this is a flaw in the specification because it requires developers
to create multiple statements for inserts and updates for all combinations
of default not null columns.

Browse pgsql-bugs by date

  From Date Subject
Next Message Hajo 2013-05-02 08:18:38 BUG #8132: Not Null column should set default value when inserting or setting null
Previous Message Greg Stark 2013-05-02 00:42:27 Re: [BUGS] BUG #8128: pg_dump (>= 9.1) failed while dumping a scheme named "old" from PostgreSQL 8.4