NikhilS <[EMAIL PROTECTED]> writes: >> Looks like pg_get_indexdef is unwell :-(
> yes, it was unwell in the area where the amcanorder was being processed. The > attached patch should fix this. Hm, there is a definitional issue here. Should pg_get_indexdef print this stuff at all when colno is nonzero? The header comment says that it is to return the column's variable or expression only. The existing code suppresses the opclass in this case, which to me suggests that it should suppress DESC/ASC as well. Which is not what Nikhil's patch does. Dave, I think we put in this variant of the function for pgAdmin --- what does pgAdmin need? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings