Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Error for row-level triggers with transition tables on partitioned tables
Date
Msg-id 1792183.1667409628@sss.pgh.pa.us
Whole thread Raw
In response to Error for row-level triggers with transition tables on partitioned tables  (Etsuro Fujita <etsuro.fujita@gmail.com>)
Responses Re: Error for row-level triggers with transition tables on partitioned tables
List pgsql-hackers
Tree view 
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.

            regards, tom lane

pgsql-hackers by date:

Previous
From: "Imseih (AWS), Sami"
Date:
Subject: Re: Add index scan progress to pg_stat_progress_vacuum
Next
From: Andres Freund
Date:
Subject: Re: Prefetch the next tuple's memory during seqscans