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

2013-05-02 Thread Hajo
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 i

[BUGS] BUG #8132: Not Null column should set default value when inserting or setting null

2013-05-02 Thread Hajo
The following bug has been logged on the website: Bug reference: 8132 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 i

Re: [BUGS] BUG #8132: Not Null column should set default value when inserting or setting null

2013-05-02 Thread Tom Lane
h...@lemcke.com writes: > 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 spec

[BUGS] Re: BUG #8132: Not Null column should set default value when inserting or setting null

2013-05-02 Thread Thomas Kellerer
h...@lemcke.com wrote on 02.05.2013 10:18: 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

[BUGS] After reboot some dll files are missing preventing PG to start

2013-05-02 Thread Grégory Bellier
Dear PostgreSQL hackers, Postgresql version: 8.4.16 System: Windows 7 Pro x86_64 from time to time, on several different machines (sharing the same Windows 7 image), I've noticed that PostgreSQL and other postgresql related binaries (psql.exe for example) refuse to start after having rebooted