Here is a patch to add missing tab-completion for ALTER FOREIGN TABLE.
I'll add this to the next CF.

Best regards,
Etsuro Fujita
*** a/src/bin/psql/tab-complete.c
--- b/src/bin/psql/tab-complete.c
***************
*** 1128,1134 **** psql_completion(const char *text, int start, int end)
  			 pg_strcasecmp(prev2_wd, "TABLE") == 0)
  	{
  		static const char *const list_ALTER_FOREIGN_TABLE[] =
! 		{"ALTER", "DROP", "RENAME", "OWNER TO", "SET SCHEMA", NULL};
  
  		COMPLETE_WITH_LIST(list_ALTER_FOREIGN_TABLE);
  	}
--- 1128,1136 ----
  			 pg_strcasecmp(prev2_wd, "TABLE") == 0)
  	{
  		static const char *const list_ALTER_FOREIGN_TABLE[] =
! 		{"ADD", "ALTER", "DISABLE TRIGGER", "DROP", "ENABLE", "INHERIT",
! 		"NO INHERIT", "OPTIONS", "OWNER TO", "RENAME", "SET",
! 		"VALIDATE CONSTRAINT", NULL};
  
  		COMPLETE_WITH_LIST(list_ALTER_FOREIGN_TABLE);
  	}
-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to