Postgres Pro
Downloads
Home   >   mailing lists

Re: Error for row-level triggers with transition tables on partitioned tables - Mailing list pgsql-hackers

From Etsuro Fujita
Subject Re: Error for row-level triggers with transition tables on partitioned tables
Date
Msg-id CAPmGK14e0C9G6S8hpkG8Af6Coqhxs0y3ozdb+ToOAk0ZC3rt_g@mail.gmail.com
Whole thread Raw
In response to Re: Error for row-level triggers with transition tables on partitioned tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
On Thu, Nov 3, 2022 at 2:20 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Etsuro Fujita <etsuro.fujita@gmail.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

pgsql-hackers by date:

Previous
From: qinghao huang
Date:
Subject: found the document `README.parallel` to be a little bit incorrect
Next
From: Laurenz Albe
Date:
Subject: Re: explain_regress, explain(MACHINE), and default to explain(BUFFERS) (was: BUFFERS enabled by default in EXPLAIN (ANALYZE))