On Fri, Aug 29, 2025 at 11:45 AM David G. Johnston < david.g.johns...@gmail.com> wrote:
> On Fri, Aug 29, 2025 at 10:34 AM Merlin Moncure <mmonc...@gmail.com> > wrote: > >> On Fri, Aug 29, 2025 at 1:03 AM Joel Jacobson <j...@compiler.org> wrote: >> >>> *) Renaming of database objects seamless, thanks to function body being >>> parsed at function definition time and stored as expression nodes. >> >> >> How does that work in practice? for current SQL (not pl/pgsql) >> functions, this will fail: >> >> create function f() returns int as $$ create temp table i(i int); select >> * from i; $$ language sql; >> ERROR: relation "i" does not exist >> > > This example seems unrelated to the point being made. > sure, it's off topic to the main question, but it was noted in the intro. The query in the atomic sql function behaves no differently than an > equivalent view. OIDs don't care about search_path. > roger. merlin
