Bah, I mean pg_get_indexdef of course :-) > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Dave Page > Sent: 12 June 2006 12:12 > To: pgsql-hackers@postgresql.org > Subject: [HACKERS] pg_get_viewdef - opclass > > Following a pgAdmin bug report, I noticed that pg_get_viewdef doesn't > return the opclass when called for a specific column (in 8.1 > at least) - > for example, for the index: > > CREATE UNIQUE INDEX bar_pattern_idx2 ON foofoo USING btree > (lower((bar)::text) bpchar_pattern_ops, bar2) > > A query on column 1 returns: > > lower((bar)::text) > > It seems to me that the opclass should be included as well. > > Regards, Dave. > > ---------------------------(end of > broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] > so that your > message can get through to the mailing list cleanly >
---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
