Re: Schema variables - new implementation for Postgres 15 - Mailing list pgsql-hackers

From walther@technowledgy.de
Subject Re: Schema variables - new implementation for Postgres 15
Date
Msg-id 42ea2784-192a-476b-8e01-4c62302d00c0@technowledgy.de
Whole thread Raw
In response to Re: Schema variables - new implementation for Postgres 15  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: Schema variables - new implementation for Postgres 15
List pgsql-hackers
Alvaro Herrera:
> Perhaps the solution to all this is to avoid having the variables be
> implicitly present in the range table of all queries.  Instead, if you
> need a variable's value, then you need to add the variable to the FROM
> clause;

+1

This should make it easier to work with composite type schema variables 
in some cases.  It could also enable schema qualifying of schema 
variables, or at least make it easier to do, I think.

In this case variables would share the same namespace as tables and 
views, right?  So I could not create a variable with the same name as 
another table.  Which is a good thing, I guess.  Not sure how it's 
currently implemented in the patch.

Best,

Wolfgang



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Schema variables - new implementation for Postgres 15
Next
From: Ranier Vilela
Date:
Subject: Re: Avoid possible dereference null pointer (src/backend/catalog/pg_depend.c)