> On 23.05.2023, at 19:40, Tom Lane wrote:
>
> Markus Winand writes:
>> I noticed that errors due to writable CTEs in read-only or non-volatile
>> context say the offensive command is SELECT.
>
> Good point.
>
>> My first thought was that these error messages should mention INSERT, but
>> a
Markus Winand writes:
> I noticed that errors due to writable CTEs in read-only or non-volatile
> context say the offensive command is SELECT.
Good point.
> My first thought was that these error messages should mention INSERT, but
> after looking into the source I’m not sure anymore. The name
Hi!
I noticed that errors due to writable CTEs in read-only or non-volatile context
say the offensive command is SELECT.
For example a writeable CTE in a IMMUTABLE function:
CREATE TABLE t (x INTEGER);
CREATE FUNCTION immutable_func()
RETURNS INTEGER
LANGUAGE SQL
IMMUTABLE
AS $$
WI
