Disclaimer that this was found under RC1 so it might have been fixed in final release, though I don't recall it being reported, anyway, the problem is that tab completion does not seem to work for "\h alter operator class".
template1=# \h ALTER AGGREGATE DOMAIN INDEX SCHEMA TABLESPACE USER CONVERSION FUNCTION LANGUAGE SEQUENCE TRIGGER DATABASE GROUP OPERATOR TABLE TYPE template1=# \h ALTER OPERATOR template1=# \h ALTER OPERATOR CL template1=# \h ALTER OPERATOR CLASS Command: ALTER OPERATOR CLASS Description: change the definition of an operator class Syntax: ALTER OPERATOR CLASS name USING index_method RENAME TO newname ALTER OPERATOR CLASS name USING index_method OWNER TO newowner template1=# I noticed another other issues too, like CREATE CONSTRAINT TRIGGER doesnt show up when you do \h CREATE<tab><tab> and when you do \h CREATE CON<tab><tab> you get CREATE CONVERSION instead. -- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match