Re: [HACKERS] regproc and when to schema-qualify

2017-06-11 Thread Tom Lane
Chapman Flack writes: > The manual says regproc "will display schema-qualified names on output > if the object would not be found in the current search path without > being qualified." That's less than the full truth :-( > Is regproc displaying the schema in this case because there are two > ove

[HACKERS] regproc and when to schema-qualify

2017-06-11 Thread Chapman Flack
I was idly following along in GSoC 2017: Foreign Key Arrays when I noticed this: =# select * from pg_amproc where amprocfamily = 2745; amprocfamily | amproclefttype | amprocrighttype | amprocnum | amproc --++-+---+ 2745 | 2277