Horton

TRUNCATE TABLE with IDENTITY

Simon Riggs <simon@2ndquadrant.com>

View thread View on postgr.es
From: Simon Riggs <simon@2ndquadrant.com>
To: pgsql-hackers@postgresql.org
Date: 2008-03-25T14:44:58Z
Lists: pgsql-hackers 
SQL200n specifies a new qualifier on a TRUNCATE command

TRUNCATE TABLE foo
	[ CONTINUE IDENTITY | RESTART IDENTITY ]

CONTINUE IDENTITY is the default and does nothing, like now.

RESTART IDENTITY will reset the SERIAL sequences back to the original
start value.

Seems like a % project for the TODO list

-- 
  Simon Riggs
  2ndQuadrant  http://www.2ndQuadrant.com 

  PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk