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. > Also, how do search_path interactions work in your understanding? > > The query in the atomic sql function behaves no differently than an equivalent view. OIDs don't care about search_path. David J.
