<!--

$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.117 2009/10/12 19:49:24 adunstan Exp $

$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.118 2009/10/13 00:53:07 tgl Exp $

PostgreSQL documentation

-->

</para>

<para>

Columnstorage parameters are also copied from parent tables.

Column<literal>STORAGE</> settings are also copied from parent tables.

</para>

<!--

specified.

</para>

<para>

Storage parameters for the copied column definitions will only be copied

if <literal>INCLUDING STORAGE</literal> is specified. The default

behavior is to exclude storage parameters, resulting in the copied

columns in the new table having type-specific default parameters. For

more on storage parameters, see <xref linkend="storage-toast">.

<literal>STORAGE</> settings for the copied column definitions will only

be copied if <literal>INCLUDING STORAGE</literal> is specified. The

default behavior is to exclude <literal>STORAGE</> settings, resulting

in the copied columns in the new table having type-specific default

settings. For more on <literal>STORAGE</> settings, see

<xref linkend="storage-toast">.

</para>

<para>

Comments for the copiedcolumn, constraint, indexandcolumns of index

definitions will only be copied if <literal>INCLUDING COMMENTS</literal>

is specified. The default behavior is to exclude comments, resulting in

the copied columns and constraints in the new table having no comments.

Comments for the copiedcolumns, constraints,andindexes

will only be copied if <literal>INCLUDING COMMENTS</literal>

is specified. The default behavior is to exclude comments, resulting in

the copied columns and constraints in the new table having no comments.

</para>

<para>

<literal>INCLUDING ALL</literal> is an abbreviated form of

<literal>INCLUDING DEFAULTS INCLUDING CONSTRAINTS INCLUDING INDEXES INCLUDING STORAGE INCLUDING COMMENTS</literal>.

</para>

<para>

Note also that unlike <literal>INHERITS</literal>, copied columns and

constraints are not merged with similarly named columns and constraints.

Note also that unlike <literal>INHERITS</literal>, columns and

constraints copied by <literal>LIKE</> are not merged with similarly

named columns and constraints.

If the same name is specified explicitly or in another

<literal>LIKE</literal> clause, an error is signalled.

</para>

<para>

Enables or disables the autovacuum daemon on a particular table.

If true, the autovacuum daemon will initiate a <command>VACUUM</> operation

on a particular table when the number of updated or deleted tuples exceeds

<literal>autovacuum_vacuum_threshold</> plus

<literal>autovacuum_vacuum_scale_factor</> times the number of live tuples

on a particular table when the number of updated or deleted tuples exceeds

<literal>autovacuum_vacuum_threshold</> plus

<literal>autovacuum_vacuum_scale_factor</> times the number of live tuples

currently estimated to be in the relation.

Similarly, it will initiate an <command>ANALYZE</> operation when the

number of inserted, updated or deleted tuples exceeds

<literal>autovacuum_analyze_threshold</> plus

<literal>autovacuum_analyze_scale_factor</> times the number of live tuples

<literal>autovacuum_analyze_threshold</> plus

<literal>autovacuum_analyze_scale_factor</> times the number of live tuples

currently estimated to be in the relation.

If false, this table will not be autovacuumed, except to prevent

transaction Id wraparound. See <xref linkend="vacuum-for-wraparound"> for

<listitem>

<para>

Minimum number of updated or deleted tuples before initiate a

<command>VACUUM</> operation on a particular table.

<command>VACUUM</> operation on a particular table.

</para>

</listitem>

</varlistentry>

<para>

Custom <xref linkend="guc-vacuum-freeze-min-age"> parameter. Note that

autovacuum will ignore attempts to set a per-table

<literal>autovacuum_freeze_min_age</> larger than the half system-wide

<literal>autovacuum_freeze_min_age</> larger than the half system-wide

<xref linkend="guc-autovacuum-freeze-max-age"> setting.

</para>

</listitem>

TupleDescInitEntry(desc,attnum,attname,

atttypid,atttypmod,attdim);

if (entry->storage)

desc->attrs[attnum-1]->attstorage=entry->storage;

desc->attrs[attnum-1]->attnotnull=entry->is_not_null;

has_not_null |=entry->is_not_null;

desc->attrs[attnum-1]->attislocal=entry->is_local;

desc->attrs[attnum-1]->attinhcount=entry->inhcount;

if (entry->storage)

desc->attrs[attnum-1]->attstorage=entry->storage;

}

if (has_not_null)

GetConstraintByName(Oidrelid,constchar*conname)

ScanKeyInit(&skey[0],

Anum_pg_constraint_conrelid,

BTEqualStrategyNumber,F_OIDEQ,relid);

BTEqualStrategyNumber,F_OIDEQ,

ObjectIdGetDatum(relid));

scan=systable_beginscan(pg_constraint,ConstraintRelidIndexId, true,

SnapshotNow,1,skey);

if (strcmp(NameStr(con->conname),conname)==0)

{

if (OidIsValid(conOid))

{

char*relname=get_rel_name(relid);

ereport(ERROR,

(errcode(ERRCODE_DUPLICATE_OBJECT),

errmsg("table \"%s\" has multiple constraints named \"%s\"",

(relname ?relname :"(unknown)"),conname)));

}

errmsg("table \"%s\" has multiple constraints named \"%s\"",

get_rel_name(relid),conname)));

conOid=HeapTupleGetOid(tuple);

}

}

systable_endscan(scan);

if (!OidIsValid(conOid))

{

char*relname=get_rel_name(relid);

ereport(ERROR,

(errcode(ERRCODE_UNDEFINED_OBJECT),

errmsg("constraint \"%s\" for table \"%s\" does not exist",

conname, (relname ?relname :"(unknown)"))));

}

conname,get_rel_name(relid))));

heap_close(pg_constraint,AccessShareLock);

coldef->inhcount=0;

coldef->is_local= true;

coldef->is_not_null= true;

coldef->storage=0;

coldef->raw_default=NULL;

coldef->cooked_default=NULL;

coldef->constraints=NIL;

staticvoidATExecDropInherit(Relationrel,RangeVar*parent);

staticvoidcopy_relation_data(SMgrRelationrel,SMgrRelationdst,

ForkNumberforkNum,boolistemp);

staticconstchar*storage_name(charc);

staticconstchar*storage_name(charc);

CheckTableNotInUse(rel,"TRUNCATE");

}

storage_name(charc)

{

switch (c)

{

case'p':return"PLAIN";

case'm':return"MAIN";

case'x':return"EXTENDED";

case'e':return"EXTERNAL";

default:return"???";

case'p':

return"PLAIN";

case'm':

return"MAIN";

case'x':

return"EXTENDED";

case'e':

return"EXTERNAL";

default:

return"???";

}

}

List*constraints=NIL;

intparentsWithOids=0;

boolhave_bogus_defaults= false;

boolhave_bogus_comments= false;

intchild_attno;

staticNodebogus_marker= {0 };/* marks conflicting defaults */

(errcode(ERRCODE_DATATYPE_MISMATCH),

errmsg("inherited column \"%s\" has a storage parameter conflict",

attributeName),

errdetail("%s versus %s",storage_name(def->storage),

errdetail("%s versus %s",

storage_name(def->storage),

storage_name(attribute->attstorage))));

def->inhcount++;

def->inhcount=1;

def->is_local= false;

def->is_not_null=attribute->attnotnull;

def->storage=attribute->attstorage;

def->raw_default=NULL;

def->cooked_default=NULL;

def->constraints=NIL;

def->storage=attribute->attstorage;

inhSchema=lappend(inhSchema,def);

newattno[parent_attno-1]=++child_attno;

}

(errcode(ERRCODE_DATATYPE_MISMATCH),

errmsg("column \"%s\" has a storage parameter conflict",

attributeName),

errdetail("%s versus %s",storage_name(def->storage),

errdetail("%s versus %s",

storage_name(def->storage),

storage_name(newdef->storage))));

}

}

if (have_bogus_comments)

{

foreach(entry,schema)

{

ColumnDef*def=lfirst(entry);

if (def->cooked_default==&bogus_marker)

ereport(ERROR,

(errcode(ERRCODE_INVALID_COLUMN_DEFINITION),

errmsg("column \"%s\" inherits conflicting comments",def->colname)));

}

}

*supOids=parentOids;

*supconstr=constraints;

*supOidCount=parentsWithOids;

cdef->inhcount=0;

cdef->is_local= true;

cdef->is_not_null= true;

cdef->storage=0;

cmd->def= (Node*)cdef;

}

ATPrepAddColumn(wqueue,rel,recurse,cmd);

def->inhcount=0;

def->is_local= true;

def->is_not_null= false;

def->storage=0;

def->raw_default=NULL;

def->cooked_default=NULL;

def->constraints=NIL;

COPY_SCALAR_FIELD(inhcount);

COPY_SCALAR_FIELD(is_local);

COPY_SCALAR_FIELD(is_not_null);

COPY_SCALAR_FIELD(storage);

COPY_NODE_FIELD(raw_default);

COPY_NODE_FIELD(cooked_default);

COPY_NODE_FIELD(constraints);

COMPARE_SCALAR_FIELD(inhcount);

COMPARE_SCALAR_FIELD(is_local);

COMPARE_SCALAR_FIELD(is_not_null);

COMPARE_SCALAR_FIELD(storage);

COMPARE_NODE_FIELD(raw_default);

COMPARE_NODE_FIELD(cooked_default);

COMPARE_NODE_FIELD(constraints);

WRITE_INT_FIELD(inhcount);

WRITE_BOOL_FIELD(is_local);

WRITE_BOOL_FIELD(is_not_null);

WRITE_INT_FIELD(storage);

WRITE_NODE_FIELD(raw_default);

WRITE_NODE_FIELD(cooked_default);

WRITE_NODE_FIELD(constraints);