Re: Getting error 42P02, despite query parameter being sent - Mailing list pgsql-general

From David G. Johnston
Subject Re: Getting error 42P02, despite query parameter being sent
Date
Msg-id CAKFQuwb+5Rxp_gV2ZD7w27xt_QV-Okn2veFg1zMDduGUQyUDiA@mail.gmail.com
Whole thread Raw
In response to Re: Getting error 42P02, despite query parameter being sent  (Max Ulidtko <ulidtko@gmail.com>)
List pgsql-general
On Sun, Nov 17, 2024 at 3:10 AM Max Ulidtko <ulidtko@gmail.com> wrote:
I assumed that $1 would get substituted *at query time*

The "select" portion of a "create view" query does not get executed during processing of "create view" and it is the "select" execution part of the executor code that performs parameter substitution.  IOW, "at query time" never actually happens, the query is only considered as a literal to be parsed.

David J.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Getting error 42P02, despite query parameter being sent
Next
From: Achilleas Mantzios
Date:
Subject: Re: Getting error 42P02, despite query parameter being sent