| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: TRUNCATE TABLE with IDENTITY |
| Date: | 2008-03-25 15:48:48 |
| Message-ID: | 21634.1206460128@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> 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
Seems like copying syntax from a *draft* standard is a bit premature,
especially when the amount of functionality added is nil.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-03-25 15:50:34 | Re: [pgsql-www] New email list for emergency communications |
| Previous Message | Tom Lane | 2008-03-25 15:47:04 | Re: FETCH FIRST |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2008-03-25 16:02:25 | Re: TRUNCATE TABLE with IDENTITY |
| Previous Message | Zoltan Boszormenyi | 2008-03-25 15:13:10 | Re: Re: int8/float8/time/timestamp[tz]/float4 passed by value, was Re: Fix HAVE_LONG[_LONG]_INT_64 to really define to 1 |