| From: | Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Error for row-level triggers with transition tables on partitioned tables |
| Date: | 2022-11-04 10:45:45 |
| Message-ID: | CAPmGK14e0C9G6S8hpkG8Af6Coqhxs0y3ozdb+ToOAk0ZC3rt_g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Nov 3, 2022 at 2:20 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> writes:
> > We do not currently allow row-level triggers on partitions to have
> > transition tables either, and the error message for that is “ROW
> > triggers with transition tables are not supported on partitions.”.
> > How about changing the DETAIL message to something similar to this
> > like “ROW triggers with transition tables are not supported on
> > partitioned tables.”, to avoid confusion? Patch attached. Will add
> > this to the upcoming CF.
>
> +1, this wording is better. I marked it RFC.
Cool! I have committed the patch.
Thanks for reviewing!
Best regards,
Etsuro Fujita
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2022-11-04 10:46:03 | Re: explain_regress, explain(MACHINE), and default to explain(BUFFERS) (was: BUFFERS enabled by default in EXPLAIN (ANALYZE)) |
| Previous Message | qinghao huang | 2022-11-04 10:43:34 | found the document `README.parallel` to be a little bit incorrect |