ons would be:
1) Aside from preventing wraparounds, in what other circumstances does
autovacuum run?
2) Did changing the autovacuum config settings cause the autovacuums to
stop, if so, why, when autovacuum is set to 'off' the whole time?
Best Regards,
Paolo Saul
must specify the outer query's table reference inside the
subquery. I suspect the original intent was to use the outer query columns
in some processing inside the subquery, which is valid. I'm just wondering
why an explicit reference isn't required to distinguish the column. For
convenience, or part of the SQL spec?
Cheers!
--Paolo Saul
Thank you for clearing that up.
Regards,
Paolo Saul
> This behavior is required by the SQL standard. It's called an outer
> reference.
>
>regards, tom lane
>
