aboutsummaryrefslogtreecommitdiff
path: root/doc/man/rename.l
diff options
context:
space:
mode:
Diffstat (limited to 'doc/man/rename.l')
-rw-r--r--doc/man/rename.l63
1 files changed, 0 insertions, 63 deletions
diff --git a/doc/man/rename.l b/doc/man/rename.l
deleted file mode 100644
index 0c1258d4723..00000000000
--- a/doc/man/rename.l
+++ /dev/null
@@ -1,63 +0,0 @@
-.\" This is -*-nroff-*-
-.\" XXX standard disclaimer belongs here....
-.\" $Header: /cvsroot/pgsql/doc/man/Attic/rename.l,v 1.1.1.1 1996/08/18 22:14:27 scrappy Exp $
-.TH RENAME SQL 02/08/94 Postgres95 Postgres95
-.SH NAME
-rename \(em rename a class or an attribute in a class
-.SH SYNOPSIS
-.nf
-\fBalter table\fR classname1
- \fBrename to\fR classname2
-\fBalter table\fR classname1 [\fB*\fR]
- \fBrename [column]\fR attname1 \fBto\fR attname2
-.fi
-.SH DESCRIPTION
-The
-.BR rename
-command
-causes the name of a class or attribute to change without changing any
-of the data contained in the affected class. Thus, the class or
-attribute will remain of the same type and size after this command is
-executed.
-.PP
-In order to rename an attribute in each class in an entire inheritance
-hierarchy, use the
-.IR classname
-of the superclass and append a \*(lq*\*(rq. (By default, the attribute
-will not be renamed in any of the subclasses.) This should
-.BR always
-be done when changing an attribute name in a superclass. If it is
-not, queries on the inheritance hierarchy such as
-.nf
-select * from super* s
-.fi
-will not work because the subclasses will be (in effect) missing an
-attribute found in the superclass.
-.PP
-You must own the class being modified in order to rename it or part of
-its schema. Renaming any part of the schema of a system catalog is
-not permitted.
-.SH EXAMPLE
-.nf
---
--- change the emp class to personnel
---
-alter table emp rename to personnel
-.fi
-.nf
---
--- change the sports attribute to hobbies
---
-alter table emp rename column sports to hobbies
-.fi
-.nf
---
--- make a change to an inherited attribute
---
-alter table person * rename column last_name to family_name
-.fi
-.SH BUGS
-Execution of historical queries using classes and attributes whose
-names have changed will produce incorrect results in many situations.
-.PP
-Renaming of types, operators, rules, etc., should also be supported.