Обсуждение: quoting problem
Hi there, I'm a bit confused with the quoting, see below: contrib_regression=# ALTER OPERATOR CLASS pg_catalog.int4_ops USING btree OWNER TO megera; contrib_regression=# ALTER OPERATOR CLASS "pg_catalog.int4_ops" USING btree OWNER TO megera; ERROR: operator class "pg_catalog.int4_ops" does not exist for access method "btree" contrib_regression=# ALTER OPERATOR CLASS pg_catalog."int4_ops" USING btree OWNER TO megera; ALTER OPERATOR CLASS Is't intentional or bug ? Regards, Oleg _____________________________________________________________ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83
On Mon, Dec 18, 2006 at 02:11:42PM +0300, Oleg Bartunov wrote: > Hi there, > > I'm a bit confused with the quoting, see below: > > contrib_regression=# ALTER OPERATOR CLASS pg_catalog.int4_ops USING btree > OWNER TO megera; > contrib_regression=# ALTER OPERATOR CLASS "pg_catalog.int4_ops" USING btree > OWNER TO megera; > ERROR: operator class "pg_catalog.int4_ops" does not exist for access > method "btree" > contrib_regression=# ALTER OPERATOR CLASS pg_catalog."int4_ops" USING btree > OWNER TO megera; > ALTER OPERATOR CLASS > > Is't intentional or bug ? It's normal. In your second example you've got a single identifier. The identifier itself does not contain the '.', that's a seperator and so isn't part of the actual identifier. Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.
On Mon, 18 Dec 2006, Martijn van Oosterhout wrote: > On Mon, Dec 18, 2006 at 02:11:42PM +0300, Oleg Bartunov wrote: >> Hi there, >> >> I'm a bit confused with the quoting, see below: >> >> contrib_regression=# ALTER OPERATOR CLASS pg_catalog.int4_ops USING btree >> OWNER TO megera; >> contrib_regression=# ALTER OPERATOR CLASS "pg_catalog.int4_ops" USING btree >> OWNER TO megera; >> ERROR: operator class "pg_catalog.int4_ops" does not exist for access >> method "btree" >> contrib_regression=# ALTER OPERATOR CLASS pg_catalog."int4_ops" USING btree >> OWNER TO megera; >> ALTER OPERATOR CLASS >> >> Is't intentional or bug ? > > It's normal. In your second example you've got a single identifier. The > identifier itself does not contain the '.', that's a seperator and so > isn't part of the actual identifier. Thanks for the explanation ! > > Have a nice day, > Regards, Oleg _____________________________________________________________ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83