Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Truncate table



I have been reading about transactional DDLs at
http://archives.postgresql.org/pgsql-general/2007-06/msg00190.php.
This discussion seems to be recent though; is this feature available
in version 7.4?

In addition, CREATE TABLE, ALTER TABLE, DROP TABLE are all DDL
statements, how about TRUNCATE TABLE? The manual says it has the same
effect as DELETE so I think it is a DML but want to be sure.

Last of all, does a TRUNCATE TABLE statement issue a ROW EXCLUSIVE
lock as DELETE does?

Thank you,

Burak



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group