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

Reply via email to