~ubuntu-branches/ubuntu/natty/postgresql-8.4/natty-updates

« back to all changes in this revision

Viewing changes to doc/src/sgml/ref/truncate.sgml

Committer: Bazaar Package Importer
Author(s): Martin Pitt
Date: 2009-05-05 00:58:06 UTC
mfrom: (1.1.2 upstream)
Revision ID: james.westby@ubuntu.com-20090505005806-c19tt7oyqb7kuw49

Tags: 8.4~beta1+cvs20090503-1

New upstream snapshot.

files added:
doc/src/sgml/generate_history.pl

doc/src/sgml/release-7.4.sgml

doc/src/sgml/release-8.0.sgml

doc/src/sgml/release-8.1.sgml

doc/src/sgml/release-8.2.sgml

doc/src/sgml/release-8.3.sgml

doc/src/sgml/release-8.4.sgml

doc/src/sgml/release-old.sgml

src/test/regress/expected/prepared_xacts_1.out

src/tools/check_keywords.pl

files removed:
src/backend/port/dynloader/README.dlfcn.aix

src/tools/major_release_split

files modified:
contrib/citext/expected/citext.out

contrib/citext/expected/citext_1.out

contrib/citext/sql/citext.sql

contrib/pg_trgm/Makefile

contrib/pgcrypto/crypt-md5.c

contrib/pgrowlocks/Makefile

contrib/pgstattuple/Makefile

debian/changelog

doc/src/sgml/Makefile

doc/src/sgml/advanced.sgml

doc/src/sgml/arch-dev.sgml

doc/src/sgml/array.sgml

doc/src/sgml/backup.sgml

doc/src/sgml/client-auth.sgml

doc/src/sgml/config.sgml

doc/src/sgml/contrib.sgml

doc/src/sgml/datatype.sgml

doc/src/sgml/ddl.sgml

doc/src/sgml/dml.sgml

doc/src/sgml/docguide.sgml

doc/src/sgml/ecpg.sgml

doc/src/sgml/filelist.sgml

doc/src/sgml/func.sgml

doc/src/sgml/high-availability.sgml

doc/src/sgml/history.sgml

doc/src/sgml/indices.sgml

doc/src/sgml/info.sgml

doc/src/sgml/install-win32.sgml

doc/src/sgml/installation.sgml

doc/src/sgml/intro.sgml

doc/src/sgml/libpq.sgml

doc/src/sgml/maintenance.sgml

doc/src/sgml/monitoring.sgml

doc/src/sgml/mvcc.sgml

doc/src/sgml/perform.sgml

doc/src/sgml/pgbuffercache.sgml

doc/src/sgml/plpgsql.sgml

doc/src/sgml/postgres.sgml

doc/src/sgml/problems.sgml

doc/src/sgml/queries.sgml

doc/src/sgml/query.sgml

doc/src/sgml/ref/alter_table.sgml

doc/src/sgml/ref/declare.sgml

doc/src/sgml/ref/fetch.sgml

doc/src/sgml/ref/prepare_transaction.sgml

doc/src/sgml/ref/psql-ref.sgml

doc/src/sgml/ref/select.sgml

doc/src/sgml/ref/truncate.sgml

doc/src/sgml/regress.sgml

doc/src/sgml/release.sgml

doc/src/sgml/rowtypes.sgml

doc/src/sgml/runtime.sgml

doc/src/sgml/sources.sgml

doc/src/sgml/sql.sgml

doc/src/sgml/start.sgml

doc/src/sgml/storage.sgml

doc/src/sgml/syntax.sgml

doc/src/sgml/textsearch.sgml

doc/src/sgml/typeconv.sgml

doc/src/sgml/xfunc.sgml

doc/src/sgml/xml2.sgml

src/backend/access/transam/twophase.c

src/backend/access/transam/varsup.c

src/backend/access/transam/xlog.c

src/backend/catalog/heap.c

src/backend/commands/copy.c

src/backend/commands/dbcommands.c

src/backend/libpq/hba.c

src/backend/libpq/ip.c

src/backend/nodes/copyfuncs.c

src/backend/nodes/equalfuncs.c

src/backend/nodes/outfuncs.c

src/backend/optimizer/path/allpaths.c

src/backend/optimizer/path/costsize.c

src/backend/optimizer/path/equivclass.c

src/backend/optimizer/path/indxpath.c

src/backend/optimizer/path/orindxpath.c

src/backend/optimizer/plan/createplan.c

src/backend/optimizer/plan/initsplan.c

src/backend/optimizer/plan/planner.c

src/backend/optimizer/plan/subselect.c

src/backend/optimizer/prep/prepjointree.c

src/backend/optimizer/prep/preptlist.c

src/backend/optimizer/util/placeholder.c

src/backend/optimizer/util/restrictinfo.c

src/backend/optimizer/util/tlist.c

src/backend/optimizer/util/var.c

src/backend/parser/gram.y

src/backend/parser/parse_func.c

src/backend/parser/parser.c

src/backend/parser/scan.l

src/backend/port/dynloader/aix.c

src/backend/port/dynloader/aix.h

src/backend/port/dynloader/osf.c

src/backend/postmaster/postmaster.c

src/backend/utils/adt/arrayfuncs.c

src/backend/utils/adt/datetime.c

src/backend/utils/adt/selfuncs.c

src/backend/utils/adt/varlena.c

src/backend/utils/mb/Unicode/euc_kr_to_utf8.map

src/backend/utils/mb/Unicode/johab_to_utf8.map

src/backend/utils/mb/Unicode/uhc_to_utf8.map

src/backend/utils/mb/Unicode/utf8_to_euc_kr.map

src/backend/utils/mb/Unicode/utf8_to_johab.map

src/backend/utils/mb/Unicode/utf8_to_uhc.map

src/backend/utils/mb/encnames.c

src/backend/utils/mb/mbutils.c

src/backend/utils/misc/guc.c

src/backend/utils/misc/postgresql.conf.sample

src/backend/utils/misc/tzparser.c

src/bin/pg_dump/pg_backup_archiver.c

src/bin/pg_dump/pg_dumpall.c

src/bin/pg_dump/pg_restore.c

src/bin/psql/command.c

src/bin/psql/common.c

src/bin/psql/copy.c

src/bin/psql/describe.c

src/bin/psql/describe.h

src/bin/psql/help.c

src/bin/psql/print.c

src/bin/scripts/vacuumdb.c

src/include/libpq/libpq-be.h

src/include/mb/pg_wchar.h

src/include/nodes/relation.h

src/include/optimizer/prep.h

src/include/optimizer/restrictinfo.h

src/include/optimizer/var.h

src/include/parser/parser.h

src/include/port/win32.h

src/interfaces/libpq/bcc32.mak

src/interfaces/libpq/fe-connect.c

src/interfaces/libpq/fe-secure.c

src/interfaces/libpq/libpq-int.h

src/pl/plpgsql/src/gram.y

src/pl/plpgsql/src/pl_comp.c

src/pl/plpgsql/src/pl_exec.c

src/pl/plpgsql/src/plpgsql.h

src/pl/plpgsql/src/scan.l

src/test/regress/expected/aggregates.out

src/test/regress/expected/arrays.out

src/test/regress/expected/plpgsql.out

src/test/regress/expected/polymorphism.out

src/test/regress/expected/prepared_xacts.out

src/test/regress/pg_regress.c

src/test/regress/sql/aggregates.sql

src/test/regress/sql/plpgsql.sql

src/test/regress/sql/prepared_xacts.sql

src/tools/RELEASE_CHANGES

src/tools/msvc/Install.pm

Show diffs side-by-side

added added

removed removed

doc/src/sgml/ref/truncate.sgml

106

</para>

107

108

<para>

109

<command>TRUNCATE</> acquires an access exclusive lock on the

110

tables in operates on, which blocks all other concurrent operations

109

<command>TRUNCATE</> acquires an <literal>ACCESS EXCLUSIVE</> lock on each

110

table it operates on, which blocks all other concurrent operations

111

on the table. If concurrent access to a table is required, then

112

the <command>DELETE</> command should be used instead.

113

</para>

Older »