| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Jürgen Strobel <juergen+postgresql(at)strobel(dot)info> |
| Cc: | Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, Amit Langote <amitlangote09(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation |
| Date: | 2018-11-09 21:42:28 |
| Message-ID: | 20181109214228.faadf3xh6haphi6x@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
On 2018-Nov-09, Jürgen Strobel wrote:
> OK got it. I agree about differing COLLATE clauses making no sense and
> with the ERROR+WARNING solution, but I didn't report that.
Yeah, I happened to notice it on code inspection.
> The NULL violation is obvious too.
Yeah, IMO that was an obvious bugfix.
> I still hope for a bug fix for the DEFAULT clause with sensible
> restrictions.
Yeah, I understand that this is the one that you really care about.
However, I think a fix is unlikely to be back-patchable, because it may
break existing applications that are written to expect the current
behavior.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2018-11-09 22:33:39 | Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation |
| Previous Message | Jürgen Strobel | 2018-11-09 21:34:37 | Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2018-11-09 22:33:39 | Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation |
| Previous Message | Jürgen Strobel | 2018-11-09 21:34:37 | Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation |