Re: missing schema qualifications in psql
Greg Sabino Mullane <greg@turnstep.com>
From: "Greg Sabino Mullane" <greg@turnstep.com>
To: pgsql-hackers@postgresql.org
Date: 2010-04-01T13:43:15Z
Lists: pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 > While psql is careful to schema-qualify all references to built-in > objects (pg_catalog.*), it completely neglects to do this for built-in > operators, which can lead to surprising misbehaviors when users have > created custom operators. Here is a patch to address that. It will > need a bit of testing. Er...wouldn't this only be a problem if someone creates custom operators *and* forces pg_catalog to the end of the search_path? Wouldn't an easier solution be to prepend pg_catalog to the search_path when doing backslash commands? - -- Greg Sabino Mullane greg@turnstep.com PGP Key: 0x14964AC8 201004010941 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iEYEAREDAAYFAku0oqQACgkQvJuQZxSWSsiJmACghUKR/i+uyJ2n+beuAid4w432 s0oAnArOf1npuMF/7QJ87ZVmSYMlJTRp =/+yd -----END PGP SIGNATURE-----