SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-12-2008, 06:01 AM
| ||||
| ||||
 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match      |
|
04-12-2008, 06:01 AM
| |||
| |||
| Re: quoting problem 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. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFFhngdIB7bNG8LQkwRAm9bAJ0fKUUPu+1fYAv4N0uYtC dP8LiRUQCaAw3W iUX8pxllRLVWgnOxETIeziM= =tyxN -----END PGP SIGNATURE----- |
|
04-12-2008, 06:01 AM
| ||||
| ||||
| Re: quoting problem 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings |
Linear Mode
