diff options
author | Bruce Momjian | 1998-03-31 04:44:35 +0000 |
---|---|---|
committer | Bruce Momjian | 1998-03-31 04:44:35 +0000 |
commit | d7050cb68cf996dd3c7ffc9bc5984c9b53ed9f77 (patch) | |
tree | 9ff0e0ea3229eb36d27f287ca59415c542427565 /src/man/rename.l | |
parent | 62943bb76fdb8e2283e2d01e2c81963578a50f62 (diff) |
Merge rename name page into alter table. Fix UNION with DISTINCT
or ORDER BY bug.
Diffstat (limited to 'src/man/rename.l')
-rw-r--r-- | src/man/rename.l | 63 |
1 files changed, 0 insertions, 63 deletions
diff --git a/src/man/rename.l b/src/man/rename.l deleted file mode 100644 index d756fa2399c..00000000000 --- a/src/man/rename.l +++ /dev/null @@ -1,63 +0,0 @@ -.\" This is -*-nroff-*- -.\" XXX standard disclaimer belongs here.... -.\" $Header: /cvsroot/pgsql/src/man/Attic/rename.l,v 1.3 1998/01/11 22:17:55 momjian Exp $ -.TH RENAME SQL 02/08/94 PostgreSQL PostgreSQL -.SH NAME -rename - 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. |