Re: Reverse Engineering - search constraints are not explicitly stated in the tables from the VIEW - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Reverse Engineering - search constraints are not explicitly stated in the tables from the VIEW
Date
Msg-id 30099.1415828654@sss.pgh.pa.us
Whole thread Raw
In response to Reverse Engineering - search constraints are not explicitly stated in the tables from the VIEW  (nill <nillx87@hotmail.com>)
List pgsql-hackers
nill <nillx87@hotmail.com> writes:
> I am analyzing query plans generated by the view in the database PostgreSQL
> 8.3, looking for missing information "constraints not explicitly registrants
> in the tables."

You realize of course that 8.3 is nearly 7 years old and has been out of
support for awhile.

> In the analysis of the query plan and its subplane, I can not understand
> what the parameter $0 represents, without looking the SQL query. My question
> is: looking only at the query plan product, you can understand what is the
> parameter $0?

It's a variable passed down from the outer query level.  It's true that
you can't tell which variable, in 8.3.  Less obsolete versions produce
more readable output though.  (I won't claim it's perfect; we still don't
try very hard to decompile ANY/ALL subplans.)
        regards, tom lane



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: REINDEX CONCURRENTLY 2.0
Next
From: Robert Haas
Date:
Subject: Re: On partitioning