Re: BUG #17634: Inconsistent view_definition in information_schema.views - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #17634: Inconsistent view_definition in information_schema.views
Date
Msg-id 311953.1665500299@sss.pgh.pa.us
Whole thread Raw
In response to BUG #17634: Inconsistent view_definition in information_schema.views  (PG Bug reporting form <noreply@postgresql.org>)
Responses RE: BUG #17634: Inconsistent view_definition in information_schema.views
List pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> If I run my query against information_schema.views while my session is
> active in a schema that is referenced in my query, information_schema.views
> strips out that schema name. All other objects remain schema qualified.

This is not a bug, it's normal behavior of the rule decompiler:
object names are qualified only if necessary (where "necessary"
means "would not be found in a search_path search").

If you don't like it, set search_path to empty.

            regards, tom lane



pgsql-bugs by date:

Previous
From: Japin Li
Date:
Subject: Re: BUG #17633: Define rule on views which do insert to another relation trigger cache lookup failed error.
Next
From: Tom Lane
Date:
Subject: Re: BUG #17633: Define rule on views which do insert to another relation trigger cache lookup failed error.