From 39485bbdbadab26287e097474bb63acda4593abb Mon Sep 17 00:00:00 2001 From: Stephen Frost Date: Mon, 27 May 2013 11:12:54 -0400 Subject: [PATCH] Documentation fix for ALTER TYPE .. RENAME The documentation for ALTER TYPE .. RENAME claimed to support a RESTRICT/CASCADE option at the 'type' level, which wasn't implemented and doesn't make a whole lot of sense to begin with. What is supported, and previously undocumented, is ALTER TYPE .. RENAME ATTRIBUTE .. RESTRICT/CASCADE. I've updated the documentation and back-patched this to 9.1 where it was first introduced. --- doc/src/sgml/ref/alter_type.sgml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/doc/src/sgml/ref/alter_type.sgml b/doc/src/sgml/ref/alter_type.sgml index a81fe6c340..5ba3fd3bb5 100644 --- a/doc/src/sgml/ref/alter_type.sgml +++ b/doc/src/sgml/ref/alter_type.sgml @@ -25,8 +25,8 @@ PostgreSQL documentation ALTER TYPE name action [, ... ] ALTER TYPE name OWNER TO new_owner -ALTER TYPE name RENAME ATTRIBUTE attribute_name TO new_attribute_name -ALTER TYPE name RENAME TO new_name [ CASCADE | RESTRICT ] +ALTER TYPE name RENAME ATTRIBUTE attribute_name TO new_attribute_name [ CASCADE | RESTRICT ] +ALTER TYPE name RENAME TO new_name ALTER TYPE name SET SCHEMA new_schema ALTER TYPE name ADD VALUE new_enum_value [ { BEFORE | AFTER } existing_enum_value ] -- 2.40.0