← Back to branch summary

~ubuntu-branches/ubuntu/lucid/postgresql-8.4/lucid-proposed

~ubuntu-branches/ubuntu/lucid/postgresql-8.4/lucid-proposed

« back to all changes in this revision

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

Committer: Package Import Robot
Author(s): Martin Pitt
Date: 2012-09-25 07:38:24 UTC
mfrom: (1.3.8) (12.1.6 lucid-security)
Revision ID: package-import@ubuntu.com-20120925073824-w62lp3agkr8dwnoc

Tags: 8.4.14-0ubuntu10.04

https://launchpad.net/bugs/1055944

* New upstream bug fix release: (LP: #1055944)
  - Fix planner's assignment of executor parameters, and fix executor's
    rescan logic for CTE plan nodes.
    These errors could result in wrong answers from queries that scan
    the same WITH subquery multiple times.
  - Improve page-splitting decisions in GiST indexes.
    Multi-column GiST indexes might suffer unexpected bloat due to this
    error.
  - Fix cascading privilege revoke to stop if privileges are still held.
    If we revoke a grant option from some role "X", but "X" still holds
    that option via a grant from someone else, we should not
    recursively revoke the corresponding privilege from role(s) "Y"
    that "X" had granted it to.
  - Fix handling of SIGFPE when PL/Perl is in use.
    Perl resets the process's SIGFPE handler to SIG_IGN, which could
    result in crashes later on. Restore the normal Postgres signal
    handler after initializing PL/Perl.
  - Prevent PL/Perl from crashing if a recursive PL/Perl function is
    redefined while being executed.
  - Work around possible misoptimization in PL/Perl.
    Some Linux distributions contain an incorrect version of
    "pthread.h" that results in incorrect compiled code in PL/Perl,
    leading to crashes if a PL/Perl function calls another one that
    throws an error.

files added:
src/backend/po/ru.po

src/backend/regex/regprefix.c

src/bin/pg_controldata/po/ru.po

src/bin/pg_dump/po/ru.po

src/bin/psql/po/ru.po

src/bin/scripts/po/ru.po

src/interfaces/ecpg/ecpglib/po/ru.po

src/interfaces/ecpg/preproc/po/ru.po

src/pl/plperl/po/ru.po

src/pl/plpgsql/src/po/ru.po

src/pl/plpython/po/ru.po

src/pl/tcl/po/ru.po

files removed:
debian/patches/00git_inet_cidr_unpack.patch

debian/patches/04-armel-tas.patch

files modified:
HISTORY

INSTALL

config/python.m4

configure

configure.in

contrib/dblink/dblink.c

contrib/dblink/expected/dblink.out

contrib/intarray/_int_tool.c

contrib/intarray/expected/_int.out

contrib/intarray/sql/_int.sql

contrib/pgcrypto/crypt-des.c

contrib/pgcrypto/pgcrypto.c

contrib/test_parser/test_parser.c

contrib/xml2/expected/xml2.out

contrib/xml2/expected/xml2_1.out

contrib/xml2/sql/xml2.sql

contrib/xml2/xslt_proc.c

debian/changelog

debian/control

doc/bug.template

doc/man.tar.gz

doc/postgres.tar.gz

doc/src/sgml/auto-explain.sgml

doc/src/sgml/backup.sgml

doc/src/sgml/config.sgml

doc/src/sgml/ddl.sgml

doc/src/sgml/external-projects.sgml

doc/src/sgml/legal.sgml

doc/src/sgml/libpq.sgml

doc/src/sgml/maintenance.sgml

doc/src/sgml/queries.sgml

doc/src/sgml/ref/alter_table.sgml

doc/src/sgml/ref/create_trigger.sgml

doc/src/sgml/ref/delete.sgml

doc/src/sgml/ref/initdb.sgml

doc/src/sgml/ref/lock.sgml

doc/src/sgml/ref/select.sgml

doc/src/sgml/ref/truncate.sgml

doc/src/sgml/ref/update.sgml

doc/src/sgml/release-8.3.sgml

doc/src/sgml/release-8.4.sgml

doc/src/sgml/trigger.sgml

doc/src/sgml/xml2.sgml

src/backend/access/gin/ginxlog.c

src/backend/access/gist/gistutil.c

src/backend/access/heap/heapam.c

src/backend/access/index/genam.c

src/backend/access/nbtree/README

src/backend/access/nbtree/nbtinsert.c

src/backend/access/nbtree/nbtpage.c

src/backend/access/nbtree/nbtree.c

src/backend/access/transam/twophase.c

src/backend/access/transam/xact.c

src/backend/access/transam/xlog.c

src/backend/catalog/storage.c

src/backend/commands/copy.c

src/backend/commands/sequence.c

src/backend/commands/tablecmds.c

src/backend/commands/tablespace.c

src/backend/commands/trigger.c

src/backend/executor/execMain.c

src/backend/executor/execQual.c

src/backend/executor/execUtils.c

src/backend/executor/nodeCtescan.c

src/backend/executor/nodeSubplan.c

src/backend/libpq/be-secure.c

src/backend/nls.mk

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/indxpath.c

src/backend/optimizer/plan/planner.c

src/backend/optimizer/plan/subselect.c

src/backend/optimizer/prep/prepjointree.c

src/backend/optimizer/prep/prepunion.c

src/backend/parser/analyze.c

src/backend/parser/parse_cte.c

src/backend/parser/parse_utilcmd.c

src/backend/po/de.po

src/backend/po/es.po

src/backend/po/fr.po

src/backend/po/pt_BR.po

src/backend/po/tr.po

src/backend/po/zh_CN.po

src/backend/po/zh_TW.po

src/backend/port/win32_sema.c

src/backend/postmaster/bgwriter.c

src/backend/postmaster/postmaster.c

src/backend/postmaster/syslogger.c

src/backend/regex/Makefile

src/backend/regex/regc_color.c

src/backend/regex/regc_nfa.c

src/backend/regex/regcomp.c

src/backend/regex/rege_dfa.c

src/backend/regex/regexec.c

src/backend/rewrite/rewriteManip.c

src/backend/storage/lmgr/deadlock.c

src/backend/storage/lmgr/proc.c

src/backend/storage/smgr/md.c

src/backend/tcop/postgres.c

src/backend/tsearch/to_tsany.c

src/backend/utils/adt/acl.c

src/backend/utils/adt/date.c

src/backend/utils/adt/datetime.c

src/backend/utils/adt/name.c

src/backend/utils/adt/network.c

src/backend/utils/adt/regexp.c

src/backend/utils/adt/ruleutils.c

src/backend/utils/adt/selfuncs.c

src/backend/utils/adt/varchar.c

src/backend/utils/adt/varlena.c

src/backend/utils/adt/xml.c

src/backend/utils/cache/ts_cache.c

src/backend/utils/fmgr/fmgr.c

src/backend/utils/mb/mbutils.c

src/backend/utils/mb/wchar.c

src/bin/initdb/initdb.c

src/bin/initdb/po/cs.po

src/bin/initdb/po/de.po

src/bin/initdb/po/es.po

src/bin/initdb/po/fr.po

src/bin/initdb/po/pl.po

src/bin/initdb/po/ru.po

src/bin/initdb/po/zh_CN.po

src/bin/pg_config/po/de.po

src/bin/pg_config/po/es.po

src/bin/pg_config/po/fr.po

src/bin/pg_config/po/pl.po

src/bin/pg_config/po/ru.po

src/bin/pg_controldata/nls.mk

src/bin/pg_controldata/po/de.po

src/bin/pg_controldata/po/es.po

src/bin/pg_controldata/po/fr.po

src/bin/pg_controldata/po/pl.po

src/bin/pg_ctl/po/de.po

src/bin/pg_ctl/po/es.po

src/bin/pg_ctl/po/fr.po

src/bin/pg_ctl/po/ru.po

src/bin/pg_dump/common.c

src/bin/pg_dump/nls.mk

src/bin/pg_dump/pg_backup_archiver.c

src/bin/pg_dump/pg_backup_archiver.h

src/bin/pg_dump/pg_backup_db.c

src/bin/pg_dump/pg_backup_tar.c

src/bin/pg_dump/pg_dump.c

src/bin/pg_dump/pg_dump.h

src/bin/pg_dump/pg_dump_sort.c

src/bin/pg_dump/po/de.po

src/bin/pg_dump/po/es.po

src/bin/pg_dump/po/fr.po

src/bin/pg_dump/po/sv.po

src/bin/pg_resetxlog/po/de.po

src/bin/pg_resetxlog/po/es.po

src/bin/pg_resetxlog/po/fr.po

src/bin/pg_resetxlog/po/ru.po

src/bin/psql/nls.mk

src/bin/psql/po/de.po

src/bin/psql/po/es.po

src/bin/psql/po/fr.po

src/bin/psql/po/ko.po

src/bin/psql/po/sv.po

src/bin/psql/print.c

src/bin/psql/sql_help.h

src/bin/scripts/nls.mk

src/bin/scripts/po/de.po

src/bin/scripts/po/es.po

src/bin/scripts/po/fr.po

src/include/access/nbtree.h

src/include/commands/tablecmds.h

src/include/libpq/libpq-be.h

src/include/mb/pg_wchar.h

src/include/miscadmin.h

src/include/nodes/execnodes.h

src/include/nodes/nodes.h

src/include/nodes/relation.h

src/include/pg_config.h.in

src/include/pg_config.h.win32

src/include/regex/regex.h

src/include/regex/regguts.h

src/include/rewrite/rewriteManip.h

src/include/storage/relfilenode.h

src/include/storage/s_lock.h

src/include/utils/builtins.h

src/include/utils/inet.h

src/include/utils/selfuncs.h

src/include/utils/timestamp.h

src/interfaces/ecpg/ecpglib/nls.mk

src/interfaces/ecpg/ecpglib/po/de.po

src/interfaces/ecpg/ecpglib/po/es.po

src/interfaces/ecpg/ecpglib/po/fr.po

src/interfaces/ecpg/preproc/ecpg.addons

src/interfaces/ecpg/preproc/nls.mk

src/interfaces/ecpg/preproc/po/de.po

src/interfaces/ecpg/preproc/po/es.po

src/interfaces/ecpg/preproc/po/fr.po

src/interfaces/ecpg/preproc/preproc.c

src/interfaces/ecpg/preproc/preproc.y

src/interfaces/libpq/fe-secure.c

src/interfaces/libpq/libpq-dist.rc

src/interfaces/libpq/libpq-int.h

src/interfaces/libpq/libpq.rc.in

src/interfaces/libpq/po/de.po

src/interfaces/libpq/po/es.po

src/interfaces/libpq/po/fr.po

src/interfaces/libpq/po/it.po

src/interfaces/libpq/po/pt_BR.po

src/interfaces/libpq/po/ru.po

src/interfaces/libpq/po/sv.po

src/interfaces/libpq/po/zh_CN.po

src/interfaces/libpq/po/zh_TW.po

src/pl/plperl/expected/plperl.out

src/pl/plperl/nls.mk

src/pl/plperl/plperl.c

src/pl/plperl/po/de.po

src/pl/plperl/po/es.po

src/pl/plperl/po/fr.po

src/pl/plperl/sql/plperl.sql

src/pl/plpgsql/src/nls.mk

src/pl/plpgsql/src/pl_exec.c

src/pl/plpgsql/src/po/de.po

src/pl/plpgsql/src/po/es.po

src/pl/plpgsql/src/po/fr.po

src/pl/plpython/nls.mk

src/pl/plpython/po/de.po

src/pl/plpython/po/es.po

src/pl/plpython/po/fr.po

src/pl/tcl/nls.mk

src/pl/tcl/po/de.po

src/pl/tcl/po/es.po

src/pl/tcl/po/fr.po

src/port/exec.c

src/port/path.c

src/port/win32ver.rc

src/test/regress/expected/copy2.out

src/test/regress/expected/interval.out

src/test/regress/expected/join.out

src/test/regress/expected/privileges.out

src/test/regress/expected/select_into.out

src/test/regress/expected/sequence.out

src/test/regress/expected/sequence_1.out

src/test/regress/expected/subselect.out

src/test/regress/expected/with.out

src/test/regress/expected/xml.out

src/test/regress/expected/xml_1.out

src/test/regress/pg_regress.c

src/test/regress/sql/copy2.sql

src/test/regress/sql/interval.sql

src/test/regress/sql/join.sql

src/test/regress/sql/privileges.sql

src/test/regress/sql/select_into.sql

src/test/regress/sql/subselect.sql

src/test/regress/sql/with.sql

src/test/regress/sql/xml.sql

src/timezone/data/africa

src/timezone/data/antarctica

src/timezone/data/asia

src/timezone/data/australasia

src/timezone/data/backward

src/timezone/data/etcetera

src/timezone/data/europe

src/timezone/data/factory

src/timezone/data/iso3166.tab

src/timezone/data/leapseconds

src/timezone/data/northamerica

src/timezone/data/pacificnew

src/timezone/data/solar87

src/timezone/data/solar88

src/timezone/data/solar89

src/timezone/data/southamerica

src/timezone/data/systemv

src/timezone/data/yearistype.sh

src/timezone/data/zone.tab

src/timezone/localtime.c

Show diffs side-by-side

added added

removed removed

doc/src/sgml/ref/truncate.sgml

21

21

22

22

<refsynopsisdiv>

23

23

<synopsis>

24

TRUNCATE [ TABLE ] [ ONLY ] <replaceable class="PARAMETER">name</replaceable> [, ... ]

24

TRUNCATE [ TABLE ] [ ONLY ] <replaceable class="PARAMETER">name</replaceable> [ * ] [, ... ]

25

25

[ RESTART IDENTITY | CONTINUE IDENTITY ] [ CASCADE | RESTRICT ]

26

26

</synopsis>

27

27

</refsynopsisdiv>

47

47

<term><replaceable class="PARAMETER">name</replaceable></term>

48

48

<listitem>

49

49

<para>

50

The name (optionally schema-qualified) of a table to be

51

truncated. If <literal>ONLY</> is specified, only that table is

52

truncated. If <literal>ONLY</> is not specified, the table and

53

all its descendant tables (if any) are truncated.

50

The name (optionally schema-qualified) of a table to truncate.

51

If <literal>ONLY</> is specified before the table name, only that table

52

is truncated. If <literal>ONLY</> is not specified, the table and all

53

its descendant tables (if any) are truncated. Optionally, <literal>*</>

54

can be specified after the table name to explicitly indicate that

55

descendant tables are included.

54

56

</para>

55

57

</listitem>

56

58

</varlistentry>

Older »