[Postgres-xc-developers] Fwd: [ postgres-xc-Feature Requests-3612885 ] Add support for TRUNCATE with RESTART IDENTITY

[Ashutosh B. <ash...@en...>]

Hi Nikhil, Suzuki-san,

I have created feature request
https://sourceforge.net/tracker/?func=detail&aid=3612885&group_id=311227&atid=1310235for
enabling and supporting TRUNCATE with RESTART IDENTITY. Right now I
have assigned it to Suzuki-san. I didn't find any user id for Nikhil in
sourceforge. If it's to be assigned to Nikhil, Nikhil, please provide your
source forge id.

I have assigned high priority to it (8), so that we will take it up in next
release.

---------- Forwarded message ----------
From: SourceForge.net <no...@so...>
Date: Wed, May 8, 2013 at 11:48 AM
Subject: [ postgres-xc-Feature Requests-3612885 ] Add support for TRUNCATE
with RESTART IDENTITY
To: "SourceForge.net" <no...@so...>


Feature Requests item #3612885, was opened at 2013-05-07 23:18
Message generated for change (Tracker Item Submitted) made by ashutoshbapat
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=1310235&aid=3612885&group_id=311227

Please note that this message will contain a full copy of the comment
thread,
including the initial issue submission, for this request,
not just the latest update.
Category: GTM
Group: Development Queue
Status: Open
Priority: 8
Private: No
Submitted By: Ashutosh Bapat (ashutoshbapat)
Assigned to: Koichi Suzuki (koichi-szk)
Summary: Add support for TRUNCATE with RESTART IDENTITY

Initial Comment:
Currently TRUNCATE statement with RESTART IDENTITY clause doesn't work,
since there is no way to restart a sequence at the GTM. This feature
requests to add the support for TRUNCATE with RESTART IDENTITY.

The feature has been disabled by commit commit
d337476e7c0a49f2b8d05a8c5a1c9be65683bb41
Author: Ashutosh Bapat <ash...@en...>
Date:   Wed May 8 11:41:45 2013 +0530

    TRUNCATE statement with RESTART IDENTITY clause is not supported in this
    release. Error out when TRUNCATE with RESTART IDENTITY is specified.
Alternate
    expected output is updated with error message and consequences of the
same.
    Original patch by Nikhil Sontakke.


----------------------------------------------------------------------

You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=1310235&aid=3612885&group_id=311227



-- 
Best Wishes,
Ashutosh Bapat
EntepriseDB Corporation
The Postgres Database Company