News for hackers. Stuff that matters.

A comment on Postgres 15 improves UNIQUE and NULL. Parent comment

Re:Postgres 15 improves UNIQUE and NULL by TheP1000 on Monday July 11, 2022 @03:03PM (#32060303)
There are lots of good reasons in that thread why the patch was declined.

The patch made things more lenient which makes things less compatible (this whole thread is about ANSI SQL standards and they do matter) and changes what was an error behavior to now silently succeed.

+1 to postgres devs for curating patches.

[ Parent | on HN ]
Re:Postgres 15 improves UNIQUE and NULL by DangitBobby on Monday July 11, 2022 @08:59PM (#32064272)
I read the thread and have to disagree with "lots of good reasons". I'm pretty sure there are plenty of things in the postgres dialect that are not cross compatible with any other dialect.

I agree with curating patches in general, but it's a double edged sword and inaccurate to say you can just spend your weekend to get something you care about.

[ Parent | on HN ]