The following bug has been logged on the website: Bug reference: 8131 Logged by: Hajo Lemcke Email address: h...@lemcke.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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs