Re: Virtual generated columns - Mailing list pgsql-hackers

From Marcos Pegoraro
Subject Re: Virtual generated columns
Date
Msg-id CAB-JLwbMeiBkepTiw_zT-19-XjSK6tWP1Efxr2SsRK0r_GHK+w@mail.gmail.com
Whole thread Raw
In response to Re: Virtual generated columns  (Vik Fearing <vik@postgresfriends.org>)
List pgsql-hackers
Em qua., 8 de jan. de 2025 às 16:23, Vik Fearing <vik@postgresfriends.org> escreveu:
This is lying to the planner, and you get to enjoy whatever breaks
because of it.  A function that accesses external data is not immutable;
it is stable at best.

I understand that, but it's not documented, so users can think that way is fine. So, it would be good to explain why this way could break this or that.

regards
Marcos

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Virtual generated columns
Next
From: Andres Freund
Date:
Subject: Re: Reorder shutdown sequence, to flush pgstats later