<!--

$Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.173 2002/12/20 00:24:00 momjian Exp $

$Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.174 2002/12/30 19:45:11 tgl Exp $

-->

<appendix id="release">

Domains now support CHECK constraints

psql backslash commands for listing conversions, casts, and schemas

TRUNCATE TABLE is transaction-safe

CLUSTER can re-cluster a previously clustered table, or all such tables

Statement-level triggers

System can use either hash- or sort-based strategy for grouped aggregation

ON COMMIT options for temp tables

RelToClusterrvtc;

tableOid=RangeVarGetRelid(stmt->relation,false);

rel=heap_openrv(stmt->relation,AccessExclusiveLock);

rel=heap_open(tableOid,AccessExclusiveLock);

tableOid=RelationGetRelid(rel);

if (!check_cluster_permitted(tableOid))

elog(ERROR,"CLUSTER: cannot cluster system relation \"%s\"",

RelationGetRelationName(OldHeap));

if (isOtherTempNamespace(RelationGetNamespace(OldHeap)))

elog(ERROR,"CLUSTER cannot be used on temp tables of other processes");

index_close(OldIndex);

Form_pg_constraintcon= (Form_pg_constraint)GETSTRUCT(tuple);

if (con->contype=='f'&&con->conrelid!=relid)

elog(ERROR,"TRUNCATE cannot be used as table %s references "

"this one via foreign key constraint %s",

elog(ERROR,"TRUNCATE cannot be used as table %s references this one via foreign key constraint %s",

get_rel_name(con->conrelid),

NameStr(con->conname));

}

rebuild_relation(rel,InvalidOid);

}