| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> |
| Cc: | Amit Langote <amitlangote09(at)gmail(dot)com>, exclusion(at)gmail(dot)com, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
| Subject: | Re: BUG #15668: Server crash in transformPartitionRangeBounds |
| Date: | 2019-03-14 04:23:08 |
| Message-ID: | 20190314042308.GG3493@paquier.xyz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
On Wed, Mar 13, 2019 at 03:17:47PM +0900, Amit Langote wrote:
> but on HEAD, you get:
>
> create table foo (a int default (avg(foo.a)));
> ERROR: aggregate functions are not allowed in DEFAULT expressions
I actually think that what you propose here makes more sense than what
HEAD does because the most inner expression gets evaluated first.
This for example generates the same error as on HEAD:
=# create table foo (a int default (avg(1)));
ERROR: 42803: aggregate functions are not allowed in DEFAULT expressions
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Bug reporting form | 2019-03-14 11:24:27 | BUG #15694: Server crash in EXPLAIN with LATERAL and a partitioned table |
| Previous Message | Amit Langote | 2019-03-14 02:35:37 | Re: Requiring temp tables to have replication identity defined |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Takuma Hoshiai | 2019-03-14 04:37:00 | Proposal to suppress errors thrown by to_reg*() |
| Previous Message | David Rowley | 2019-03-14 03:48:13 | Re: Tid scan improvements |