typecmds.h File Reference

#include "access/htup.h"
#include "catalog/dependency.h"
#include "parser/parse_node.h"

Include dependency graph for typecmds.h:

This graph shows which files directly or indirectly include this file:

Go to the source code of this file.

Macros
#define	DEFAULT_TYPDELIM   ','

Functions
ObjectAddress	DefineType (ParseState *pstate, List *names, List *parameters)
void	RemoveTypeById (Oid typeOid)
ObjectAddress	DefineDomain (CreateDomainStmt *stmt)
ObjectAddress	DefineEnum (CreateEnumStmt *stmt)
ObjectAddress	DefineRange (ParseState *pstate, CreateRangeStmt *stmt)
ObjectAddress	AlterEnum (AlterEnumStmt *stmt)
ObjectAddress	DefineCompositeType (RangeVar *typevar, List *coldeflist)
Oid	AssignTypeArrayOid (void)
Oid	AssignTypeMultirangeOid (void)
Oid	AssignTypeMultirangeArrayOid (void)
ObjectAddress	AlterDomainDefault (List *names, Node *defaultRaw)
ObjectAddress	AlterDomainNotNull (List *names, bool notNull)
ObjectAddress	AlterDomainAddConstraint (List *names, Node *newConstraint, ObjectAddress *constrAddr)
ObjectAddress	AlterDomainValidateConstraint (List *names, const char *constrName)
ObjectAddress	AlterDomainDropConstraint (List *names, const char *constrName, DropBehavior behavior, bool missing_ok)
void	checkDomainOwner (HeapTuple tup)
ObjectAddress	RenameType (RenameStmt *stmt)
ObjectAddress	AlterTypeOwner (List *names, Oid newOwnerId, ObjectType objecttype)
void	AlterTypeOwner_oid (Oid typeOid, Oid newOwnerId, bool hasDependEntry)
void	AlterTypeOwnerInternal (Oid typeOid, Oid newOwnerId)
ObjectAddress	AlterTypeNamespace (List *names, const char *newschema, ObjectType objecttype, Oid *oldschema)
Oid	AlterTypeNamespace_oid (Oid typeOid, Oid nspOid, bool ignoreDependent, ObjectAddresses *objsMoved)
Oid	AlterTypeNamespaceInternal (Oid typeOid, Oid nspOid, bool isImplicitArray, bool ignoreDependent, bool errorOnTableType, ObjectAddresses *objsMoved)
ObjectAddress	AlterType (AlterTypeStmt *stmt)

Macro Definition Documentation

DEFAULT_TYPDELIM

#define DEFAULT_TYPDELIM   ','

Definition at line 22 of file typecmds.h.

Function Documentation

AlterDomainAddConstraint()

ObjectAddress AlterDomainAddConstraint	(	List *	names,
		Node *	newConstraint,
		ObjectAddress *	constrAddr
	)

Definition at line 2905 of file typecmds.c.

{
    TypeName   *typename;
    Oid         domainoid;
    Relation    typrel;
    HeapTuple   tup;
    Form_pg_type typTup;
    Constraint *constr;
    char       *ccbin;
    ObjectAddress address = InvalidObjectAddress;
 
    /* Make a TypeName so we can use standard type lookup machinery */
    typename = makeTypeNameFromNameList(names);
    domainoid = typenameTypeId(NULL, typename);
 
    /* Look up the domain in the type table */
    typrel = table_open(TypeRelationId, RowExclusiveLock);
 
    tup = SearchSysCacheCopy1(TYPEOID, ObjectIdGetDatum(domainoid));
    if (!HeapTupleIsValid(tup))
        elog(ERROR, "cache lookup failed for type %u", domainoid);
    typTup = (Form_pg_type) GETSTRUCT(tup);
 
    /* Check it's a domain and check user has permission for ALTER DOMAIN */
    checkDomainOwner(tup);
 
    if (!IsA(newConstraint, Constraint))
        elog(ERROR, "unrecognized node type: %d",
             (int) nodeTag(newConstraint));
 
    constr = (Constraint *) newConstraint;
 
    switch (constr->contype)
    {
        case CONSTR_CHECK:
        case CONSTR_NOTNULL:
            /* processed below */
            break;
 
        case CONSTR_UNIQUE:
            ereport(ERROR,
                    (errcode(ERRCODE_SYNTAX_ERROR),
                     errmsg("unique constraints not possible for domains")));
            break;
 
        case CONSTR_PRIMARY:
            ereport(ERROR,
                    (errcode(ERRCODE_SYNTAX_ERROR),
                     errmsg("primary key constraints not possible for domains")));
            break;
 
        case CONSTR_EXCLUSION:
            ereport(ERROR,
                    (errcode(ERRCODE_SYNTAX_ERROR),
                     errmsg("exclusion constraints not possible for domains")));
            break;
 
        case CONSTR_FOREIGN:
            ereport(ERROR,
                    (errcode(ERRCODE_SYNTAX_ERROR),
                     errmsg("foreign key constraints not possible for domains")));
            break;
 
        case CONSTR_ATTR_DEFERRABLE:
        case CONSTR_ATTR_NOT_DEFERRABLE:
        case CONSTR_ATTR_DEFERRED:
        case CONSTR_ATTR_IMMEDIATE:
            ereport(ERROR,
                    (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                     errmsg("specifying constraint deferrability not supported for domains")));
            break;
 
        default:
            elog(ERROR, "unrecognized constraint subtype: %d",
                 (int) constr->contype);
            break;
    }
 
    if (constr->contype == CONSTR_CHECK)
    {
        /*
         * First, process the constraint expression and add an entry to
         * pg_constraint.
         */
 
        ccbin = domainAddCheckConstraint(domainoid, typTup->typnamespace,
                                         typTup->typbasetype, typTup->typtypmod,
                                         constr, NameStr(typTup->typname), constrAddr);
 
 
        /*
         * If requested to validate the constraint, test all values stored in
         * the attributes based on the domain the constraint is being added
         * to.
         */
        if (!constr->skip_validation)
            validateDomainCheckConstraint(domainoid, ccbin);
 
        /*
         * We must send out an sinval message for the domain, to ensure that
         * any dependent plans get rebuilt.  Since this command doesn't change
         * the domain's pg_type row, that won't happen automatically; do it
         * manually.
         */
        CacheInvalidateHeapTuple(typrel, tup, NULL);
    }
    else if (constr->contype == CONSTR_NOTNULL)
    {
        /* Is the domain already set NOT NULL? */
        if (typTup->typnotnull)
        {
            table_close(typrel, RowExclusiveLock);
            return address;
        }
        domainAddNotNullConstraint(domainoid, typTup->typnamespace,
                                   typTup->typbasetype, typTup->typtypmod,
                                   constr, NameStr(typTup->typname), constrAddr);
 
        if (!constr->skip_validation)
            validateDomainNotNullConstraint(domainoid);
 
        typTup->typnotnull = true;
        CatalogTupleUpdate(typrel, &tup->t_self, tup);
    }
 
    ObjectAddressSet(address, TypeRelationId, domainoid);
 
    /* Clean up */
    table_close(typrel, RowExclusiveLock);
 
    return address;
}

References CacheInvalidateHeapTuple(), CatalogTupleUpdate(), checkDomainOwner(), CONSTR_ATTR_DEFERRABLE, CONSTR_ATTR_DEFERRED, CONSTR_ATTR_IMMEDIATE, CONSTR_ATTR_NOT_DEFERRABLE, CONSTR_CHECK, CONSTR_EXCLUSION, CONSTR_FOREIGN, CONSTR_NOTNULL, CONSTR_PRIMARY, CONSTR_UNIQUE, Constraint::contype, domainAddCheckConstraint(), domainAddNotNullConstraint(), elog, ereport, errcode(), errmsg(), ERROR, GETSTRUCT, HeapTupleIsValid, InvalidObjectAddress, IsA, makeTypeNameFromNameList(), NameStr, nodeTag, ObjectAddressSet, ObjectIdGetDatum(), RowExclusiveLock, SearchSysCacheCopy1, Constraint::skip_validation, HeapTupleData::t_self, table_close(), table_open(), typenameTypeId(), validateDomainCheckConstraint(), and validateDomainNotNullConstraint().

Referenced by ATExecCmd(), and ProcessUtilitySlow().

AlterDomainDefault()

ObjectAddress AlterDomainDefault	(	List *	names,
		Node *	defaultRaw
	)

Definition at line 2584 of file typecmds.c.

{
    TypeName   *typename;
    Oid         domainoid;
    HeapTuple   tup;
    ParseState *pstate;
    Relation    rel;
    char       *defaultValue;
    Node       *defaultExpr = NULL; /* NULL if no default specified */
    Datum       new_record[Natts_pg_type] = {0};
    bool        new_record_nulls[Natts_pg_type] = {0};
    bool        new_record_repl[Natts_pg_type] = {0};
    HeapTuple   newtuple;
    Form_pg_type typTup;
    ObjectAddress address;
 
    /* Make a TypeName so we can use standard type lookup machinery */
    typename = makeTypeNameFromNameList(names);
    domainoid = typenameTypeId(NULL, typename);
 
    /* Look up the domain in the type table */
    rel = table_open(TypeRelationId, RowExclusiveLock);
 
    tup = SearchSysCacheCopy1(TYPEOID, ObjectIdGetDatum(domainoid));
    if (!HeapTupleIsValid(tup))
        elog(ERROR, "cache lookup failed for type %u", domainoid);
    typTup = (Form_pg_type) GETSTRUCT(tup);
 
    /* Check it's a domain and check user has permission for ALTER DOMAIN */
    checkDomainOwner(tup);
 
    /* Setup new tuple */
 
    /* Store the new default into the tuple */
    if (defaultRaw)
    {
        /* Create a dummy ParseState for transformExpr */
        pstate = make_parsestate(NULL);
 
        /*
         * Cook the colDef->raw_expr into an expression. Note: Name is
         * strictly for error message
         */
        defaultExpr = cookDefault(pstate, defaultRaw,
                                  typTup->typbasetype,
                                  typTup->typtypmod,
                                  NameStr(typTup->typname),
                                  0);
 
        /*
         * If the expression is just a NULL constant, we treat the command
         * like ALTER ... DROP DEFAULT.  (But see note for same test in
         * DefineDomain.)
         */
        if (defaultExpr == NULL ||
            (IsA(defaultExpr, Const) && ((Const *) defaultExpr)->constisnull))
        {
            /* Default is NULL, drop it */
            defaultExpr = NULL;
            new_record_nulls[Anum_pg_type_typdefaultbin - 1] = true;
            new_record_repl[Anum_pg_type_typdefaultbin - 1] = true;
            new_record_nulls[Anum_pg_type_typdefault - 1] = true;
            new_record_repl[Anum_pg_type_typdefault - 1] = true;
        }
        else
        {
            /*
             * Expression must be stored as a nodeToString result, but we also
             * require a valid textual representation (mainly to make life
             * easier for pg_dump).
             */
            defaultValue = deparse_expression(defaultExpr,
                                              NIL, false, false);
 
            /*
             * Form an updated tuple with the new default and write it back.
             */
            new_record[Anum_pg_type_typdefaultbin - 1] = CStringGetTextDatum(nodeToString(defaultExpr));
 
            new_record_repl[Anum_pg_type_typdefaultbin - 1] = true;
            new_record[Anum_pg_type_typdefault - 1] = CStringGetTextDatum(defaultValue);
            new_record_repl[Anum_pg_type_typdefault - 1] = true;
        }
    }
    else
    {
        /* ALTER ... DROP DEFAULT */
        new_record_nulls[Anum_pg_type_typdefaultbin - 1] = true;
        new_record_repl[Anum_pg_type_typdefaultbin - 1] = true;
        new_record_nulls[Anum_pg_type_typdefault - 1] = true;
        new_record_repl[Anum_pg_type_typdefault - 1] = true;
    }
 
    newtuple = heap_modify_tuple(tup, RelationGetDescr(rel),
                                 new_record, new_record_nulls,
                                 new_record_repl);
 
    CatalogTupleUpdate(rel, &tup->t_self, newtuple);
 
    /* Rebuild dependencies */
    GenerateTypeDependencies(newtuple,
                             rel,
                             defaultExpr,
                             NULL,  /* don't have typacl handy */
                             0, /* relation kind is n/a */
                             false, /* a domain isn't an implicit array */
                             false, /* nor is it any kind of dependent type */
                             false, /* don't touch extension membership */
                             true); /* We do need to rebuild dependencies */
 
    InvokeObjectPostAlterHook(TypeRelationId, domainoid, 0);
 
    ObjectAddressSet(address, TypeRelationId, domainoid);
 
    /* Clean up */
    table_close(rel, RowExclusiveLock);
    heap_freetuple(newtuple);
 
    return address;
}

References CatalogTupleUpdate(), checkDomainOwner(), cookDefault(), CStringGetTextDatum, deparse_expression(), elog, ERROR, GenerateTypeDependencies(), GETSTRUCT, heap_freetuple(), heap_modify_tuple(), HeapTupleIsValid, InvokeObjectPostAlterHook, IsA, make_parsestate(), makeTypeNameFromNameList(), NameStr, NIL, nodeToString(), ObjectAddressSet, ObjectIdGetDatum(), RelationGetDescr, RowExclusiveLock, SearchSysCacheCopy1, HeapTupleData::t_self, table_close(), table_open(), and typenameTypeId().

Referenced by ProcessUtilitySlow().

AlterDomainDropConstraint()

ObjectAddress AlterDomainDropConstraint	(	List *	names,
		const char *	constrName,
		DropBehavior	behavior,
		bool	missing_ok
	)

Definition at line 2799 of file typecmds.c.

{
    TypeName   *typename;
    Oid         domainoid;
    HeapTuple   tup;
    Relation    rel;
    Relation    conrel;
    SysScanDesc conscan;
    ScanKeyData skey[3];
    HeapTuple   contup;
    bool        found = false;
    ObjectAddress address;
 
    /* Make a TypeName so we can use standard type lookup machinery */
    typename = makeTypeNameFromNameList(names);
    domainoid = typenameTypeId(NULL, typename);
 
    /* Look up the domain in the type table */
    rel = table_open(TypeRelationId, RowExclusiveLock);
 
    tup = SearchSysCacheCopy1(TYPEOID, ObjectIdGetDatum(domainoid));
    if (!HeapTupleIsValid(tup))
        elog(ERROR, "cache lookup failed for type %u", domainoid);
 
    /* Check it's a domain and check user has permission for ALTER DOMAIN */
    checkDomainOwner(tup);
 
    /* Grab an appropriate lock on the pg_constraint relation */
    conrel = table_open(ConstraintRelationId, RowExclusiveLock);
 
    /* Find and remove the target constraint */
    ScanKeyInit(&skey[0],
                Anum_pg_constraint_conrelid,
                BTEqualStrategyNumber, F_OIDEQ,
                ObjectIdGetDatum(InvalidOid));
    ScanKeyInit(&skey[1],
                Anum_pg_constraint_contypid,
                BTEqualStrategyNumber, F_OIDEQ,
                ObjectIdGetDatum(domainoid));
    ScanKeyInit(&skey[2],
                Anum_pg_constraint_conname,
                BTEqualStrategyNumber, F_NAMEEQ,
                CStringGetDatum(constrName));
 
    conscan = systable_beginscan(conrel, ConstraintRelidTypidNameIndexId, true,
                                 NULL, 3, skey);
 
    /* There can be at most one matching row */
    if ((contup = systable_getnext(conscan)) != NULL)
    {
        Form_pg_constraint construct = (Form_pg_constraint) GETSTRUCT(contup);
        ObjectAddress conobj;
 
        if (construct->contype == CONSTRAINT_NOTNULL)
        {
            ((Form_pg_type) GETSTRUCT(tup))->typnotnull = false;
            CatalogTupleUpdate(rel, &tup->t_self, tup);
        }
 
        conobj.classId = ConstraintRelationId;
        conobj.objectId = construct->oid;
        conobj.objectSubId = 0;
 
        performDeletion(&conobj, behavior, 0);
        found = true;
    }
 
    /* Clean up after the scan */
    systable_endscan(conscan);
    table_close(conrel, RowExclusiveLock);
 
    if (!found)
    {
        if (!missing_ok)
            ereport(ERROR,
                    (errcode(ERRCODE_UNDEFINED_OBJECT),
                     errmsg("constraint \"%s\" of domain \"%s\" does not exist",
                            constrName, TypeNameToString(typename))));
        else
            ereport(NOTICE,
                    (errmsg("constraint \"%s\" of domain \"%s\" does not exist, skipping",
                            constrName, TypeNameToString(typename))));
    }
 
    /*
     * We must send out an sinval message for the domain, to ensure that any
     * dependent plans get rebuilt.  Since this command doesn't change the
     * domain's pg_type row, that won't happen automatically; do it manually.
     */
    CacheInvalidateHeapTuple(rel, tup, NULL);
 
    ObjectAddressSet(address, TypeRelationId, domainoid);
 
    /* Clean up */
    table_close(rel, RowExclusiveLock);
 
    return address;
}

References BTEqualStrategyNumber, CacheInvalidateHeapTuple(), CatalogTupleUpdate(), checkDomainOwner(), ObjectAddress::classId, CStringGetDatum(), elog, ereport, errcode(), errmsg(), ERROR, GETSTRUCT, HeapTupleIsValid, InvalidOid, makeTypeNameFromNameList(), NOTICE, ObjectAddressSet, ObjectAddress::objectId, ObjectIdGetDatum(), ObjectAddress::objectSubId, performDeletion(), RowExclusiveLock, ScanKeyInit(), SearchSysCacheCopy1, systable_beginscan(), systable_endscan(), systable_getnext(), HeapTupleData::t_self, table_close(), table_open(), TypeNameToString(), and typenameTypeId().

Referenced by ProcessUtilitySlow().

AlterDomainNotNull()

ObjectAddress AlterDomainNotNull	(	List *	names,
		bool	notNull
	)

Definition at line 2713 of file typecmds.c.

{
    TypeName   *typename;
    Oid         domainoid;
    Relation    typrel;
    HeapTuple   tup;
    Form_pg_type typTup;
    ObjectAddress address = InvalidObjectAddress;
 
    /* Make a TypeName so we can use standard type lookup machinery */
    typename = makeTypeNameFromNameList(names);
    domainoid = typenameTypeId(NULL, typename);
 
    /* Look up the domain in the type table */
    typrel = table_open(TypeRelationId, RowExclusiveLock);
 
    tup = SearchSysCacheCopy1(TYPEOID, ObjectIdGetDatum(domainoid));
    if (!HeapTupleIsValid(tup))
        elog(ERROR, "cache lookup failed for type %u", domainoid);
    typTup = (Form_pg_type) GETSTRUCT(tup);
 
    /* Check it's a domain and check user has permission for ALTER DOMAIN */
    checkDomainOwner(tup);
 
    /* Is the domain already set to the desired constraint? */
    if (typTup->typnotnull == notNull)
    {
        table_close(typrel, RowExclusiveLock);
        return address;
    }
 
    if (notNull)
    {
        Constraint *constr;
 
        constr = makeNode(Constraint);
        constr->contype = CONSTR_NOTNULL;
        constr->initially_valid = true;
        constr->location = -1;
 
        domainAddNotNullConstraint(domainoid, typTup->typnamespace,
                                   typTup->typbasetype, typTup->typtypmod,
                                   constr, NameStr(typTup->typname), NULL);
 
        validateDomainNotNullConstraint(domainoid);
    }
    else
    {
        HeapTuple   conTup;
        ObjectAddress conobj;
 
        conTup = findDomainNotNullConstraint(domainoid);
        if (conTup == NULL)
            elog(ERROR, "could not find not-null constraint on domain \"%s\"", NameStr(typTup->typname));
 
        ObjectAddressSet(conobj, ConstraintRelationId, ((Form_pg_constraint) GETSTRUCT(conTup))->oid);
        performDeletion(&conobj, DROP_RESTRICT, 0);
    }
 
    /*
     * Okay to update pg_type row.  We can scribble on typTup because it's a
     * copy.
     */
    typTup->typnotnull = notNull;
 
    CatalogTupleUpdate(typrel, &tup->t_self, tup);
 
    InvokeObjectPostAlterHook(TypeRelationId, domainoid, 0);
 
    ObjectAddressSet(address, TypeRelationId, domainoid);
 
    /* Clean up */
    heap_freetuple(tup);
    table_close(typrel, RowExclusiveLock);
 
    return address;
}

References CatalogTupleUpdate(), checkDomainOwner(), CONSTR_NOTNULL, Constraint::contype, domainAddNotNullConstraint(), DROP_RESTRICT, elog, ERROR, findDomainNotNullConstraint(), GETSTRUCT, heap_freetuple(), HeapTupleIsValid, Constraint::initially_valid, InvalidObjectAddress, InvokeObjectPostAlterHook, Constraint::location, makeNode, makeTypeNameFromNameList(), NameStr, ObjectAddressSet, ObjectIdGetDatum(), performDeletion(), RowExclusiveLock, SearchSysCacheCopy1, HeapTupleData::t_self, table_close(), table_open(), typenameTypeId(), and validateDomainNotNullConstraint().

Referenced by ProcessUtilitySlow().

AlterDomainValidateConstraint()

ObjectAddress AlterDomainValidateConstraint	(	List *	names,
		const char *	constrName
	)

Definition at line 3045 of file typecmds.c.

{
    TypeName   *typename;
    Oid         domainoid;
    Relation    typrel;
    Relation    conrel;
    HeapTuple   tup;
    Form_pg_constraint con;
    Form_pg_constraint copy_con;
    char       *conbin;
    SysScanDesc scan;
    Datum       val;
    HeapTuple   tuple;
    HeapTuple   copyTuple;
    ScanKeyData skey[3];
    ObjectAddress address;
 
    /* Make a TypeName so we can use standard type lookup machinery */
    typename = makeTypeNameFromNameList(names);
    domainoid = typenameTypeId(NULL, typename);
 
    /* Look up the domain in the type table */
    typrel = table_open(TypeRelationId, AccessShareLock);
 
    tup = SearchSysCache1(TYPEOID, ObjectIdGetDatum(domainoid));
    if (!HeapTupleIsValid(tup))
        elog(ERROR, "cache lookup failed for type %u", domainoid);
 
    /* Check it's a domain and check user has permission for ALTER DOMAIN */
    checkDomainOwner(tup);
 
    /*
     * Find and check the target constraint
     */
    conrel = table_open(ConstraintRelationId, RowExclusiveLock);
 
    ScanKeyInit(&skey[0],
                Anum_pg_constraint_conrelid,
                BTEqualStrategyNumber, F_OIDEQ,
                ObjectIdGetDatum(InvalidOid));
    ScanKeyInit(&skey[1],
                Anum_pg_constraint_contypid,
                BTEqualStrategyNumber, F_OIDEQ,
                ObjectIdGetDatum(domainoid));
    ScanKeyInit(&skey[2],
                Anum_pg_constraint_conname,
                BTEqualStrategyNumber, F_NAMEEQ,
                CStringGetDatum(constrName));
 
    scan = systable_beginscan(conrel, ConstraintRelidTypidNameIndexId, true,
                              NULL, 3, skey);
 
    /* There can be at most one matching row */
    if (!HeapTupleIsValid(tuple = systable_getnext(scan)))
        ereport(ERROR,
                (errcode(ERRCODE_UNDEFINED_OBJECT),
                 errmsg("constraint \"%s\" of domain \"%s\" does not exist",
                        constrName, TypeNameToString(typename))));
 
    con = (Form_pg_constraint) GETSTRUCT(tuple);
    if (con->contype != CONSTRAINT_CHECK)
        ereport(ERROR,
                (errcode(ERRCODE_WRONG_OBJECT_TYPE),
                 errmsg("constraint \"%s\" of domain \"%s\" is not a check constraint",
                        constrName, TypeNameToString(typename))));
 
    val = SysCacheGetAttrNotNull(CONSTROID, tuple, Anum_pg_constraint_conbin);
    conbin = TextDatumGetCString(val);
 
    validateDomainCheckConstraint(domainoid, conbin);
 
    /*
     * Now update the catalog, while we have the door open.
     */
    copyTuple = heap_copytuple(tuple);
    copy_con = (Form_pg_constraint) GETSTRUCT(copyTuple);
    copy_con->convalidated = true;
    CatalogTupleUpdate(conrel, &copyTuple->t_self, copyTuple);
 
    InvokeObjectPostAlterHook(ConstraintRelationId, con->oid, 0);
 
    ObjectAddressSet(address, TypeRelationId, domainoid);
 
    heap_freetuple(copyTuple);
 
    systable_endscan(scan);
 
    table_close(typrel, AccessShareLock);
    table_close(conrel, RowExclusiveLock);
 
    ReleaseSysCache(tup);
 
    return address;
}

References AccessShareLock, BTEqualStrategyNumber, CatalogTupleUpdate(), checkDomainOwner(), CStringGetDatum(), elog, ereport, errcode(), errmsg(), ERROR, GETSTRUCT, heap_copytuple(), heap_freetuple(), HeapTupleIsValid, InvalidOid, InvokeObjectPostAlterHook, makeTypeNameFromNameList(), ObjectAddressSet, ObjectIdGetDatum(), ReleaseSysCache(), RowExclusiveLock, ScanKeyInit(), SearchSysCache1(), SysCacheGetAttrNotNull(), systable_beginscan(), systable_endscan(), systable_getnext(), HeapTupleData::t_self, table_close(), table_open(), TextDatumGetCString, TypeNameToString(), typenameTypeId(), val, and validateDomainCheckConstraint().

Referenced by ProcessUtilitySlow().

AlterEnum()

ObjectAddress AlterEnum

(

AlterEnumStmt *

stmt

)

Definition at line 1279 of file typecmds.c.

{
    Oid         enum_type_oid;
    TypeName   *typename;
    HeapTuple   tup;
    ObjectAddress address;
 
    /* Make a TypeName so we can use standard type lookup machinery */
    typename = makeTypeNameFromNameList(stmt->typeName);
    enum_type_oid = typenameTypeId(NULL, typename);
 
    tup = SearchSysCache1(TYPEOID, ObjectIdGetDatum(enum_type_oid));
    if (!HeapTupleIsValid(tup))
        elog(ERROR, "cache lookup failed for type %u", enum_type_oid);
 
    /* Check it's an enum and check user has permission to ALTER the enum */
    checkEnumOwner(tup);
 
    ReleaseSysCache(tup);
 
    if (stmt->oldVal)
    {
        /* Rename an existing label */
        RenameEnumLabel(enum_type_oid, stmt->oldVal, stmt->newVal);
    }
    else
    {
        /* Add a new label */
        AddEnumLabel(enum_type_oid, stmt->newVal,
                     stmt->newValNeighbor, stmt->newValIsAfter,
                     stmt->skipIfNewValExists);
    }
 
    InvokeObjectPostAlterHook(TypeRelationId, enum_type_oid, 0);
 
    ObjectAddressSet(address, TypeRelationId, enum_type_oid);
 
    return address;
}

References AddEnumLabel(), checkEnumOwner(), elog, ERROR, HeapTupleIsValid, InvokeObjectPostAlterHook, makeTypeNameFromNameList(), ObjectAddressSet, ObjectIdGetDatum(), ReleaseSysCache(), RenameEnumLabel(), SearchSysCache1(), stmt, and typenameTypeId().

Referenced by ProcessUtilitySlow().

AlterType()

ObjectAddress AlterType

(

AlterTypeStmt *

stmt

)

Definition at line 4322 of file typecmds.c.

{
    ObjectAddress address;
    Relation    catalog;
    TypeName   *typename;
    HeapTuple   tup;
    Oid         typeOid;
    Form_pg_type typForm;
    bool        requireSuper = false;
    AlterTypeRecurseParams atparams;
    ListCell   *pl;
 
    catalog = table_open(TypeRelationId, RowExclusiveLock);
 
    /* Make a TypeName so we can use standard type lookup machinery */
    typename = makeTypeNameFromNameList(stmt->typeName);
    tup = typenameType(NULL, typename, NULL);
 
    typeOid = typeTypeId(tup);
    typForm = (Form_pg_type) GETSTRUCT(tup);
 
    /* Process options */
    memset(&atparams, 0, sizeof(atparams));
    foreach(pl, stmt->options)
    {
        DefElem    *defel = (DefElem *) lfirst(pl);
 
        if (strcmp(defel->defname, "storage") == 0)
        {
            char       *a = defGetString(defel);
 
            if (pg_strcasecmp(a, "plain") == 0)
                atparams.storage = TYPSTORAGE_PLAIN;
            else if (pg_strcasecmp(a, "external") == 0)
                atparams.storage = TYPSTORAGE_EXTERNAL;
            else if (pg_strcasecmp(a, "extended") == 0)
                atparams.storage = TYPSTORAGE_EXTENDED;
            else if (pg_strcasecmp(a, "main") == 0)
                atparams.storage = TYPSTORAGE_MAIN;
            else
                ereport(ERROR,
                        (errcode(ERRCODE_INVALID_PARAMETER_VALUE),
                         errmsg("storage \"%s\" not recognized", a)));
 
            /*
             * Validate the storage request.  If the type isn't varlena, it
             * certainly doesn't support non-PLAIN storage.
             */
            if (atparams.storage != TYPSTORAGE_PLAIN && typForm->typlen != -1)
                ereport(ERROR,
                        (errcode(ERRCODE_INVALID_OBJECT_DEFINITION),
                         errmsg("fixed-size types must have storage PLAIN")));
 
            /*
             * Switching from PLAIN to non-PLAIN is allowed, but it requires
             * superuser, since we can't validate that the type's C functions
             * will support it.  Switching from non-PLAIN to PLAIN is
             * disallowed outright, because it's not practical to ensure that
             * no tables have toasted values of the type.  Switching among
             * different non-PLAIN settings is OK, since it just constitutes a
             * change in the strategy requested for columns created in the
             * future.
             */
            if (atparams.storage != TYPSTORAGE_PLAIN &&
                typForm->typstorage == TYPSTORAGE_PLAIN)
                requireSuper = true;
            else if (atparams.storage == TYPSTORAGE_PLAIN &&
                     typForm->typstorage != TYPSTORAGE_PLAIN)
                ereport(ERROR,
                        (errcode(ERRCODE_INVALID_OBJECT_DEFINITION),
                         errmsg("cannot change type's storage to PLAIN")));
 
            atparams.updateStorage = true;
        }
        else if (strcmp(defel->defname, "receive") == 0)
        {
            if (defel->arg != NULL)
                atparams.receiveOid =
                    findTypeReceiveFunction(defGetQualifiedName(defel),
                                            typeOid);
            else
                atparams.receiveOid = InvalidOid;   /* NONE, remove function */
            atparams.updateReceive = true;
            /* Replacing an I/O function requires superuser. */
            requireSuper = true;
        }
        else if (strcmp(defel->defname, "send") == 0)
        {
            if (defel->arg != NULL)
                atparams.sendOid =
                    findTypeSendFunction(defGetQualifiedName(defel),
                                         typeOid);
            else
                atparams.sendOid = InvalidOid;  /* NONE, remove function */
            atparams.updateSend = true;
            /* Replacing an I/O function requires superuser. */
            requireSuper = true;
        }
        else if (strcmp(defel->defname, "typmod_in") == 0)
        {
            if (defel->arg != NULL)
                atparams.typmodinOid =
                    findTypeTypmodinFunction(defGetQualifiedName(defel));
            else
                atparams.typmodinOid = InvalidOid;  /* NONE, remove function */
            atparams.updateTypmodin = true;
            /* Replacing an I/O function requires superuser. */
            requireSuper = true;
        }
        else if (strcmp(defel->defname, "typmod_out") == 0)
        {
            if (defel->arg != NULL)
                atparams.typmodoutOid =
                    findTypeTypmodoutFunction(defGetQualifiedName(defel));
            else
                atparams.typmodoutOid = InvalidOid; /* NONE, remove function */
            atparams.updateTypmodout = true;
            /* Replacing an I/O function requires superuser. */
            requireSuper = true;
        }
        else if (strcmp(defel->defname, "analyze") == 0)
        {
            if (defel->arg != NULL)
                atparams.analyzeOid =
                    findTypeAnalyzeFunction(defGetQualifiedName(defel),
                                            typeOid);
            else
                atparams.analyzeOid = InvalidOid;   /* NONE, remove function */
            atparams.updateAnalyze = true;
            /* Replacing an analyze function requires superuser. */
            requireSuper = true;
        }
        else if (strcmp(defel->defname, "subscript") == 0)
        {
            if (defel->arg != NULL)
                atparams.subscriptOid =
                    findTypeSubscriptingFunction(defGetQualifiedName(defel),
                                                 typeOid);
            else
                atparams.subscriptOid = InvalidOid; /* NONE, remove function */
            atparams.updateSubscript = true;
            /* Replacing a subscript function requires superuser. */
            requireSuper = true;
        }
 
        /*
         * The rest of the options that CREATE accepts cannot be changed.
         * Check for them so that we can give a meaningful error message.
         */
        else if (strcmp(defel->defname, "input") == 0 ||
                 strcmp(defel->defname, "output") == 0 ||
                 strcmp(defel->defname, "internallength") == 0 ||
                 strcmp(defel->defname, "passedbyvalue") == 0 ||
                 strcmp(defel->defname, "alignment") == 0 ||
                 strcmp(defel->defname, "like") == 0 ||
                 strcmp(defel->defname, "category") == 0 ||
                 strcmp(defel->defname, "preferred") == 0 ||
                 strcmp(defel->defname, "default") == 0 ||
                 strcmp(defel->defname, "element") == 0 ||
                 strcmp(defel->defname, "delimiter") == 0 ||
                 strcmp(defel->defname, "collatable") == 0)
            ereport(ERROR,
                    (errcode(ERRCODE_SYNTAX_ERROR),
                     errmsg("type attribute \"%s\" cannot be changed",
                            defel->defname)));
        else
            ereport(ERROR,
                    (errcode(ERRCODE_SYNTAX_ERROR),
                     errmsg("type attribute \"%s\" not recognized",
                            defel->defname)));
    }
 
    /*
     * Permissions check.  Require superuser if we decided the command
     * requires that, else must own the type.
     */
    if (requireSuper)
    {
        if (!superuser())
            ereport(ERROR,
                    (errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
                     errmsg("must be superuser to alter a type")));
    }
    else
    {
        if (!object_ownercheck(TypeRelationId, typeOid, GetUserId()))
            aclcheck_error_type(ACLCHECK_NOT_OWNER, typeOid);
    }
 
    /*
     * We disallow all forms of ALTER TYPE SET on types that aren't plain base
     * types.  It would for example be highly unsafe, not to mention
     * pointless, to change the send/receive functions for a composite type.
     * Moreover, pg_dump has no support for changing these properties on
     * non-base types.  We might weaken this someday, but not now.
     *
     * Note: if you weaken this enough to allow composite types, be sure to
     * adjust the GenerateTypeDependencies call in AlterTypeRecurse.
     */
    if (typForm->typtype != TYPTYPE_BASE)
        ereport(ERROR,
                (errcode(ERRCODE_WRONG_OBJECT_TYPE),
                 errmsg("%s is not a base type",
                        format_type_be(typeOid))));
 
    /*
     * For the same reasons, don't allow direct alteration of array types.
     */
    if (IsTrueArrayType(typForm))
        ereport(ERROR,
                (errcode(ERRCODE_WRONG_OBJECT_TYPE),
                 errmsg("%s is not a base type",
                        format_type_be(typeOid))));
 
    /* OK, recursively update this type and any arrays/domains over it */
    AlterTypeRecurse(typeOid, false, tup, catalog, &atparams);
 
    /* Clean up */
    ReleaseSysCache(tup);
 
    table_close(catalog, RowExclusiveLock);
 
    ObjectAddressSet(address, TypeRelationId, typeOid);
 
    return address;
}

References a, aclcheck_error_type(), ACLCHECK_NOT_OWNER, AlterTypeRecurse(), AlterTypeRecurseParams::analyzeOid, DefElem::arg, defGetQualifiedName(), defGetString(), DefElem::defname, ereport, errcode(), errmsg(), ERROR, findTypeAnalyzeFunction(), findTypeReceiveFunction(), findTypeSendFunction(), findTypeSubscriptingFunction(), findTypeTypmodinFunction(), findTypeTypmodoutFunction(), format_type_be(), GETSTRUCT, GetUserId(), InvalidOid, lfirst, makeTypeNameFromNameList(), object_ownercheck(), ObjectAddressSet, pg_strcasecmp(), AlterTypeRecurseParams::receiveOid, ReleaseSysCache(), RowExclusiveLock, AlterTypeRecurseParams::sendOid, stmt, AlterTypeRecurseParams::storage, AlterTypeRecurseParams::subscriptOid, superuser(), table_close(), table_open(), typenameType(), typeTypeId(), AlterTypeRecurseParams::typmodinOid, AlterTypeRecurseParams::typmodoutOid, AlterTypeRecurseParams::updateAnalyze, AlterTypeRecurseParams::updateReceive, AlterTypeRecurseParams::updateSend, AlterTypeRecurseParams::updateStorage, AlterTypeRecurseParams::updateSubscript, AlterTypeRecurseParams::updateTypmodin, and AlterTypeRecurseParams::updateTypmodout.

Referenced by ProcessUtilitySlow().

AlterTypeNamespace()

ObjectAddress AlterTypeNamespace	(	List *	names,
		const char *	newschema,
		ObjectType	objecttype,
		Oid *	oldschema
	)

Definition at line 4065 of file typecmds.c.

{
    TypeName   *typename;
    Oid         typeOid;
    Oid         nspOid;
    Oid         oldNspOid;
    ObjectAddresses *objsMoved;
    ObjectAddress myself;
 
    /* Make a TypeName so we can use standard type lookup machinery */
    typename = makeTypeNameFromNameList(names);
    typeOid = typenameTypeId(NULL, typename);
 
    /* Don't allow ALTER DOMAIN on a non-domain type */
    if (objecttype == OBJECT_DOMAIN && get_typtype(typeOid) != TYPTYPE_DOMAIN)
        ereport(ERROR,
                (errcode(ERRCODE_WRONG_OBJECT_TYPE),
                 errmsg("%s is not a domain",
                        format_type_be(typeOid))));
 
    /* get schema OID and check its permissions */
    nspOid = LookupCreationNamespace(newschema);
 
    objsMoved = new_object_addresses();
    oldNspOid = AlterTypeNamespace_oid(typeOid, nspOid, false, objsMoved);
    free_object_addresses(objsMoved);
 
    if (oldschema)
        *oldschema = oldNspOid;
 
    ObjectAddressSet(myself, TypeRelationId, typeOid);
 
    return myself;
}

References AlterTypeNamespace_oid(), ereport, errcode(), errmsg(), ERROR, format_type_be(), free_object_addresses(), get_typtype(), LookupCreationNamespace(), makeTypeNameFromNameList(), new_object_addresses(), OBJECT_DOMAIN, ObjectAddressSet, and typenameTypeId().

Referenced by ExecAlterObjectSchemaStmt().

AlterTypeNamespace_oid()

Oid AlterTypeNamespace_oid	(	Oid	typeOid,
		Oid	nspOid,
		bool	ignoreDependent,
		ObjectAddresses *	objsMoved
	)

Definition at line 4114 of file typecmds.c.

{
    Oid         elemOid;
 
    /* check permissions on type */
    if (!object_ownercheck(TypeRelationId, typeOid, GetUserId()))
        aclcheck_error_type(ACLCHECK_NOT_OWNER, typeOid);
 
    /* don't allow direct alteration of array types */
    elemOid = get_element_type(typeOid);
    if (OidIsValid(elemOid) && get_array_type(elemOid) == typeOid)
    {
        if (ignoreDependent)
            return InvalidOid;
        ereport(ERROR,
                (errcode(ERRCODE_WRONG_OBJECT_TYPE),
                 errmsg("cannot alter array type %s",
                        format_type_be(typeOid)),
                 errhint("You can alter type %s, which will alter the array type as well.",
                         format_type_be(elemOid))));
    }
 
    /* and do the work */
    return AlterTypeNamespaceInternal(typeOid, nspOid,
                                      false,    /* isImplicitArray */
                                      ignoreDependent,  /* ignoreDependent */
                                      true, /* errorOnTableType */
                                      objsMoved);
}

References aclcheck_error_type(), ACLCHECK_NOT_OWNER, AlterTypeNamespaceInternal(), ereport, errcode(), errhint(), errmsg(), ERROR, format_type_be(), get_array_type(), get_element_type(), GetUserId(), InvalidOid, object_ownercheck(), and OidIsValid.

Referenced by AlterObjectNamespace_oid(), and AlterTypeNamespace().

AlterTypeNamespaceInternal()

Oid AlterTypeNamespaceInternal	(	Oid	typeOid,
		Oid	nspOid,
		bool	isImplicitArray,
		bool	ignoreDependent,
		bool	errorOnTableType,
		ObjectAddresses *	objsMoved
	)

Definition at line 4166 of file typecmds.c.

{
    Relation    rel;
    HeapTuple   tup;
    Form_pg_type typform;
    Oid         oldNspOid;
    Oid         arrayOid;
    bool        isCompositeType;
    ObjectAddress thisobj;
 
    /*
     * Make sure we haven't moved this object previously.
     */
    thisobj.classId = TypeRelationId;
    thisobj.objectId = typeOid;
    thisobj.objectSubId = 0;
 
    if (object_address_present(&thisobj, objsMoved))
        return InvalidOid;
 
    rel = table_open(TypeRelationId, RowExclusiveLock);
 
    tup = SearchSysCacheCopy1(TYPEOID, ObjectIdGetDatum(typeOid));
    if (!HeapTupleIsValid(tup))
        elog(ERROR, "cache lookup failed for type %u", typeOid);
    typform = (Form_pg_type) GETSTRUCT(tup);
 
    oldNspOid = typform->typnamespace;
    arrayOid = typform->typarray;
 
    /* If the type is already there, we scan skip these next few checks. */
    if (oldNspOid != nspOid)
    {
        /* common checks on switching namespaces */
        CheckSetNamespace(oldNspOid, nspOid);
 
        /* check for duplicate name (more friendly than unique-index failure) */
        if (SearchSysCacheExists2(TYPENAMENSP,
                                  NameGetDatum(&typform->typname),
                                  ObjectIdGetDatum(nspOid)))
            ereport(ERROR,
                    (errcode(ERRCODE_DUPLICATE_OBJECT),
                     errmsg("type \"%s\" already exists in schema \"%s\"",
                            NameStr(typform->typname),
                            get_namespace_name(nspOid))));
    }
 
    /* Detect whether type is a composite type (but not a table rowtype) */
    isCompositeType =
        (typform->typtype == TYPTYPE_COMPOSITE &&
         get_rel_relkind(typform->typrelid) == RELKIND_COMPOSITE_TYPE);
 
    /* Enforce not-table-type if requested */
    if (typform->typtype == TYPTYPE_COMPOSITE && !isCompositeType)
    {
        if (ignoreDependent)
        {
            table_close(rel, RowExclusiveLock);
            return InvalidOid;
        }
        if (errorOnTableType)
            ereport(ERROR,
                    (errcode(ERRCODE_WRONG_OBJECT_TYPE),
                     errmsg("%s is a table's row type",
                            format_type_be(typeOid)),
            /* translator: %s is an SQL ALTER command */
                     errhint("Use %s instead.", "ALTER TABLE")));
    }
 
    if (oldNspOid != nspOid)
    {
        /* OK, modify the pg_type row */
 
        /* tup is a copy, so we can scribble directly on it */
        typform->typnamespace = nspOid;
 
        CatalogTupleUpdate(rel, &tup->t_self, tup);
    }
 
    /*
     * Composite types have pg_class entries.
     *
     * We need to modify the pg_class tuple as well to reflect the change of
     * schema.
     */
    if (isCompositeType)
    {
        Relation    classRel;
 
        classRel = table_open(RelationRelationId, RowExclusiveLock);
 
        AlterRelationNamespaceInternal(classRel, typform->typrelid,
                                       oldNspOid, nspOid,
                                       false, objsMoved);
 
        table_close(classRel, RowExclusiveLock);
 
        /*
         * Check for constraints associated with the composite type (we don't
         * currently support this, but probably will someday).
         */
        AlterConstraintNamespaces(typform->typrelid, oldNspOid,
                                  nspOid, false, objsMoved);
    }
    else
    {
        /* If it's a domain, it might have constraints */
        if (typform->typtype == TYPTYPE_DOMAIN)
            AlterConstraintNamespaces(typeOid, oldNspOid, nspOid, true,
                                      objsMoved);
    }
 
    /*
     * Update dependency on schema, if any --- a table rowtype has not got
     * one, and neither does an implicit array.
     */
    if (oldNspOid != nspOid &&
        (isCompositeType || typform->typtype != TYPTYPE_COMPOSITE) &&
        !isImplicitArray)
        if (changeDependencyFor(TypeRelationId, typeOid,
                                NamespaceRelationId, oldNspOid, nspOid) != 1)
            elog(ERROR, "could not change schema dependency for type \"%s\"",
                 format_type_be(typeOid));
 
    InvokeObjectPostAlterHook(TypeRelationId, typeOid, 0);
 
    heap_freetuple(tup);
 
    table_close(rel, RowExclusiveLock);
 
    add_exact_object_address(&thisobj, objsMoved);
 
    /* Recursively alter the associated array type, if any */
    if (OidIsValid(arrayOid))
        AlterTypeNamespaceInternal(arrayOid, nspOid,
                                   true,    /* isImplicitArray */
                                   false,   /* ignoreDependent */
                                   true,    /* errorOnTableType */
                                   objsMoved);
 
    return oldNspOid;
}

References add_exact_object_address(), AlterConstraintNamespaces(), AlterRelationNamespaceInternal(), CatalogTupleUpdate(), changeDependencyFor(), CheckSetNamespace(), ObjectAddress::classId, elog, ereport, errcode(), ERRCODE_DUPLICATE_OBJECT, errhint(), errmsg(), ERROR, format_type_be(), get_namespace_name(), get_rel_relkind(), GETSTRUCT, heap_freetuple(), HeapTupleIsValid, InvalidOid, InvokeObjectPostAlterHook, isCompositeType(), NameGetDatum(), NameStr, object_address_present(), ObjectAddress::objectId, ObjectIdGetDatum(), ObjectAddress::objectSubId, OidIsValid, RowExclusiveLock, SearchSysCacheCopy1, SearchSysCacheExists2, HeapTupleData::t_self, table_close(), and table_open().

Referenced by AlterTableNamespaceInternal(), and AlterTypeNamespace_oid().

AlterTypeOwner()

ObjectAddress AlterTypeOwner	(	List *	names,
		Oid	newOwnerId,
		ObjectType	objecttype
	)

Definition at line 3832 of file typecmds.c.

{
    TypeName   *typename;
    Oid         typeOid;
    Relation    rel;
    HeapTuple   tup;
    HeapTuple   newtup;
    Form_pg_type typTup;
    AclResult   aclresult;
    ObjectAddress address;
 
    rel = table_open(TypeRelationId, RowExclusiveLock);
 
    /* Make a TypeName so we can use standard type lookup machinery */
    typename = makeTypeNameFromNameList(names);
 
    /* Use LookupTypeName here so that shell types can be processed */
    tup = LookupTypeName(NULL, typename, NULL, false);
    if (tup == NULL)
        ereport(ERROR,
                (errcode(ERRCODE_UNDEFINED_OBJECT),
                 errmsg("type \"%s\" does not exist",
                        TypeNameToString(typename))));
    typeOid = typeTypeId(tup);
 
    /* Copy the syscache entry so we can scribble on it below */
    newtup = heap_copytuple(tup);
    ReleaseSysCache(tup);
    tup = newtup;
    typTup = (Form_pg_type) GETSTRUCT(tup);
 
    /* Don't allow ALTER DOMAIN on a type */
    if (objecttype == OBJECT_DOMAIN && typTup->typtype != TYPTYPE_DOMAIN)
        ereport(ERROR,
                (errcode(ERRCODE_WRONG_OBJECT_TYPE),
                 errmsg("%s is not a domain",
                        format_type_be(typeOid))));
 
    /*
     * If it's a composite type, we need to check that it really is a
     * free-standing composite type, and not a table's rowtype. We want people
     * to use ALTER TABLE not ALTER TYPE for that case.
     */
    if (typTup->typtype == TYPTYPE_COMPOSITE &&
        get_rel_relkind(typTup->typrelid) != RELKIND_COMPOSITE_TYPE)
        ereport(ERROR,
                (errcode(ERRCODE_WRONG_OBJECT_TYPE),
                 errmsg("%s is a table's row type",
                        format_type_be(typeOid)),
        /* translator: %s is an SQL ALTER command */
                 errhint("Use %s instead.",
                         "ALTER TABLE")));
 
    /* don't allow direct alteration of array types, either */
    if (IsTrueArrayType(typTup))
        ereport(ERROR,
                (errcode(ERRCODE_WRONG_OBJECT_TYPE),
                 errmsg("cannot alter array type %s",
                        format_type_be(typeOid)),
                 errhint("You can alter type %s, which will alter the array type as well.",
                         format_type_be(typTup->typelem))));
 
    /* don't allow direct alteration of multirange types, either */
    if (typTup->typtype == TYPTYPE_MULTIRANGE)
    {
        Oid         rangetype = get_multirange_range(typeOid);
 
        /* We don't expect get_multirange_range to fail, but cope if so */
        ereport(ERROR,
                (errcode(ERRCODE_WRONG_OBJECT_TYPE),
                 errmsg("cannot alter multirange type %s",
                        format_type_be(typeOid)),
                 OidIsValid(rangetype) ?
                 errhint("You can alter type %s, which will alter the multirange type as well.",
                         format_type_be(rangetype)) : 0));
    }
 
    /*
     * If the new owner is the same as the existing owner, consider the
     * command to have succeeded.  This is for dump restoration purposes.
     */
    if (typTup->typowner != newOwnerId)
    {
        /* Superusers can always do it */
        if (!superuser())
        {
            /* Otherwise, must be owner of the existing object */
            if (!object_ownercheck(TypeRelationId, typTup->oid, GetUserId()))
                aclcheck_error_type(ACLCHECK_NOT_OWNER, typTup->oid);
 
            /* Must be able to become new owner */
            check_can_set_role(GetUserId(), newOwnerId);
 
            /* New owner must have CREATE privilege on namespace */
            aclresult = object_aclcheck(NamespaceRelationId, typTup->typnamespace,
                                        newOwnerId,
                                        ACL_CREATE);
            if (aclresult != ACLCHECK_OK)
                aclcheck_error(aclresult, OBJECT_SCHEMA,
                               get_namespace_name(typTup->typnamespace));
        }
 
        AlterTypeOwner_oid(typeOid, newOwnerId, true);
    }
 
    ObjectAddressSet(address, TypeRelationId, typeOid);
 
    /* Clean up */
    table_close(rel, RowExclusiveLock);
 
    return address;
}

References ACL_CREATE, aclcheck_error(), aclcheck_error_type(), ACLCHECK_NOT_OWNER, ACLCHECK_OK, AlterTypeOwner_oid(), check_can_set_role(), ereport, errcode(), errhint(), errmsg(), ERROR, format_type_be(), get_multirange_range(), get_namespace_name(), get_rel_relkind(), GETSTRUCT, GetUserId(), heap_copytuple(), LookupTypeName(), makeTypeNameFromNameList(), object_aclcheck(), OBJECT_DOMAIN, object_ownercheck(), OBJECT_SCHEMA, ObjectAddressSet, OidIsValid, ReleaseSysCache(), RowExclusiveLock, superuser(), table_close(), table_open(), TypeNameToString(), and typeTypeId().

Referenced by ExecAlterOwnerStmt().

AlterTypeOwner_oid()

void AlterTypeOwner_oid	(	Oid	typeOid,
		Oid	newOwnerId,
		bool	hasDependEntry
	)

Definition at line 3957 of file typecmds.c.

{
    Relation    rel;
    HeapTuple   tup;
    Form_pg_type typTup;
 
    rel = table_open(TypeRelationId, RowExclusiveLock);
 
    tup = SearchSysCache1(TYPEOID, ObjectIdGetDatum(typeOid));
    if (!HeapTupleIsValid(tup))
        elog(ERROR, "cache lookup failed for type %u", typeOid);
    typTup = (Form_pg_type) GETSTRUCT(tup);
 
    /*
     * If it's a composite type, invoke ATExecChangeOwner so that we fix up
     * the pg_class entry properly.  That will call back to
     * AlterTypeOwnerInternal to take care of the pg_type entry(s).
     */
    if (typTup->typtype == TYPTYPE_COMPOSITE)
        ATExecChangeOwner(typTup->typrelid, newOwnerId, true, AccessExclusiveLock);
    else
        AlterTypeOwnerInternal(typeOid, newOwnerId);
 
    /* Update owner dependency reference */
    if (hasDependEntry)
        changeDependencyOnOwner(TypeRelationId, typeOid, newOwnerId);
 
    InvokeObjectPostAlterHook(TypeRelationId, typeOid, 0);
 
    ReleaseSysCache(tup);
    table_close(rel, RowExclusiveLock);
}

References AccessExclusiveLock, AlterTypeOwnerInternal(), ATExecChangeOwner(), changeDependencyOnOwner(), elog, ERROR, GETSTRUCT, HeapTupleIsValid, InvokeObjectPostAlterHook, ObjectIdGetDatum(), ReleaseSysCache(), RowExclusiveLock, SearchSysCache1(), table_close(), and table_open().

Referenced by AlterTypeOwner(), and shdepReassignOwned_Owner().

AlterTypeOwnerInternal()

void AlterTypeOwnerInternal	(	Oid	typeOid,
		Oid	newOwnerId
	)

Definition at line 3997 of file typecmds.c.

{
    Relation    rel;
    HeapTuple   tup;
    Form_pg_type typTup;
    Datum       repl_val[Natts_pg_type];
    bool        repl_null[Natts_pg_type];
    bool        repl_repl[Natts_pg_type];
    Acl        *newAcl;
    Datum       aclDatum;
    bool        isNull;
 
    rel = table_open(TypeRelationId, RowExclusiveLock);
 
    tup = SearchSysCacheCopy1(TYPEOID, ObjectIdGetDatum(typeOid));
    if (!HeapTupleIsValid(tup))
        elog(ERROR, "cache lookup failed for type %u", typeOid);
    typTup = (Form_pg_type) GETSTRUCT(tup);
 
    memset(repl_null, false, sizeof(repl_null));
    memset(repl_repl, false, sizeof(repl_repl));
 
    repl_repl[Anum_pg_type_typowner - 1] = true;
    repl_val[Anum_pg_type_typowner - 1] = ObjectIdGetDatum(newOwnerId);
 
    aclDatum = heap_getattr(tup,
                            Anum_pg_type_typacl,
                            RelationGetDescr(rel),
                            &isNull);
    /* Null ACLs do not require changes */
    if (!isNull)
    {
        newAcl = aclnewowner(DatumGetAclP(aclDatum),
                             typTup->typowner, newOwnerId);
        repl_repl[Anum_pg_type_typacl - 1] = true;
        repl_val[Anum_pg_type_typacl - 1] = PointerGetDatum(newAcl);
    }
 
    tup = heap_modify_tuple(tup, RelationGetDescr(rel), repl_val, repl_null,
                            repl_repl);
 
    CatalogTupleUpdate(rel, &tup->t_self, tup);
 
    /* If it has an array type, update that too */
    if (OidIsValid(typTup->typarray))
        AlterTypeOwnerInternal(typTup->typarray, newOwnerId);
 
    /* If it is a range type, update the associated multirange too */
    if (typTup->typtype == TYPTYPE_RANGE)
    {
        Oid         multirange_typeid = get_range_multirange(typeOid);
 
        if (!OidIsValid(multirange_typeid))
            ereport(ERROR,
                    (errcode(ERRCODE_UNDEFINED_OBJECT),
                     errmsg("could not find multirange type for data type %s",
                            format_type_be(typeOid))));
        AlterTypeOwnerInternal(multirange_typeid, newOwnerId);
    }
 
    /* Clean up */
    table_close(rel, RowExclusiveLock);
}

References aclnewowner(), CatalogTupleUpdate(), DatumGetAclP, elog, ereport, errcode(), errmsg(), ERROR, format_type_be(), get_range_multirange(), GETSTRUCT, heap_getattr(), heap_modify_tuple(), HeapTupleIsValid, ObjectIdGetDatum(), OidIsValid, PointerGetDatum(), RelationGetDescr, RowExclusiveLock, SearchSysCacheCopy1, HeapTupleData::t_self, table_close(), and table_open().

Referenced by AlterTypeOwner_oid(), and ATExecChangeOwner().

AssignTypeArrayOid()

Oid AssignTypeArrayOid

(

void

)

Definition at line 2418 of file typecmds.c.

{
    Oid         type_array_oid;
 
    /* Use binary-upgrade override for pg_type.typarray? */
    if (IsBinaryUpgrade)
    {
        if (!OidIsValid(binary_upgrade_next_array_pg_type_oid))
            ereport(ERROR,
                    (errcode(ERRCODE_INVALID_PARAMETER_VALUE),
                     errmsg("pg_type array OID value not set when in binary upgrade mode")));
 
        type_array_oid = binary_upgrade_next_array_pg_type_oid;
        binary_upgrade_next_array_pg_type_oid = InvalidOid;
    }
    else
    {
        Relation    pg_type = table_open(TypeRelationId, AccessShareLock);
 
        type_array_oid = GetNewOidWithIndex(pg_type, TypeOidIndexId,
                                            Anum_pg_type_oid);
        table_close(pg_type, AccessShareLock);
    }
 
    return type_array_oid;
}

References AccessShareLock, binary_upgrade_next_array_pg_type_oid, ereport, errcode(), errmsg(), ERROR, GetNewOidWithIndex(), InvalidOid, IsBinaryUpgrade, OidIsValid, table_close(), and table_open().

Referenced by DefineDomain(), DefineEnum(), DefineRange(), DefineType(), and heap_create_with_catalog().

AssignTypeMultirangeArrayOid()

Oid AssignTypeMultirangeArrayOid

(

void

)

Definition at line 2484 of file typecmds.c.

{
    Oid         type_multirange_array_oid;
 
    /* Use binary-upgrade override for pg_type.oid? */
    if (IsBinaryUpgrade)
    {
        if (!OidIsValid(binary_upgrade_next_mrng_array_pg_type_oid))
            ereport(ERROR,
                    (errcode(ERRCODE_INVALID_PARAMETER_VALUE),
                     errmsg("pg_type multirange array OID value not set when in binary upgrade mode")));
 
        type_multirange_array_oid = binary_upgrade_next_mrng_array_pg_type_oid;
        binary_upgrade_next_mrng_array_pg_type_oid = InvalidOid;
    }
    else
    {
        Relation    pg_type = table_open(TypeRelationId, AccessShareLock);
 
        type_multirange_array_oid = GetNewOidWithIndex(pg_type, TypeOidIndexId,
                                                       Anum_pg_type_oid);
        table_close(pg_type, AccessShareLock);
    }
 
    return type_multirange_array_oid;
}

References AccessShareLock, binary_upgrade_next_mrng_array_pg_type_oid, ereport, errcode(), errmsg(), ERROR, GetNewOidWithIndex(), InvalidOid, IsBinaryUpgrade, OidIsValid, table_close(), and table_open().

Referenced by DefineRange().

AssignTypeMultirangeOid()

Oid AssignTypeMultirangeOid

(

void

)

Definition at line 2451 of file typecmds.c.

{
    Oid         type_multirange_oid;
 
    /* Use binary-upgrade override for pg_type.oid? */
    if (IsBinaryUpgrade)
    {
        if (!OidIsValid(binary_upgrade_next_mrng_pg_type_oid))
            ereport(ERROR,
                    (errcode(ERRCODE_INVALID_PARAMETER_VALUE),
                     errmsg("pg_type multirange OID value not set when in binary upgrade mode")));
 
        type_multirange_oid = binary_upgrade_next_mrng_pg_type_oid;
        binary_upgrade_next_mrng_pg_type_oid = InvalidOid;
    }
    else
    {
        Relation    pg_type = table_open(TypeRelationId, AccessShareLock);
 
        type_multirange_oid = GetNewOidWithIndex(pg_type, TypeOidIndexId,
                                                 Anum_pg_type_oid);
        table_close(pg_type, AccessShareLock);
    }
 
    return type_multirange_oid;
}

References AccessShareLock, binary_upgrade_next_mrng_pg_type_oid, ereport, errcode(), errmsg(), ERROR, GetNewOidWithIndex(), InvalidOid, IsBinaryUpgrade, OidIsValid, table_close(), and table_open().

Referenced by DefineRange().

checkDomainOwner()

void checkDomainOwner

(

HeapTuple

tup

)

Definition at line 3498 of file typecmds.c.

{
    Form_pg_type typTup = (Form_pg_type) GETSTRUCT(tup);
 
    /* Check that this is actually a domain */
    if (typTup->typtype != TYPTYPE_DOMAIN)
        ereport(ERROR,
                (errcode(ERRCODE_WRONG_OBJECT_TYPE),
                 errmsg("%s is not a domain",
                        format_type_be(typTup->oid))));
 
    /* Permission check: must own type */
    if (!object_ownercheck(TypeRelationId, typTup->oid, GetUserId()))
        aclcheck_error_type(ACLCHECK_NOT_OWNER, typTup->oid);
}

References aclcheck_error_type(), ACLCHECK_NOT_OWNER, ereport, errcode(), errmsg(), ERROR, format_type_be(), GETSTRUCT, GetUserId(), and object_ownercheck().

Referenced by AlterDomainAddConstraint(), AlterDomainDefault(), AlterDomainDropConstraint(), AlterDomainNotNull(), AlterDomainValidateConstraint(), and RenameConstraint().

DefineCompositeType()

ObjectAddress DefineCompositeType	(	RangeVar *	typevar,
		List *	coldeflist
	)

Definition at line 2526 of file typecmds.c.

{
    CreateStmt *createStmt = makeNode(CreateStmt);
    Oid         old_type_oid;
    Oid         typeNamespace;
    ObjectAddress address;
 
    /*
     * now set the parameters for keys/inheritance etc. All of these are
     * uninteresting for composite types...
     */
    createStmt->relation = typevar;
    createStmt->tableElts = coldeflist;
    createStmt->inhRelations = NIL;
    createStmt->constraints = NIL;
    createStmt->options = NIL;
    createStmt->oncommit = ONCOMMIT_NOOP;
    createStmt->tablespacename = NULL;
    createStmt->if_not_exists = false;
 
    /*
     * Check for collision with an existing type name. If there is one and
     * it's an autogenerated array, we can rename it out of the way.  This
     * check is here mainly to get a better error message about a "type"
     * instead of below about a "relation".
     */
    typeNamespace = RangeVarGetAndCheckCreationNamespace(createStmt->relation,
                                                         NoLock, NULL);
    RangeVarAdjustRelationPersistence(createStmt->relation, typeNamespace);
    old_type_oid =
        GetSysCacheOid2(TYPENAMENSP, Anum_pg_type_oid,
                        CStringGetDatum(createStmt->relation->relname),
                        ObjectIdGetDatum(typeNamespace));
    if (OidIsValid(old_type_oid))
    {
        if (!moveArrayTypeName(old_type_oid, createStmt->relation->relname, typeNamespace))
            ereport(ERROR,
                    (errcode(ERRCODE_DUPLICATE_OBJECT),
                     errmsg("type \"%s\" already exists", createStmt->relation->relname)));
    }
 
    /*
     * Finally create the relation.  This also creates the type.
     */
    DefineRelation(createStmt, RELKIND_COMPOSITE_TYPE, InvalidOid, &address,
                   NULL);
 
    return address;
}

References CreateStmt::constraints, CStringGetDatum(), DefineRelation(), ereport, errcode(), ERRCODE_DUPLICATE_OBJECT, errmsg(), ERROR, GetSysCacheOid2, CreateStmt::if_not_exists, CreateStmt::inhRelations, InvalidOid, makeNode, moveArrayTypeName(), NIL, NoLock, ObjectIdGetDatum(), OidIsValid, CreateStmt::oncommit, ONCOMMIT_NOOP, CreateStmt::options, RangeVarAdjustRelationPersistence(), RangeVarGetAndCheckCreationNamespace(), CreateStmt::relation, RangeVar::relname, CreateStmt::tableElts, and CreateStmt::tablespacename.

Referenced by ProcessUtilitySlow().

DefineDomain()

ObjectAddress DefineDomain

(

CreateDomainStmt *

stmt

)

Definition at line 697 of file typecmds.c.

{
    char       *domainName;
    char       *domainArrayName;
    Oid         domainNamespace;
    AclResult   aclresult;
    int16       internalLength;
    Oid         inputProcedure;
    Oid         outputProcedure;
    Oid         receiveProcedure;
    Oid         sendProcedure;
    Oid         analyzeProcedure;
    bool        byValue;
    char        category;
    char        delimiter;
    char        alignment;
    char        storage;
    char        typtype;
    Datum       datum;
    bool        isnull;
    char       *defaultValue = NULL;
    char       *defaultValueBin = NULL;
    bool        saw_default = false;
    bool        typNotNull = false;
    bool        nullDefined = false;
    int32       typNDims = list_length(stmt->typeName->arrayBounds);
    HeapTuple   typeTup;
    List       *schema = stmt->constraints;
    ListCell   *listptr;
    Oid         basetypeoid;
    Oid         old_type_oid;
    Oid         domaincoll;
    Oid         domainArrayOid;
    Form_pg_type baseType;
    int32       basetypeMod;
    Oid         baseColl;
    ObjectAddress address;
 
    /* Convert list of names to a name and namespace */
    domainNamespace = QualifiedNameGetCreationNamespace(stmt->domainname,
                                                        &domainName);
 
    /* Check we have creation rights in target namespace */
    aclresult = object_aclcheck(NamespaceRelationId, domainNamespace, GetUserId(),
                                ACL_CREATE);
    if (aclresult != ACLCHECK_OK)
        aclcheck_error(aclresult, OBJECT_SCHEMA,
                       get_namespace_name(domainNamespace));
 
    /*
     * Check for collision with an existing type name.  If there is one and
     * it's an autogenerated array, we can rename it out of the way.
     */
    old_type_oid = GetSysCacheOid2(TYPENAMENSP, Anum_pg_type_oid,
                                   CStringGetDatum(domainName),
                                   ObjectIdGetDatum(domainNamespace));
    if (OidIsValid(old_type_oid))
    {
        if (!moveArrayTypeName(old_type_oid, domainName, domainNamespace))
            ereport(ERROR,
                    (errcode(ERRCODE_DUPLICATE_OBJECT),
                     errmsg("type \"%s\" already exists", domainName)));
    }
 
    /*
     * Look up the base type.
     */
    typeTup = typenameType(NULL, stmt->typeName, &basetypeMod);
    baseType = (Form_pg_type) GETSTRUCT(typeTup);
    basetypeoid = baseType->oid;
 
    /*
     * Base type must be a plain base type, a composite type, another domain,
     * an enum or a range type.  Domains over pseudotypes would create a
     * security hole.  (It would be shorter to code this to just check for
     * pseudotypes; but it seems safer to call out the specific typtypes that
     * are supported, rather than assume that all future typtypes would be
     * automatically supported.)
     */
    typtype = baseType->typtype;
    if (typtype != TYPTYPE_BASE &&
        typtype != TYPTYPE_COMPOSITE &&
        typtype != TYPTYPE_DOMAIN &&
        typtype != TYPTYPE_ENUM &&
        typtype != TYPTYPE_RANGE &&
        typtype != TYPTYPE_MULTIRANGE)
        ereport(ERROR,
                (errcode(ERRCODE_DATATYPE_MISMATCH),
                 errmsg("\"%s\" is not a valid base type for a domain",
                        TypeNameToString(stmt->typeName))));
 
    aclresult = object_aclcheck(TypeRelationId, basetypeoid, GetUserId(), ACL_USAGE);
    if (aclresult != ACLCHECK_OK)
        aclcheck_error_type(aclresult, basetypeoid);
 
    /*
     * Collect the properties of the new domain.  Some are inherited from the
     * base type, some are not.  If you change any of this inheritance
     * behavior, be sure to update AlterTypeRecurse() to match!
     */
 
    /*
     * Identify the collation if any
     */
    baseColl = baseType->typcollation;
    if (stmt->collClause)
        domaincoll = get_collation_oid(stmt->collClause->collname, false);
    else
        domaincoll = baseColl;
 
    /* Complain if COLLATE is applied to an uncollatable type */
    if (OidIsValid(domaincoll) && !OidIsValid(baseColl))
        ereport(ERROR,
                (errcode(ERRCODE_DATATYPE_MISMATCH),
                 errmsg("collations are not supported by type %s",
                        format_type_be(basetypeoid))));
 
    /* passed by value */
    byValue = baseType->typbyval;
 
    /* Required Alignment */
    alignment = baseType->typalign;
 
    /* TOAST Strategy */
    storage = baseType->typstorage;
 
    /* Storage Length */
    internalLength = baseType->typlen;
 
    /* Type Category */
    category = baseType->typcategory;
 
    /* Array element Delimiter */
    delimiter = baseType->typdelim;
 
    /* I/O Functions */
    inputProcedure = F_DOMAIN_IN;
    outputProcedure = baseType->typoutput;
    receiveProcedure = F_DOMAIN_RECV;
    sendProcedure = baseType->typsend;
 
    /* Domains never accept typmods, so no typmodin/typmodout needed */
 
    /* Analysis function */
    analyzeProcedure = baseType->typanalyze;
 
    /*
     * Domains don't need a subscript function, since they are not
     * subscriptable on their own.  If the base type is subscriptable, the
     * parser will reduce the type to the base type before subscripting.
     */
 
    /* Inherited default value */
    datum = SysCacheGetAttr(TYPEOID, typeTup,
                            Anum_pg_type_typdefault, &isnull);
    if (!isnull)
        defaultValue = TextDatumGetCString(datum);
 
    /* Inherited default binary value */
    datum = SysCacheGetAttr(TYPEOID, typeTup,
                            Anum_pg_type_typdefaultbin, &isnull);
    if (!isnull)
        defaultValueBin = TextDatumGetCString(datum);
 
    /*
     * Run through constraints manually to avoid the additional processing
     * conducted by DefineRelation() and friends.
     */
    foreach(listptr, schema)
    {
        Constraint *constr = lfirst(listptr);
 
        if (!IsA(constr, Constraint))
            elog(ERROR, "unrecognized node type: %d",
                 (int) nodeTag(constr));
        switch (constr->contype)
        {
            case CONSTR_DEFAULT:
 
                /*
                 * The inherited default value may be overridden by the user
                 * with the DEFAULT <expr> clause ... but only once.
                 */
                if (saw_default)
                    ereport(ERROR,
                            (errcode(ERRCODE_SYNTAX_ERROR),
                             errmsg("multiple default expressions")));
                saw_default = true;
 
                if (constr->raw_expr)
                {
                    ParseState *pstate;
                    Node       *defaultExpr;
 
                    /* Create a dummy ParseState for transformExpr */
                    pstate = make_parsestate(NULL);
 
                    /*
                     * Cook the constr->raw_expr into an expression. Note:
                     * name is strictly for error message
                     */
                    defaultExpr = cookDefault(pstate, constr->raw_expr,
                                              basetypeoid,
                                              basetypeMod,
                                              domainName,
                                              0);
 
                    /*
                     * If the expression is just a NULL constant, we treat it
                     * like not having a default.
                     *
                     * Note that if the basetype is another domain, we'll see
                     * a CoerceToDomain expr here and not discard the default.
                     * This is critical because the domain default needs to be
                     * retained to override any default that the base domain
                     * might have.
                     */
                    if (defaultExpr == NULL ||
                        (IsA(defaultExpr, Const) &&
                         ((Const *) defaultExpr)->constisnull))
                    {
                        defaultValue = NULL;
                        defaultValueBin = NULL;
                    }
                    else
                    {
                        /*
                         * Expression must be stored as a nodeToString result,
                         * but we also require a valid textual representation
                         * (mainly to make life easier for pg_dump).
                         */
                        defaultValue =
                            deparse_expression(defaultExpr,
                                               NIL, false, false);
                        defaultValueBin = nodeToString(defaultExpr);
                    }
                }
                else
                {
                    /* No default (can this still happen?) */
                    defaultValue = NULL;
                    defaultValueBin = NULL;
                }
                break;
 
            case CONSTR_NOTNULL:
                if (nullDefined && !typNotNull)
                    ereport(ERROR,
                            (errcode(ERRCODE_SYNTAX_ERROR),
                             errmsg("conflicting NULL/NOT NULL constraints")));
                if (constr->is_no_inherit)
                    ereport(ERROR,
                            errcode(ERRCODE_INVALID_OBJECT_DEFINITION),
                            errmsg("not-null constraints for domains cannot be marked NO INHERIT"));
                typNotNull = true;
                nullDefined = true;
                break;
 
            case CONSTR_NULL:
                if (nullDefined && typNotNull)
                    ereport(ERROR,
                            (errcode(ERRCODE_SYNTAX_ERROR),
                             errmsg("conflicting NULL/NOT NULL constraints")));
                typNotNull = false;
                nullDefined = true;
                break;
 
            case CONSTR_CHECK:
 
                /*
                 * Check constraints are handled after domain creation, as
                 * they require the Oid of the domain; at this point we can
                 * only check that they're not marked NO INHERIT, because that
                 * would be bogus.
                 */
                if (constr->is_no_inherit)
                    ereport(ERROR,
                            (errcode(ERRCODE_INVALID_OBJECT_DEFINITION),
                             errmsg("check constraints for domains cannot be marked NO INHERIT")));
                break;
 
                /*
                 * All else are error cases
                 */
            case CONSTR_UNIQUE:
                ereport(ERROR,
                        (errcode(ERRCODE_SYNTAX_ERROR),
                         errmsg("unique constraints not possible for domains")));
                break;
 
            case CONSTR_PRIMARY:
                ereport(ERROR,
                        (errcode(ERRCODE_SYNTAX_ERROR),
                         errmsg("primary key constraints not possible for domains")));
                break;
 
            case CONSTR_EXCLUSION:
                ereport(ERROR,
                        (errcode(ERRCODE_SYNTAX_ERROR),
                         errmsg("exclusion constraints not possible for domains")));
                break;
 
            case CONSTR_FOREIGN:
                ereport(ERROR,
                        (errcode(ERRCODE_SYNTAX_ERROR),
                         errmsg("foreign key constraints not possible for domains")));
                break;
 
            case CONSTR_ATTR_DEFERRABLE:
            case CONSTR_ATTR_NOT_DEFERRABLE:
            case CONSTR_ATTR_DEFERRED:
            case CONSTR_ATTR_IMMEDIATE:
                ereport(ERROR,
                        (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                         errmsg("specifying constraint deferrability not supported for domains")));
                break;
 
            case CONSTR_GENERATED:
            case CONSTR_IDENTITY:
                ereport(ERROR,
                        (errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                         errmsg("specifying GENERATED not supported for domains")));
                break;
 
                /* no default, to let compiler warn about missing case */
        }
    }
 
    /* Allocate OID for array type */
    domainArrayOid = AssignTypeArrayOid();
 
    /*
     * Have TypeCreate do all the real work.
     */
    address =
        TypeCreate(InvalidOid,  /* no predetermined type OID */
                   domainName,  /* type name */
                   domainNamespace, /* namespace */
                   InvalidOid,  /* relation oid (n/a here) */
                   0,           /* relation kind (ditto) */
                   GetUserId(), /* owner's ID */
                   internalLength,  /* internal size */
                   TYPTYPE_DOMAIN,  /* type-type (domain type) */
                   category,    /* type-category */
                   false,       /* domain types are never preferred */
                   delimiter,   /* array element delimiter */
                   inputProcedure,  /* input procedure */
                   outputProcedure, /* output procedure */
                   receiveProcedure,    /* receive procedure */
                   sendProcedure,   /* send procedure */
                   InvalidOid,  /* typmodin procedure - none */
                   InvalidOid,  /* typmodout procedure - none */
                   analyzeProcedure,    /* analyze procedure */
                   InvalidOid,  /* subscript procedure - none */
                   InvalidOid,  /* no array element type */
                   false,       /* this isn't an array */
                   domainArrayOid,  /* array type we are about to create */
                   basetypeoid, /* base type ID */
                   defaultValue,    /* default type value (text) */
                   defaultValueBin, /* default type value (binary) */
                   byValue,     /* passed by value */
                   alignment,   /* required alignment */
                   storage,     /* TOAST strategy */
                   basetypeMod, /* typeMod value */
                   typNDims,    /* Array dimensions for base type */
                   typNotNull,  /* Type NOT NULL */
                   domaincoll); /* type's collation */
 
    /*
     * Create the array type that goes with it.
     */
    domainArrayName = makeArrayTypeName(domainName, domainNamespace);
 
    /* alignment must be TYPALIGN_INT or TYPALIGN_DOUBLE for arrays */
    alignment = (alignment == TYPALIGN_DOUBLE) ? TYPALIGN_DOUBLE : TYPALIGN_INT;
 
    TypeCreate(domainArrayOid,  /* force assignment of this type OID */
               domainArrayName, /* type name */
               domainNamespace, /* namespace */
               InvalidOid,      /* relation oid (n/a here) */
               0,               /* relation kind (ditto) */
               GetUserId(),     /* owner's ID */
               -1,              /* internal size (always varlena) */
               TYPTYPE_BASE,    /* type-type (base type) */
               TYPCATEGORY_ARRAY,   /* type-category (array) */
               false,           /* array types are never preferred */
               delimiter,       /* array element delimiter */
               F_ARRAY_IN,      /* input procedure */
               F_ARRAY_OUT,     /* output procedure */
               F_ARRAY_RECV,    /* receive procedure */
               F_ARRAY_SEND,    /* send procedure */
               InvalidOid,      /* typmodin procedure - none */
               InvalidOid,      /* typmodout procedure - none */
               F_ARRAY_TYPANALYZE,  /* analyze procedure */
               F_ARRAY_SUBSCRIPT_HANDLER,   /* array subscript procedure */
               address.objectId,    /* element type ID */
               true,            /* yes this is an array type */
               InvalidOid,      /* no further array type */
               InvalidOid,      /* base type ID */
               NULL,            /* never a default type value */
               NULL,            /* binary default isn't sent either */
               false,           /* never passed by value */
               alignment,       /* see above */
               TYPSTORAGE_EXTENDED, /* ARRAY is always toastable */
               -1,              /* typMod (Domains only) */
               0,               /* Array dimensions of typbasetype */
               false,           /* Type NOT NULL */
               domaincoll);     /* type's collation */
 
    pfree(domainArrayName);
 
    /*
     * Process constraints which refer to the domain ID returned by TypeCreate
     */
    foreach(listptr, schema)
    {
        Constraint *constr = lfirst(listptr);
 
        /* it must be a Constraint, per check above */
 
        switch (constr->contype)
        {
            case CONSTR_CHECK:
                domainAddCheckConstraint(address.objectId, domainNamespace,
                                         basetypeoid, basetypeMod,
                                         constr, domainName, NULL);
                break;
 
            case CONSTR_NOTNULL:
                domainAddNotNullConstraint(address.objectId, domainNamespace,
                                           basetypeoid, basetypeMod,
                                           constr, domainName, NULL);
                break;
 
                /* Other constraint types were fully processed above */
 
            default:
                break;
        }
 
        /* CCI so we can detect duplicate constraint names */
        CommandCounterIncrement();
    }
 
    /*
     * Now we can clean up.
     */
    ReleaseSysCache(typeTup);
 
    return address;
}

References ACL_CREATE, ACL_USAGE, aclcheck_error(), aclcheck_error_type(), ACLCHECK_OK, AssignTypeArrayOid(), CommandCounterIncrement(), CONSTR_ATTR_DEFERRABLE, CONSTR_ATTR_DEFERRED, CONSTR_ATTR_IMMEDIATE, CONSTR_ATTR_NOT_DEFERRABLE, CONSTR_CHECK, CONSTR_DEFAULT, CONSTR_EXCLUSION, CONSTR_FOREIGN, CONSTR_GENERATED, CONSTR_IDENTITY, CONSTR_NOTNULL, CONSTR_NULL, CONSTR_PRIMARY, CONSTR_UNIQUE, Constraint::contype, cookDefault(), CStringGetDatum(), deparse_expression(), domainAddCheckConstraint(), domainAddNotNullConstraint(), elog, ereport, errcode(), ERRCODE_DUPLICATE_OBJECT, errmsg(), ERROR, format_type_be(), get_collation_oid(), get_namespace_name(), GETSTRUCT, GetSysCacheOid2, GetUserId(), InvalidOid, Constraint::is_no_inherit, IsA, lfirst, list_length(), make_parsestate(), makeArrayTypeName(), moveArrayTypeName(), NIL, nodeTag, nodeToString(), object_aclcheck(), OBJECT_SCHEMA, ObjectAddress::objectId, ObjectIdGetDatum(), OidIsValid, pfree(), QualifiedNameGetCreationNamespace(), Constraint::raw_expr, ReleaseSysCache(), stmt, storage, SysCacheGetAttr(), TextDatumGetCString, TypeCreate(), TypeNameToString(), and typenameType().

Referenced by ProcessUtilitySlow().

DefineEnum()

ObjectAddress DefineEnum

(

CreateEnumStmt *

stmt

)

Definition at line 1155 of file typecmds.c.

{
    char       *enumName;
    char       *enumArrayName;
    Oid         enumNamespace;
    AclResult   aclresult;
    Oid         old_type_oid;
    Oid         enumArrayOid;
    ObjectAddress enumTypeAddr;
 
    /* Convert list of names to a name and namespace */
    enumNamespace = QualifiedNameGetCreationNamespace(stmt->typeName,
                                                      &enumName);
 
    /* Check we have creation rights in target namespace */
    aclresult = object_aclcheck(NamespaceRelationId, enumNamespace, GetUserId(), ACL_CREATE);
    if (aclresult != ACLCHECK_OK)
        aclcheck_error(aclresult, OBJECT_SCHEMA,
                       get_namespace_name(enumNamespace));
 
    /*
     * Check for collision with an existing type name.  If there is one and
     * it's an autogenerated array, we can rename it out of the way.
     */
    old_type_oid = GetSysCacheOid2(TYPENAMENSP, Anum_pg_type_oid,
                                   CStringGetDatum(enumName),
                                   ObjectIdGetDatum(enumNamespace));
    if (OidIsValid(old_type_oid))
    {
        if (!moveArrayTypeName(old_type_oid, enumName, enumNamespace))
            ereport(ERROR,
                    (errcode(ERRCODE_DUPLICATE_OBJECT),
                     errmsg("type \"%s\" already exists", enumName)));
    }
 
    /* Allocate OID for array type */
    enumArrayOid = AssignTypeArrayOid();
 
    /* Create the pg_type entry */
    enumTypeAddr =
        TypeCreate(InvalidOid,  /* no predetermined type OID */
                   enumName,    /* type name */
                   enumNamespace,   /* namespace */
                   InvalidOid,  /* relation oid (n/a here) */
                   0,           /* relation kind (ditto) */
                   GetUserId(), /* owner's ID */
                   sizeof(Oid), /* internal size */
                   TYPTYPE_ENUM,    /* type-type (enum type) */
                   TYPCATEGORY_ENUM,    /* type-category (enum type) */
                   false,       /* enum types are never preferred */
                   DEFAULT_TYPDELIM,    /* array element delimiter */
                   F_ENUM_IN,   /* input procedure */
                   F_ENUM_OUT,  /* output procedure */
                   F_ENUM_RECV, /* receive procedure */
                   F_ENUM_SEND, /* send procedure */
                   InvalidOid,  /* typmodin procedure - none */
                   InvalidOid,  /* typmodout procedure - none */
                   InvalidOid,  /* analyze procedure - default */
                   InvalidOid,  /* subscript procedure - none */
                   InvalidOid,  /* element type ID */
                   false,       /* this is not an array type */
                   enumArrayOid,    /* array type we are about to create */
                   InvalidOid,  /* base type ID (only for domains) */
                   NULL,        /* never a default type value */
                   NULL,        /* binary default isn't sent either */
                   true,        /* always passed by value */
                   TYPALIGN_INT,    /* int alignment */
                   TYPSTORAGE_PLAIN,    /* TOAST strategy always plain */
                   -1,          /* typMod (Domains only) */
                   0,           /* Array dimensions of typbasetype */
                   false,       /* Type NOT NULL */
                   InvalidOid); /* type's collation */
 
    /* Enter the enum's values into pg_enum */
    EnumValuesCreate(enumTypeAddr.objectId, stmt->vals);
 
    /*
     * Create the array type that goes with it.
     */
    enumArrayName = makeArrayTypeName(enumName, enumNamespace);
 
    TypeCreate(enumArrayOid,    /* force assignment of this type OID */
               enumArrayName,   /* type name */
               enumNamespace,   /* namespace */
               InvalidOid,      /* relation oid (n/a here) */
               0,               /* relation kind (ditto) */
               GetUserId(),     /* owner's ID */
               -1,              /* internal size (always varlena) */
               TYPTYPE_BASE,    /* type-type (base type) */
               TYPCATEGORY_ARRAY,   /* type-category (array) */
               false,           /* array types are never preferred */
               DEFAULT_TYPDELIM,    /* array element delimiter */
               F_ARRAY_IN,      /* input procedure */
               F_ARRAY_OUT,     /* output procedure */
               F_ARRAY_RECV,    /* receive procedure */
               F_ARRAY_SEND,    /* send procedure */
               InvalidOid,      /* typmodin procedure - none */
               InvalidOid,      /* typmodout procedure - none */
               F_ARRAY_TYPANALYZE,  /* analyze procedure */
               F_ARRAY_SUBSCRIPT_HANDLER,   /* array subscript procedure */
               enumTypeAddr.objectId,   /* element type ID */
               true,            /* yes this is an array type */
               InvalidOid,      /* no further array type */
               InvalidOid,      /* base type ID */
               NULL,            /* never a default type value */
               NULL,            /* binary default isn't sent either */
               false,           /* never passed by value */
               TYPALIGN_INT,    /* enums have int align, so do their arrays */
               TYPSTORAGE_EXTENDED, /* ARRAY is always toastable */
               -1,              /* typMod (Domains only) */
               0,               /* Array dimensions of typbasetype */
               false,           /* Type NOT NULL */
               InvalidOid);     /* type's collation */
 
    pfree(enumArrayName);
 
    return enumTypeAddr;
}

References ACL_CREATE, aclcheck_error(), ACLCHECK_OK, AssignTypeArrayOid(), CStringGetDatum(), DEFAULT_TYPDELIM, EnumValuesCreate(), ereport, errcode(), ERRCODE_DUPLICATE_OBJECT, errmsg(), ERROR, get_namespace_name(), GetSysCacheOid2, GetUserId(), InvalidOid, makeArrayTypeName(), moveArrayTypeName(), object_aclcheck(), OBJECT_SCHEMA, ObjectAddress::objectId, ObjectIdGetDatum(), OidIsValid, pfree(), QualifiedNameGetCreationNamespace(), stmt, and TypeCreate().

Referenced by ProcessUtilitySlow().

DefineRange()

ObjectAddress DefineRange	(	ParseState *	pstate,
		CreateRangeStmt *	stmt
	)

Definition at line 1354 of file typecmds.c.

{
    char       *typeName;
    Oid         typeNamespace;
    Oid         typoid;
    char       *rangeArrayName;
    char       *multirangeTypeName = NULL;
    char       *multirangeArrayName;
    Oid         multirangeNamespace = InvalidOid;
    Oid         rangeArrayOid;
    Oid         multirangeOid;
    Oid         multirangeArrayOid;
    Oid         rangeSubtype = InvalidOid;
    List       *rangeSubOpclassName = NIL;
    List       *rangeCollationName = NIL;
    List       *rangeCanonicalName = NIL;
    List       *rangeSubtypeDiffName = NIL;
    Oid         rangeSubOpclass;
    Oid         rangeCollation;
    regproc     rangeCanonical;
    regproc     rangeSubtypeDiff;
    int16       subtyplen;
    bool        subtypbyval;
    char        subtypalign;
    char        alignment;
    AclResult   aclresult;
    ListCell   *lc;
    ObjectAddress address;
    ObjectAddress mltrngaddress PG_USED_FOR_ASSERTS_ONLY;
    Oid         castFuncOid;
 
    /* Convert list of names to a name and namespace */
    typeNamespace = QualifiedNameGetCreationNamespace(stmt->typeName,
                                                      &typeName);
 
    /* Check we have creation rights in target namespace */
    aclresult = object_aclcheck(NamespaceRelationId, typeNamespace, GetUserId(), ACL_CREATE);
    if (aclresult != ACLCHECK_OK)
        aclcheck_error(aclresult, OBJECT_SCHEMA,
                       get_namespace_name(typeNamespace));
 
    /*
     * Look to see if type already exists.
     */
    typoid = GetSysCacheOid2(TYPENAMENSP, Anum_pg_type_oid,
                             CStringGetDatum(typeName),
                             ObjectIdGetDatum(typeNamespace));
 
    /*
     * If it's not a shell, see if it's an autogenerated array type, and if so
     * rename it out of the way.
     */
    if (OidIsValid(typoid) && get_typisdefined(typoid))
    {
        if (moveArrayTypeName(typoid, typeName, typeNamespace))
            typoid = InvalidOid;
        else
            ereport(ERROR,
                    (errcode(ERRCODE_DUPLICATE_OBJECT),
                     errmsg("type \"%s\" already exists", typeName)));
    }
 
    /*
     * Unlike DefineType(), we don't insist on a shell type existing first, as
     * it's only needed if the user wants to specify a canonical function.
     */
 
    /* Extract the parameters from the parameter list */
    foreach(lc, stmt->params)
    {
        DefElem    *defel = (DefElem *) lfirst(lc);
 
        if (strcmp(defel->defname, "subtype") == 0)
        {
            if (OidIsValid(rangeSubtype))
                errorConflictingDefElem(defel, pstate);
            /* we can look up the subtype name immediately */
            rangeSubtype = typenameTypeId(NULL, defGetTypeName(defel));
        }
        else if (strcmp(defel->defname, "subtype_opclass") == 0)
        {
            if (rangeSubOpclassName != NIL)
                errorConflictingDefElem(defel, pstate);
            rangeSubOpclassName = defGetQualifiedName(defel);
        }
        else if (strcmp(defel->defname, "collation") == 0)
        {
            if (rangeCollationName != NIL)
                errorConflictingDefElem(defel, pstate);
            rangeCollationName = defGetQualifiedName(defel);
        }
        else if (strcmp(defel->defname, "canonical") == 0)
        {
            if (rangeCanonicalName != NIL)
                errorConflictingDefElem(defel, pstate);
            rangeCanonicalName = defGetQualifiedName(defel);
        }
        else if (strcmp(defel->defname, "subtype_diff") == 0)
        {
            if (rangeSubtypeDiffName != NIL)
                errorConflictingDefElem(defel, pstate);
            rangeSubtypeDiffName = defGetQualifiedName(defel);
        }
        else if (strcmp(defel->defname, "multirange_type_name") == 0)
        {
            if (multirangeTypeName != NULL)
                errorConflictingDefElem(defel, pstate);
            /* we can look up the subtype name immediately */
            multirangeNamespace = QualifiedNameGetCreationNamespace(defGetQualifiedName(defel),
                                                                    &multirangeTypeName);
        }
        else
            ereport(ERROR,
                    (errcode(ERRCODE_SYNTAX_ERROR),
                     errmsg("type attribute \"%s\" not recognized",
                            defel->defname)));
    }
 
    /* Must have a subtype */
    if (!OidIsValid(rangeSubtype))
        ereport(ERROR,
                (errcode(ERRCODE_SYNTAX_ERROR),
                 errmsg("type attribute \"subtype\" is required")));
    /* disallow ranges of pseudotypes */
    if (get_typtype(rangeSubtype) == TYPTYPE_PSEUDO)
        ereport(ERROR,
                (errcode(ERRCODE_DATATYPE_MISMATCH),
                 errmsg("range subtype cannot be %s",
                        format_type_be(rangeSubtype))));
 
    /* Identify subopclass */
    rangeSubOpclass = findRangeSubOpclass(rangeSubOpclassName, rangeSubtype);
 
    /* Identify collation to use, if any */
    if (type_is_collatable(rangeSubtype))
    {
        if (rangeCollationName != NIL)
            rangeCollation = get_collation_oid(rangeCollationName, false);
        else
            rangeCollation = get_typcollation(rangeSubtype);
    }
    else
    {
        if (rangeCollationName != NIL)
            ereport(ERROR,
                    (errcode(ERRCODE_WRONG_OBJECT_TYPE),
                     errmsg("range collation specified but subtype does not support collation")));
        rangeCollation = InvalidOid;
    }
 
    /* Identify support functions, if provided */
    if (rangeCanonicalName != NIL)
    {
        if (!OidIsValid(typoid))
            ereport(ERROR,
                    (errcode(ERRCODE_INVALID_OBJECT_DEFINITION),
                     errmsg("cannot specify a canonical function without a pre-created shell type"),
                     errhint("Create the type as a shell type, then create its canonicalization function, then do a full CREATE TYPE.")));
        rangeCanonical = findRangeCanonicalFunction(rangeCanonicalName,
                                                    typoid);
    }
    else
        rangeCanonical = InvalidOid;
 
    if (rangeSubtypeDiffName != NIL)
        rangeSubtypeDiff = findRangeSubtypeDiffFunction(rangeSubtypeDiffName,
                                                        rangeSubtype);
    else
        rangeSubtypeDiff = InvalidOid;
 
    get_typlenbyvalalign(rangeSubtype,
                         &subtyplen, &subtypbyval, &subtypalign);
 
    /* alignment must be TYPALIGN_INT or TYPALIGN_DOUBLE for ranges */
    alignment = (subtypalign == TYPALIGN_DOUBLE) ? TYPALIGN_DOUBLE : TYPALIGN_INT;
 
    /* Allocate OID for array type, its multirange, and its multirange array */
    rangeArrayOid = AssignTypeArrayOid();
    multirangeOid = AssignTypeMultirangeOid();
    multirangeArrayOid = AssignTypeMultirangeArrayOid();
 
    /* Create the pg_type entry */
    address =
        TypeCreate(InvalidOid,  /* no predetermined type OID */
                   typeName,    /* type name */
                   typeNamespace,   /* namespace */
                   InvalidOid,  /* relation oid (n/a here) */
                   0,           /* relation kind (ditto) */
                   GetUserId(), /* owner's ID */
                   -1,          /* internal size (always varlena) */
                   TYPTYPE_RANGE,   /* type-type (range type) */
                   TYPCATEGORY_RANGE,   /* type-category (range type) */
                   false,       /* range types are never preferred */
                   DEFAULT_TYPDELIM,    /* array element delimiter */
                   F_RANGE_IN,  /* input procedure */
                   F_RANGE_OUT, /* output procedure */
                   F_RANGE_RECV,    /* receive procedure */
                   F_RANGE_SEND,    /* send procedure */
                   InvalidOid,  /* typmodin procedure - none */
                   InvalidOid,  /* typmodout procedure - none */
                   F_RANGE_TYPANALYZE,  /* analyze procedure */
                   InvalidOid,  /* subscript procedure - none */
                   InvalidOid,  /* element type ID - none */
                   false,       /* this is not an array type */
                   rangeArrayOid,   /* array type we are about to create */
                   InvalidOid,  /* base type ID (only for domains) */
                   NULL,        /* never a default type value */
                   NULL,        /* no binary form available either */
                   false,       /* never passed by value */
                   alignment,   /* alignment */
                   TYPSTORAGE_EXTENDED, /* TOAST strategy (always extended) */
                   -1,          /* typMod (Domains only) */
                   0,           /* Array dimensions of typbasetype */
                   false,       /* Type NOT NULL */
                   InvalidOid); /* type's collation (ranges never have one) */
    Assert(typoid == InvalidOid || typoid == address.objectId);
    typoid = address.objectId;
 
    /* Create the multirange that goes with it */
    if (multirangeTypeName)
    {
        Oid         old_typoid;
 
        /*
         * Look to see if multirange type already exists.
         */
        old_typoid = GetSysCacheOid2(TYPENAMENSP, Anum_pg_type_oid,
                                     CStringGetDatum(multirangeTypeName),
                                     ObjectIdGetDatum(multirangeNamespace));
 
        /*
         * If it's not a shell, see if it's an autogenerated array type, and
         * if so rename it out of the way.
         */
        if (OidIsValid(old_typoid) && get_typisdefined(old_typoid))
        {
            if (!moveArrayTypeName(old_typoid, multirangeTypeName, multirangeNamespace))
                ereport(ERROR,
                        (errcode(ERRCODE_DUPLICATE_OBJECT),
                         errmsg("type \"%s\" already exists", multirangeTypeName)));
        }
    }
    else
    {
        /* Generate multirange name automatically */
        multirangeNamespace = typeNamespace;
        multirangeTypeName = makeMultirangeTypeName(typeName, multirangeNamespace);
    }
 
    mltrngaddress =
        TypeCreate(multirangeOid,   /* force assignment of this type OID */
                   multirangeTypeName,  /* type name */
                   multirangeNamespace, /* namespace */
                   InvalidOid,  /* relation oid (n/a here) */
                   0,           /* relation kind (ditto) */
                   GetUserId(), /* owner's ID */
                   -1,          /* internal size (always varlena) */
                   TYPTYPE_MULTIRANGE,  /* type-type (multirange type) */
                   TYPCATEGORY_RANGE,   /* type-category (range type) */
                   false,       /* multirange types are never preferred */
                   DEFAULT_TYPDELIM,    /* array element delimiter */
                   F_MULTIRANGE_IN, /* input procedure */
                   F_MULTIRANGE_OUT,    /* output procedure */
                   F_MULTIRANGE_RECV,   /* receive procedure */
                   F_MULTIRANGE_SEND,   /* send procedure */
                   InvalidOid,  /* typmodin procedure - none */
                   InvalidOid,  /* typmodout procedure - none */
                   F_MULTIRANGE_TYPANALYZE, /* analyze procedure */
                   InvalidOid,  /* subscript procedure - none */
                   InvalidOid,  /* element type ID - none */
                   false,       /* this is not an array type */
                   multirangeArrayOid,  /* array type we are about to create */
                   InvalidOid,  /* base type ID (only for domains) */
                   NULL,        /* never a default type value */
                   NULL,        /* no binary form available either */
                   false,       /* never passed by value */
                   alignment,   /* alignment */
                   'x',         /* TOAST strategy (always extended) */
                   -1,          /* typMod (Domains only) */
                   0,           /* Array dimensions of typbasetype */
                   false,       /* Type NOT NULL */
                   InvalidOid); /* type's collation (ranges never have one) */
    Assert(multirangeOid == mltrngaddress.objectId);
 
    /* Create the entry in pg_range */
    RangeCreate(typoid, rangeSubtype, rangeCollation, rangeSubOpclass,
                rangeCanonical, rangeSubtypeDiff, multirangeOid);
 
    /*
     * Create the array type that goes with it.
     */
    rangeArrayName = makeArrayTypeName(typeName, typeNamespace);
 
    TypeCreate(rangeArrayOid,   /* force assignment of this type OID */
               rangeArrayName,  /* type name */
               typeNamespace,   /* namespace */
               InvalidOid,      /* relation oid (n/a here) */
               0,               /* relation kind (ditto) */
               GetUserId(),     /* owner's ID */
               -1,              /* internal size (always varlena) */
               TYPTYPE_BASE,    /* type-type (base type) */
               TYPCATEGORY_ARRAY,   /* type-category (array) */
               false,           /* array types are never preferred */
               DEFAULT_TYPDELIM,    /* array element delimiter */
               F_ARRAY_IN,      /* input procedure */
               F_ARRAY_OUT,     /* output procedure */
               F_ARRAY_RECV,    /* receive procedure */
               F_ARRAY_SEND,    /* send procedure */
               InvalidOid,      /* typmodin procedure - none */
               InvalidOid,      /* typmodout procedure - none */
               F_ARRAY_TYPANALYZE,  /* analyze procedure */
               F_ARRAY_SUBSCRIPT_HANDLER,   /* array subscript procedure */
               typoid,          /* element type ID */
               true,            /* yes this is an array type */
               InvalidOid,      /* no further array type */
               InvalidOid,      /* base type ID */
               NULL,            /* never a default type value */
               NULL,            /* binary default isn't sent either */
               false,           /* never passed by value */
               alignment,       /* alignment - same as range's */
               TYPSTORAGE_EXTENDED, /* ARRAY is always toastable */
               -1,              /* typMod (Domains only) */
               0,               /* Array dimensions of typbasetype */
               false,           /* Type NOT NULL */
               InvalidOid);     /* typcollation */
 
    pfree(rangeArrayName);
 
    /* Create the multirange's array type */
 
    multirangeArrayName = makeArrayTypeName(multirangeTypeName, typeNamespace);
 
    TypeCreate(multirangeArrayOid,  /* force assignment of this type OID */
               multirangeArrayName, /* type name */
               multirangeNamespace, /* namespace */
               InvalidOid,      /* relation oid (n/a here) */
               0,               /* relation kind (ditto) */
               GetUserId(),     /* owner's ID */
               -1,              /* internal size (always varlena) */
               TYPTYPE_BASE,    /* type-type (base type) */
               TYPCATEGORY_ARRAY,   /* type-category (array) */
               false,           /* array types are never preferred */
               DEFAULT_TYPDELIM,    /* array element delimiter */
               F_ARRAY_IN,      /* input procedure */
               F_ARRAY_OUT,     /* output procedure */
               F_ARRAY_RECV,    /* receive procedure */
               F_ARRAY_SEND,    /* send procedure */
               InvalidOid,      /* typmodin procedure - none */
               InvalidOid,      /* typmodout procedure - none */
               F_ARRAY_TYPANALYZE,  /* analyze procedure */
               F_ARRAY_SUBSCRIPT_HANDLER,   /* array subscript procedure */
               multirangeOid,   /* element type ID */
               true,            /* yes this is an array type */
               InvalidOid,      /* no further array type */
               InvalidOid,      /* base type ID */
               NULL,            /* never a default type value */
               NULL,            /* binary default isn't sent either */
               false,           /* never passed by value */
               alignment,       /* alignment - same as range's */
               'x',             /* ARRAY is always toastable */
               -1,              /* typMod (Domains only) */
               0,               /* Array dimensions of typbasetype */
               false,           /* Type NOT NULL */
               InvalidOid);     /* typcollation */
 
    /* And create the constructor functions for this range type */
    makeRangeConstructors(typeName, typeNamespace, typoid, rangeSubtype);
    makeMultirangeConstructors(multirangeTypeName, typeNamespace,
                               multirangeOid, typoid, rangeArrayOid,
                               &castFuncOid);
 
    /* Create cast from the range type to its multirange type */
    CastCreate(typoid, multirangeOid, castFuncOid, InvalidOid, InvalidOid,
               COERCION_CODE_EXPLICIT, COERCION_METHOD_FUNCTION,
               DEPENDENCY_INTERNAL);
 
    pfree(multirangeArrayName);
 
    return address;
}

References ACL_CREATE, aclcheck_error(), ACLCHECK_OK, Assert, AssignTypeArrayOid(), AssignTypeMultirangeArrayOid(), AssignTypeMultirangeOid(), CastCreate(), CStringGetDatum(), DEFAULT_TYPDELIM, defGetQualifiedName(), defGetTypeName(), DefElem::defname, DEPENDENCY_INTERNAL, ereport, errcode(), ERRCODE_DUPLICATE_OBJECT, errhint(), errmsg(), ERROR, errorConflictingDefElem(), findRangeCanonicalFunction(), findRangeSubOpclass(), findRangeSubtypeDiffFunction(), format_type_be(), get_collation_oid(), get_namespace_name(), get_typcollation(), get_typisdefined(), get_typlenbyvalalign(), get_typtype(), GetSysCacheOid2, GetUserId(), InvalidOid, lfirst, makeArrayTypeName(), makeMultirangeConstructors(), makeMultirangeTypeName(), makeRangeConstructors(), moveArrayTypeName(), NIL, object_aclcheck(), OBJECT_SCHEMA, ObjectAddress::objectId, ObjectIdGetDatum(), OidIsValid, pfree(), PG_USED_FOR_ASSERTS_ONLY, QualifiedNameGetCreationNamespace(), RangeCreate(), stmt, type_is_collatable(), TypeCreate(), and typenameTypeId().

Referenced by ProcessUtilitySlow().

DefineType()

ObjectAddress DefineType	(	ParseState *	pstate,
		List *	names,
		List *	parameters
	)

Definition at line 152 of file typecmds.c.

{
    char       *typeName;
    Oid         typeNamespace;
    int16       internalLength = -1;    /* default: variable-length */
    List       *inputName = NIL;
    List       *outputName = NIL;
    List       *receiveName = NIL;
    List       *sendName = NIL;
    List       *typmodinName = NIL;
    List       *typmodoutName = NIL;
    List       *analyzeName = NIL;
    List       *subscriptName = NIL;
    char        category = TYPCATEGORY_USER;
    bool        preferred = false;
    char        delimiter = DEFAULT_TYPDELIM;
    Oid         elemType = InvalidOid;
    char       *defaultValue = NULL;
    bool        byValue = false;
    char        alignment = TYPALIGN_INT;   /* default alignment */
    char        storage = TYPSTORAGE_PLAIN; /* default TOAST storage method */
    Oid         collation = InvalidOid;
    DefElem    *likeTypeEl = NULL;
    DefElem    *internalLengthEl = NULL;
    DefElem    *inputNameEl = NULL;
    DefElem    *outputNameEl = NULL;
    DefElem    *receiveNameEl = NULL;
    DefElem    *sendNameEl = NULL;
    DefElem    *typmodinNameEl = NULL;
    DefElem    *typmodoutNameEl = NULL;
    DefElem    *analyzeNameEl = NULL;
    DefElem    *subscriptNameEl = NULL;
    DefElem    *categoryEl = NULL;
    DefElem    *preferredEl = NULL;
    DefElem    *delimiterEl = NULL;
    DefElem    *elemTypeEl = NULL;
    DefElem    *defaultValueEl = NULL;
    DefElem    *byValueEl = NULL;
    DefElem    *alignmentEl = NULL;
    DefElem    *storageEl = NULL;
    DefElem    *collatableEl = NULL;
    Oid         inputOid;
    Oid         outputOid;
    Oid         receiveOid = InvalidOid;
    Oid         sendOid = InvalidOid;
    Oid         typmodinOid = InvalidOid;
    Oid         typmodoutOid = InvalidOid;
    Oid         analyzeOid = InvalidOid;
    Oid         subscriptOid = InvalidOid;
    char       *array_type;
    Oid         array_oid;
    Oid         typoid;
    ListCell   *pl;
    ObjectAddress address;
 
    /*
     * As of Postgres 8.4, we require superuser privilege to create a base
     * type.  This is simple paranoia: there are too many ways to mess up the
     * system with an incorrect type definition (for instance, representation
     * parameters that don't match what the C code expects).  In practice it
     * takes superuser privilege to create the I/O functions, and so the
     * former requirement that you own the I/O functions pretty much forced
     * superuserness anyway.  We're just making doubly sure here.
     *
     * XXX re-enable NOT_USED code sections below if you remove this test.
     */
    if (!superuser())
        ereport(ERROR,
                (errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
                 errmsg("must be superuser to create a base type")));
 
    /* Convert list of names to a name and namespace */
    typeNamespace = QualifiedNameGetCreationNamespace(names, &typeName);
 
#ifdef NOT_USED
    /* XXX this is unnecessary given the superuser check above */
    /* Check we have creation rights in target namespace */
    aclresult = object_aclcheck(NamespaceRelationId, typeNamespace, GetUserId(), ACL_CREATE);
    if (aclresult != ACLCHECK_OK)
        aclcheck_error(aclresult, OBJECT_SCHEMA,
                       get_namespace_name(typeNamespace));
#endif
 
    /*
     * Look to see if type already exists.
     */
    typoid = GetSysCacheOid2(TYPENAMENSP, Anum_pg_type_oid,
                             CStringGetDatum(typeName),
                             ObjectIdGetDatum(typeNamespace));
 
    /*
     * If it's not a shell, see if it's an autogenerated array type, and if so
     * rename it out of the way.
     */
    if (OidIsValid(typoid) && get_typisdefined(typoid))
    {
        if (moveArrayTypeName(typoid, typeName, typeNamespace))
            typoid = InvalidOid;
        else
            ereport(ERROR,
                    (errcode(ERRCODE_DUPLICATE_OBJECT),
                     errmsg("type \"%s\" already exists", typeName)));
    }
 
    /*
     * If this command is a parameterless CREATE TYPE, then we're just here to
     * make a shell type, so do that (or fail if there already is a shell).
     */
    if (parameters == NIL)
    {
        if (OidIsValid(typoid))
            ereport(ERROR,
                    (errcode(ERRCODE_DUPLICATE_OBJECT),
                     errmsg("type \"%s\" already exists", typeName)));
 
        address = TypeShellMake(typeName, typeNamespace, GetUserId());
        return address;
    }
 
    /*
     * Otherwise, we must already have a shell type, since there is no other
     * way that the I/O functions could have been created.
     */
    if (!OidIsValid(typoid))
        ereport(ERROR,
                (errcode(ERRCODE_DUPLICATE_OBJECT),
                 errmsg("type \"%s\" does not exist", typeName),
                 errhint("Create the type as a shell type, then create its I/O functions, then do a full CREATE TYPE.")));
 
    /* Extract the parameters from the parameter list */
    foreach(pl, parameters)
    {
        DefElem    *defel = (DefElem *) lfirst(pl);
        DefElem   **defelp;
 
        if (strcmp(defel->defname, "like") == 0)
            defelp = &likeTypeEl;
        else if (strcmp(defel->defname, "internallength") == 0)
            defelp = &internalLengthEl;
        else if (strcmp(defel->defname, "input") == 0)
            defelp = &inputNameEl;
        else if (strcmp(defel->defname, "output") == 0)
            defelp = &outputNameEl;
        else if (strcmp(defel->defname, "receive") == 0)
            defelp = &receiveNameEl;
        else if (strcmp(defel->defname, "send") == 0)
            defelp = &sendNameEl;
        else if (strcmp(defel->defname, "typmod_in") == 0)
            defelp = &typmodinNameEl;
        else if (strcmp(defel->defname, "typmod_out") == 0)
            defelp = &typmodoutNameEl;
        else if (strcmp(defel->defname, "analyze") == 0 ||
                 strcmp(defel->defname, "analyse") == 0)
            defelp = &analyzeNameEl;
        else if (strcmp(defel->defname, "subscript") == 0)
            defelp = &subscriptNameEl;
        else if (strcmp(defel->defname, "category") == 0)
            defelp = &categoryEl;
        else if (strcmp(defel->defname, "preferred") == 0)
            defelp = &preferredEl;
        else if (strcmp(defel->defname, "delimiter") == 0)
            defelp = &delimiterEl;
        else if (strcmp(defel->defname, "element") == 0)
            defelp = &elemTypeEl;
        else if (strcmp(defel->defname, "default") == 0)
            defelp = &defaultValueEl;
        else if (strcmp(defel->defname, "passedbyvalue") == 0)
            defelp = &byValueEl;
        else if (strcmp(defel->defname, "alignment") == 0)
            defelp = &alignmentEl;
        else if (strcmp(defel->defname, "storage") == 0)
            defelp = &storageEl;
        else if (strcmp(defel->defname, "collatable") == 0)
            defelp = &collatableEl;
        else
        {
            /* WARNING, not ERROR, for historical backwards-compatibility */
            ereport(WARNING,
                    (errcode(ERRCODE_SYNTAX_ERROR),
                     errmsg("type attribute \"%s\" not recognized",
                            defel->defname),
                     parser_errposition(pstate, defel->location)));
            continue;
        }
        if (*defelp != NULL)
            errorConflictingDefElem(defel, pstate);
        *defelp = defel;
    }
 
    /*
     * Now interpret the options; we do this separately so that LIKE can be
     * overridden by other options regardless of the ordering in the parameter
     * list.
     */
    if (likeTypeEl)
    {
        Type        likeType;
        Form_pg_type likeForm;
 
        likeType = typenameType(NULL, defGetTypeName(likeTypeEl), NULL);
        likeForm = (Form_pg_type) GETSTRUCT(likeType);
        internalLength = likeForm->typlen;
        byValue = likeForm->typbyval;
        alignment = likeForm->typalign;
        storage = likeForm->typstorage;
        ReleaseSysCache(likeType);
    }
    if (internalLengthEl)
        internalLength = defGetTypeLength(internalLengthEl);
    if (inputNameEl)
        inputName = defGetQualifiedName(inputNameEl);
    if (outputNameEl)
        outputName = defGetQualifiedName(outputNameEl);
    if (receiveNameEl)
        receiveName = defGetQualifiedName(receiveNameEl);
    if (sendNameEl)
        sendName = defGetQualifiedName(sendNameEl);
    if (typmodinNameEl)
        typmodinName = defGetQualifiedName(typmodinNameEl);
    if (typmodoutNameEl)
        typmodoutName = defGetQualifiedName(typmodoutNameEl);
    if (analyzeNameEl)
        analyzeName = defGetQualifiedName(analyzeNameEl);
    if (subscriptNameEl)
        subscriptName = defGetQualifiedName(subscriptNameEl);
    if (categoryEl)
    {
        char       *p = defGetString(categoryEl);
 
        category = p[0];
        /* restrict to non-control ASCII */
        if (category < 32 || category > 126)
            ereport(ERROR,
                    (errcode(ERRCODE_INVALID_PARAMETER_VALUE),
                     errmsg("invalid type category \"%s\": must be simple ASCII",
                            p)));
    }
    if (preferredEl)
        preferred = defGetBoolean(preferredEl);
    if (delimiterEl)
    {
        char       *p = defGetString(delimiterEl);
 
        delimiter = p[0];
        /* XXX shouldn't we restrict the delimiter? */
    }
    if (elemTypeEl)
    {
        elemType = typenameTypeId(NULL, defGetTypeName(elemTypeEl));
        /* disallow arrays of pseudotypes */
        if (get_typtype(elemType) == TYPTYPE_PSEUDO)
            ereport(ERROR,
                    (errcode(ERRCODE_DATATYPE_MISMATCH),
                     errmsg("array element type cannot be %s",
                            format_type_be(elemType))));
    }
    if (defaultValueEl)
        defaultValue = defGetString(defaultValueEl);
    if (byValueEl)
        byValue = defGetBoolean(byValueEl);
    if (alignmentEl)
    {
        char       *a = defGetString(alignmentEl);
 
        /*
         * Note: if argument was an unquoted identifier, parser will have
         * applied translations to it, so be prepared to recognize translated
         * type names as well as the nominal form.
         */
        if (pg_strcasecmp(a, "double") == 0 ||
            pg_strcasecmp(a, "float8") == 0 ||
            pg_strcasecmp(a, "pg_catalog.float8") == 0)
            alignment = TYPALIGN_DOUBLE;
        else if (pg_strcasecmp(a, "int4") == 0 ||
                 pg_strcasecmp(a, "pg_catalog.int4") == 0)
            alignment = TYPALIGN_INT;
        else if (pg_strcasecmp(a, "int2") == 0 ||
                 pg_strcasecmp(a, "pg_catalog.int2") == 0)
            alignment = TYPALIGN_SHORT;
        else if (pg_strcasecmp(a, "char") == 0 ||
                 pg_strcasecmp(a, "pg_catalog.bpchar") == 0)
            alignment = TYPALIGN_CHAR;
        else
            ereport(ERROR,
                    (errcode(ERRCODE_INVALID_PARAMETER_VALUE),
                     errmsg("alignment \"%s\" not recognized", a)));
    }
    if (storageEl)
    {
        char       *a = defGetString(storageEl);
 
        if (pg_strcasecmp(a, "plain") == 0)
            storage = TYPSTORAGE_PLAIN;
        else if (pg_strcasecmp(a, "external") == 0)
            storage = TYPSTORAGE_EXTERNAL;
        else if (pg_strcasecmp(a, "extended") == 0)
            storage = TYPSTORAGE_EXTENDED;
        else if (pg_strcasecmp(a, "main") == 0)
            storage = TYPSTORAGE_MAIN;
        else
            ereport(ERROR,
                    (errcode(ERRCODE_INVALID_PARAMETER_VALUE),
                     errmsg("storage \"%s\" not recognized", a)));
    }
    if (collatableEl)
        collation = defGetBoolean(collatableEl) ? DEFAULT_COLLATION_OID : InvalidOid;
 
    /*
     * make sure we have our required definitions
     */
    if (inputName == NIL)
        ereport(ERROR,
                (errcode(ERRCODE_INVALID_OBJECT_DEFINITION),
                 errmsg("type input function must be specified")));
    if (outputName == NIL)
        ereport(ERROR,
                (errcode(ERRCODE_INVALID_OBJECT_DEFINITION),
                 errmsg("type output function must be specified")));
 
    if (typmodinName == NIL && typmodoutName != NIL)
        ereport(ERROR,
                (errcode(ERRCODE_INVALID_OBJECT_DEFINITION),
                 errmsg("type modifier output function is useless without a type modifier input function")));
 
    /*
     * Convert I/O proc names to OIDs
     */
    inputOid = findTypeInputFunction(inputName, typoid);
    outputOid = findTypeOutputFunction(outputName, typoid);
    if (receiveName)
        receiveOid = findTypeReceiveFunction(receiveName, typoid);
    if (sendName)
        sendOid = findTypeSendFunction(sendName, typoid);
 
    /*
     * Convert typmodin/out function proc names to OIDs.
     */
    if (typmodinName)
        typmodinOid = findTypeTypmodinFunction(typmodinName);
    if (typmodoutName)
        typmodoutOid = findTypeTypmodoutFunction(typmodoutName);
 
    /*
     * Convert analysis function proc name to an OID. If no analysis function
     * is specified, we'll use zero to select the built-in default algorithm.
     */
    if (analyzeName)
        analyzeOid = findTypeAnalyzeFunction(analyzeName, typoid);
 
    /*
     * Likewise look up the subscripting function if any.  If it is not
     * specified, but a typelem is specified, allow that if
     * raw_array_subscript_handler can be used.  (This is for backwards
     * compatibility; maybe someday we should throw an error instead.)
     */
    if (subscriptName)
        subscriptOid = findTypeSubscriptingFunction(subscriptName, typoid);
    else if (OidIsValid(elemType))
    {
        if (internalLength > 0 && !byValue && get_typlen(elemType) > 0)
            subscriptOid = F_RAW_ARRAY_SUBSCRIPT_HANDLER;
        else
            ereport(ERROR,
                    (errcode(ERRCODE_INVALID_PARAMETER_VALUE),
                     errmsg("element type cannot be specified without a subscripting function")));
    }
 
    /*
     * Check permissions on functions.  We choose to require the creator/owner
     * of a type to also own the underlying functions.  Since creating a type
     * is tantamount to granting public execute access on the functions, the
     * minimum sane check would be for execute-with-grant-option.  But we
     * don't have a way to make the type go away if the grant option is
     * revoked, so ownership seems better.
     *
     * XXX For now, this is all unnecessary given the superuser check above.
     * If we ever relax that, these calls likely should be moved into
     * findTypeInputFunction et al, where they could be shared by AlterType.
     */
#ifdef NOT_USED
    if (inputOid && !object_ownercheck(ProcedureRelationId, inputOid, GetUserId()))
        aclcheck_error(ACLCHECK_NOT_OWNER, OBJECT_FUNCTION,
                       NameListToString(inputName));
    if (outputOid && !object_ownercheck(ProcedureRelationId, outputOid, GetUserId()))
        aclcheck_error(ACLCHECK_NOT_OWNER, OBJECT_FUNCTION,
                       NameListToString(outputName));
    if (receiveOid && !object_ownercheck(ProcedureRelationId, receiveOid, GetUserId()))
        aclcheck_error(ACLCHECK_NOT_OWNER, OBJECT_FUNCTION,
                       NameListToString(receiveName));
    if (sendOid && !object_ownercheck(ProcedureRelationId, sendOid, GetUserId()))
        aclcheck_error(ACLCHECK_NOT_OWNER, OBJECT_FUNCTION,
                       NameListToString(sendName));
    if (typmodinOid && !object_ownercheck(ProcedureRelationId, typmodinOid, GetUserId()))
        aclcheck_error(ACLCHECK_NOT_OWNER, OBJECT_FUNCTION,
                       NameListToString(typmodinName));
    if (typmodoutOid && !object_ownercheck(ProcedureRelationId, typmodoutOid, GetUserId()))
        aclcheck_error(ACLCHECK_NOT_OWNER, OBJECT_FUNCTION,
                       NameListToString(typmodoutName));
    if (analyzeOid && !object_ownercheck(ProcedureRelationId, analyzeOid, GetUserId()))
        aclcheck_error(ACLCHECK_NOT_OWNER, OBJECT_FUNCTION,
                       NameListToString(analyzeName));
    if (subscriptOid && !object_ownercheck(ProcedureRelationId, subscriptOid, GetUserId()))
        aclcheck_error(ACLCHECK_NOT_OWNER, OBJECT_FUNCTION,
                       NameListToString(subscriptName));
#endif
 
    /*
     * OK, we're done checking, time to make the type.  We must assign the
     * array type OID ahead of calling TypeCreate, since the base type and
     * array type each refer to the other.
     */
    array_oid = AssignTypeArrayOid();
 
    /*
     * now have TypeCreate do all the real work.
     *
     * Note: the pg_type.oid is stored in user tables as array elements (base
     * types) in ArrayType and in composite types in DatumTupleFields.  This
     * oid must be preserved by binary upgrades.
     */
    address =
        TypeCreate(InvalidOid,  /* no predetermined type OID */
                   typeName,    /* type name */
                   typeNamespace,   /* namespace */
                   InvalidOid,  /* relation oid (n/a here) */
                   0,           /* relation kind (ditto) */
                   GetUserId(), /* owner's ID */
                   internalLength,  /* internal size */
                   TYPTYPE_BASE,    /* type-type (base type) */
                   category,    /* type-category */
                   preferred,   /* is it a preferred type? */
                   delimiter,   /* array element delimiter */
                   inputOid,    /* input procedure */
                   outputOid,   /* output procedure */
                   receiveOid,  /* receive procedure */
                   sendOid,     /* send procedure */
                   typmodinOid, /* typmodin procedure */
                   typmodoutOid,    /* typmodout procedure */
                   analyzeOid,  /* analyze procedure */
                   subscriptOid,    /* subscript procedure */
                   elemType,    /* element type ID */
                   false,       /* this is not an implicit array type */
                   array_oid,   /* array type we are about to create */
                   InvalidOid,  /* base type ID (only for domains) */
                   defaultValue,    /* default type value */
                   NULL,        /* no binary form available */
                   byValue,     /* passed by value */
                   alignment,   /* required alignment */
                   storage,     /* TOAST strategy */
                   -1,          /* typMod (Domains only) */
                   0,           /* Array Dimensions of typbasetype */
                   false,       /* Type NOT NULL */
                   collation);  /* type's collation */
    Assert(typoid == address.objectId);
 
    /*
     * Create the array type that goes with it.
     */
    array_type = makeArrayTypeName(typeName, typeNamespace);
 
    /* alignment must be TYPALIGN_INT or TYPALIGN_DOUBLE for arrays */
    alignment = (alignment == TYPALIGN_DOUBLE) ? TYPALIGN_DOUBLE : TYPALIGN_INT;
 
    TypeCreate(array_oid,       /* force assignment of this type OID */
               array_type,      /* type name */
               typeNamespace,   /* namespace */
               InvalidOid,      /* relation oid (n/a here) */
               0,               /* relation kind (ditto) */
               GetUserId(),     /* owner's ID */
               -1,              /* internal size (always varlena) */
               TYPTYPE_BASE,    /* type-type (base type) */
               TYPCATEGORY_ARRAY,   /* type-category (array) */
               false,           /* array types are never preferred */
               delimiter,       /* array element delimiter */
               F_ARRAY_IN,      /* input procedure */
               F_ARRAY_OUT,     /* output procedure */
               F_ARRAY_RECV,    /* receive procedure */
               F_ARRAY_SEND,    /* send procedure */
               typmodinOid,     /* typmodin procedure */
               typmodoutOid,    /* typmodout procedure */
               F_ARRAY_TYPANALYZE,  /* analyze procedure */
               F_ARRAY_SUBSCRIPT_HANDLER,   /* array subscript procedure */
               typoid,          /* element type ID */
               true,            /* yes this is an array type */
               InvalidOid,      /* no further array type */
               InvalidOid,      /* base type ID */
               NULL,            /* never a default type value */
               NULL,            /* binary default isn't sent either */
               false,           /* never passed by value */
               alignment,       /* see above */
               TYPSTORAGE_EXTENDED, /* ARRAY is always toastable */
               -1,              /* typMod (Domains only) */
               0,               /* Array dimensions of typbasetype */
               false,           /* Type NOT NULL */
               collation);      /* type's collation */
 
    pfree(array_type);
 
    return address;
}

References a, ACL_CREATE, aclcheck_error(), ACLCHECK_NOT_OWNER, ACLCHECK_OK, Assert, AssignTypeArrayOid(), CStringGetDatum(), DEFAULT_TYPDELIM, defGetBoolean(), defGetQualifiedName(), defGetString(), defGetTypeLength(), defGetTypeName(), DefElem::defname, ereport, errcode(), ERRCODE_DUPLICATE_OBJECT, errhint(), errmsg(), ERROR, errorConflictingDefElem(), findTypeAnalyzeFunction(), findTypeInputFunction(), findTypeOutputFunction(), findTypeReceiveFunction(), findTypeSendFunction(), findTypeSubscriptingFunction(), findTypeTypmodinFunction(), findTypeTypmodoutFunction(), format_type_be(), get_namespace_name(), get_typisdefined(), get_typlen(), get_typtype(), GETSTRUCT, GetSysCacheOid2, GetUserId(), InvalidOid, lfirst, DefElem::location, makeArrayTypeName(), moveArrayTypeName(), NameListToString(), NIL, object_aclcheck(), OBJECT_FUNCTION, object_ownercheck(), OBJECT_SCHEMA, ObjectAddress::objectId, ObjectIdGetDatum(), OidIsValid, parser_errposition(), pfree(), pg_strcasecmp(), QualifiedNameGetCreationNamespace(), ReleaseSysCache(), storage, superuser(), TypeCreate(), typenameType(), typenameTypeId(), TypeShellMake(), and WARNING.

Referenced by ProcessUtilitySlow().

RemoveTypeById()

void RemoveTypeById

(

Oid

typeOid

)

Definition at line 657 of file typecmds.c.

{
    Relation    relation;
    HeapTuple   tup;
 
    relation = table_open(TypeRelationId, RowExclusiveLock);
 
    tup = SearchSysCache1(TYPEOID, ObjectIdGetDatum(typeOid));
    if (!HeapTupleIsValid(tup))
        elog(ERROR, "cache lookup failed for type %u", typeOid);
 
    CatalogTupleDelete(relation, &tup->t_self);
 
    /*
     * If it is an enum, delete the pg_enum entries too; we don't bother with
     * making dependency entries for those, so it has to be done "by hand"
     * here.
     */
    if (((Form_pg_type) GETSTRUCT(tup))->typtype == TYPTYPE_ENUM)
        EnumValuesDelete(typeOid);
 
    /*
     * If it is a range type, delete the pg_range entry too; we don't bother
     * with making a dependency entry for that, so it has to be done "by hand"
     * here.
     */
    if (((Form_pg_type) GETSTRUCT(tup))->typtype == TYPTYPE_RANGE)
        RangeDelete(typeOid);
 
    ReleaseSysCache(tup);
 
    table_close(relation, RowExclusiveLock);
}

References CatalogTupleDelete(), elog, EnumValuesDelete(), ERROR, GETSTRUCT, HeapTupleIsValid, ObjectIdGetDatum(), RangeDelete(), ReleaseSysCache(), RowExclusiveLock, SearchSysCache1(), HeapTupleData::t_self, table_close(), and table_open().

Referenced by doDeletion().

RenameType()

ObjectAddress RenameType

(

RenameStmt *

stmt

)

Definition at line 3751 of file typecmds.c.

{
    List       *names = castNode(List, stmt->object);
    const char *newTypeName = stmt->newname;
    TypeName   *typename;
    Oid         typeOid;
    Relation    rel;
    HeapTuple   tup;
    Form_pg_type typTup;
    ObjectAddress address;
 
    /* Make a TypeName so we can use standard type lookup machinery */
    typename = makeTypeNameFromNameList(names);
    typeOid = typenameTypeId(NULL, typename);
 
    /* Look up the type in the type table */
    rel = table_open(TypeRelationId, RowExclusiveLock);
 
    tup = SearchSysCacheCopy1(TYPEOID, ObjectIdGetDatum(typeOid));
    if (!HeapTupleIsValid(tup))
        elog(ERROR, "cache lookup failed for type %u", typeOid);
    typTup = (Form_pg_type) GETSTRUCT(tup);
 
    /* check permissions on type */
    if (!object_ownercheck(TypeRelationId, typeOid, GetUserId()))
        aclcheck_error_type(ACLCHECK_NOT_OWNER, typeOid);
 
    /* ALTER DOMAIN used on a non-domain? */
    if (stmt->renameType == OBJECT_DOMAIN && typTup->typtype != TYPTYPE_DOMAIN)
        ereport(ERROR,
                (errcode(ERRCODE_WRONG_OBJECT_TYPE),
                 errmsg("%s is not a domain",
                        format_type_be(typeOid))));
 
    /*
     * If it's a composite type, we need to check that it really is a
     * free-standing composite type, and not a table's rowtype. We want people
     * to use ALTER TABLE not ALTER TYPE for that case.
     */
    if (typTup->typtype == TYPTYPE_COMPOSITE &&
        get_rel_relkind(typTup->typrelid) != RELKIND_COMPOSITE_TYPE)
        ereport(ERROR,
                (errcode(ERRCODE_WRONG_OBJECT_TYPE),
                 errmsg("%s is a table's row type",
                        format_type_be(typeOid)),
        /* translator: %s is an SQL ALTER command */
                 errhint("Use %s instead.",
                         "ALTER TABLE")));
 
    /* don't allow direct alteration of array types, either */
    if (IsTrueArrayType(typTup))
        ereport(ERROR,
                (errcode(ERRCODE_WRONG_OBJECT_TYPE),
                 errmsg("cannot alter array type %s",
                        format_type_be(typeOid)),
                 errhint("You can alter type %s, which will alter the array type as well.",
                         format_type_be(typTup->typelem))));
 
    /* we do allow separate renaming of multirange types, though */
 
    /*
     * If type is composite we need to rename associated pg_class entry too.
     * RenameRelationInternal will call RenameTypeInternal automatically.
     */
    if (typTup->typtype == TYPTYPE_COMPOSITE)
        RenameRelationInternal(typTup->typrelid, newTypeName, false, false);
    else
        RenameTypeInternal(typeOid, newTypeName,
                           typTup->typnamespace);
 
    ObjectAddressSet(address, TypeRelationId, typeOid);
    /* Clean up */
    table_close(rel, RowExclusiveLock);
 
    return address;
}

References aclcheck_error_type(), ACLCHECK_NOT_OWNER, castNode, elog, ereport, errcode(), errhint(), errmsg(), ERROR, format_type_be(), get_rel_relkind(), GETSTRUCT, GetUserId(), HeapTupleIsValid, makeTypeNameFromNameList(), OBJECT_DOMAIN, object_ownercheck(), ObjectAddressSet, ObjectIdGetDatum(), RenameRelationInternal(), RenameTypeInternal(), RowExclusiveLock, SearchSysCacheCopy1, stmt, table_close(), table_open(), and typenameTypeId().

Referenced by ExecRenameStmt().