Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #18014: Releasing catcache entries makes schema_to_xmlschema() fail when parallel workers are used - Mailing list pgsql-bugs

From Andy Fan
Subject Re: BUG #18014: Releasing catcache entries makes schema_to_xmlschema() fail when parallel workers are used
Date
Msg-id CAKU4AWpqGMLLSDxUZg8RojUaBGUomFp3QmYo-b7zX02q8zxmRA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #18014: Releasing catcache entries makes schema_to_xmlschema() fail when parallel workers are used  (Alexander Lakhin <exclusion@gmail.com>)
List pgsql-bugs
Tree view
Hi:
 
I think that we need to determine the level where the problem that should
be fixed is:

Since this thread has not been updated in the last 20 days, I'm not
sure if any people are still working on this. If not, I think considering
reducing the level of the fix is an option, to avoid the unstable testcase. 
 
Please look at the patch attached, that makes
schema_get_xml_visible_tables(Oid nspid) isolated from changes in other
namespaces.

I read the patch and it looks good and the change is pretty mild. so
personally +1  for this solution.  Another solution suggested by me
is to force the query to go with index scan for the test case only [1], 
which we get the similar result but it just works in this test case.
I think Alexander's method is better,  I just put my findings here just
in case I missed something. 



--
Best Regards
Andy Fan

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18057: unaccent removes intentional spaces
Next
From: Michael Paquier
Date:
Subject: Re: BUG #18057: unaccent removes intentional spaces