diff options
Diffstat (limited to 'src/backend/commands/alter.c')
| -rw-r--r-- | src/backend/commands/alter.c | 159 |
1 files changed, 159 insertions, 0 deletions
diff --git a/src/backend/commands/alter.c b/src/backend/commands/alter.c new file mode 100644 index 0000000000..65b27f5def --- /dev/null +++ b/src/backend/commands/alter.c @@ -0,0 +1,159 @@ +/*------------------------------------------------------------------------- + * + * alter.c + * Drivers for generic alter commands + * + * Portions Copyright (c) 1996-2003, PostgreSQL Global Development Group + * Portions Copyright (c) 1994, Regents of the University of California + * + * + * IDENTIFICATION + * $Header: /cvsroot/pgsql/src/backend/commands/alter.c,v 1.1 2003/06/27 14:45:27 petere Exp $ + * + *------------------------------------------------------------------------- + */ +#include "postgres.h" + +#include "access/htup.h" +#include "catalog/catalog.h" +#include "catalog/namespace.h" +#include "catalog/pg_class.h" +#include "commands/alter.h" +#include "commands/conversioncmds.h" +#include "commands/dbcommands.h" +#include "commands/defrem.h" +#include "commands/proclang.h" +#include "commands/schemacmds.h" +#include "commands/tablecmds.h" +#include "commands/trigger.h" +#include "commands/user.h" +#include "miscadmin.h" +#include "parser/parse_clause.h" +#include "utils/acl.h" +#include "utils/lsyscache.h" +#include "utils/syscache.h" + + +static void +CheckOwnership(RangeVar *rel, bool noCatalogs) +{ + Oid relOid; + HeapTuple tuple; + + relOid = RangeVarGetRelid(rel, false); + tuple = SearchSysCache(RELOID, + ObjectIdGetDatum(relOid), + 0, 0, 0); + if (!HeapTupleIsValid(tuple)) + elog(ERROR, "Relation \"%s\" does not exist", rel->relname); + + if (!pg_class_ownercheck(relOid, GetUserId())) + aclcheck_error(ACLCHECK_NOT_OWNER, rel->relname); + + if (noCatalogs) + { + if (!allowSystemTableMods && + IsSystemClass((Form_pg_class) GETSTRUCT(tuple))) + elog(ERROR, "relation \"%s\" is a system catalog", + rel->relname); + } + + ReleaseSysCache(tuple); +} + + +void +ExecRenameStmt(RenameStmt *stmt) +{ + switch (stmt->renameType) + { + case OBJECT_AGGREGATE: + RenameAggregate(stmt->object, (TypeName *) lfirst(stmt->objarg), stmt->newname); + break; + + case OBJECT_CONVERSION: + RenameConversion(stmt->object, stmt->newname); + break; + + case OBJECT_DATABASE: + RenameDatabase(stmt->subname, stmt->newname); + break; + + case OBJECT_FUNCTION: + RenameFunction(stmt->object, stmt->objarg, stmt->newname); + break; + + case OBJECT_GROUP: + RenameGroup(stmt->subname, stmt->newname); + break; + + case OBJECT_LANGUAGE: + RenameLanguage(stmt->subname, stmt->newname); + break; + + case OBJECT_OPCLASS: + RenameOpClass(stmt->object, stmt->subname, stmt->newname); + break; + + case OBJECT_SCHEMA: + RenameSchema(stmt->subname, stmt->newname); + break; + + case OBJECT_USER: + RenameUser(stmt->subname, stmt->newname); + break; + + case OBJECT_TABLE: + case OBJECT_COLUMN: + case OBJECT_TRIGGER: + { + Oid relid; + + CheckOwnership(stmt->relation, true); + + relid = RangeVarGetRelid(stmt->relation, false); + + switch (stmt->renameType) + { + case OBJECT_TABLE: + { + /* + * RENAME TABLE requires that we (still) hold + * CREATE rights on the containing namespace, as + * well as ownership of the table. + */ + Oid namespaceId = get_rel_namespace(relid); + AclResult aclresult; + + aclresult = pg_namespace_aclcheck(namespaceId, + GetUserId(), + ACL_CREATE); + if (aclresult != ACLCHECK_OK) + aclcheck_error(aclresult, + get_namespace_name(namespaceId)); + + renamerel(relid, stmt->newname); + break; + } + case OBJECT_COLUMN: + renameatt(relid, + stmt->subname, /* old att name */ + stmt->newname, /* new att name */ + interpretInhOption(stmt->relation->inhOpt), /* recursive? */ + false); /* recursing already? */ + break; + case OBJECT_TRIGGER: + renametrig(relid, + stmt->subname, /* old att name */ + stmt->newname); /* new att name */ + break; + default: + /*can't happen*/; + } + break; + } + + default: + elog(ERROR, "invalid object type for RenameStmt: %d", stmt->renameType); + } +} |