TRUNCATE TABLE with IDENTITY - Mailing list pgsql-hackers

From Simon Riggs
Subject TRUNCATE TABLE with IDENTITY
Date
Msg-id 1206456298.4285.924.camel@ebony.site
Whole thread Raw
Responses Re: TRUNCATE TABLE with IDENTITY
Re: TRUNCATE TABLE with IDENTITY
Re: TRUNCATE TABLE with IDENTITY
List 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



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: FETCH FIRST
Next
From: Bruce Momjian
Date:
Subject: Re: FETCH FIRST