postgres-xc-developers

[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

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

[Koichi S. <koi...@gm...>]

Thanks.   I'd like to discuss refactoring sequence support in the next F2F
MTG, or in Ottawa, if we have a time.

----------
Koichi Suzuki


2013/5/8 Ashutosh Bapat <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
>
>
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and
> their applications. This 200-page book is written by three acclaimed
> leaders in the field. The early access version is available now.
> Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>
>

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

[Nikhil S. <ni...@st...>]

Hi Suzuki-san,

I have submitted patch to handle negative sequences a while back.

Yes, surely we can discuss stuff at pgcon as well.

Regards,
Nikhils


On Wed, May 8, 2013 at 2:44 PM, Koichi Suzuki <koi...@gm...>wrote:

> Thanks.   I'd like to discuss refactoring sequence support in the next F2F
> MTG, or in Ottawa, if we have a time.
>
> ----------
> Koichi Suzuki
>
>
> 2013/5/8 Ashutosh Bapat <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
>>
>>
>> ------------------------------------------------------------------------------
>> Learn Graph Databases - Download FREE O'Reilly Book
>> "Graph Databases" is the definitive new guide to graph databases and
>> their applications. This 200-page book is written by three acclaimed
>> leaders in the field. The early access version is available now.
>> Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
>> _______________________________________________
>> Postgres-xc-developers mailing list
>> Pos...@li...
>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>>
>>
>
>
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and
> their applications. This 200-page book is written by three acclaimed
> leaders in the field. The early access version is available now.
> Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>
>


-- 
StormDB - http://www.stormdb.com
The Database Cloud

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

[鈴木 幸市 <ko...@in...>]

Sorry, I've not reviewed it yet.  Yes, I will review the patch.

Regards;
---
Koichi Suzuki



On 2013/05/08, at 18:36, Nikhil Sontakke <ni...@st...> wrote:

> Hi Suzuki-san, 
> 
> I have submitted patch to handle negative sequences a while back. 
> 
> Yes, surely we can discuss stuff at pgcon as well. 
> 
> Regards,
> Nikhils
> 
> 
> On Wed, May 8, 2013 at 2:44 PM, Koichi Suzuki <koi...@gm...> wrote:
> Thanks.   I'd like to discuss refactoring sequence support in the next F2F MTG, or in Ottawa, if we have a time.
> 
> ----------
> Koichi Suzuki
> 
> 
> 2013/5/8 Ashutosh Bapat <ash...@en...>
> Hi Nikhil, Suzuki-san,
> 
> I have created feature request https://sourceforge.net/tracker/?func=detail&aid=3612885&group_id=311227&atid=1310235 for 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
> 
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and
> their applications. This 200-page book is written by three acclaimed
> leaders in the field. The early access version is available now.
> Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
> 
> 
> 
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and
> their applications. This 200-page book is written by three acclaimed
> leaders in the field. The early access version is available now.
> Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
> 
> 
> 
> 
> -- 
> StormDB - http://www.stormdb.com
> The Database Cloud
> ------------------------------------------------------------------------------
> Learn Graph Databases - Download FREE O'Reilly Book
> "Graph Databases" is the definitive new guide to graph databases and 
> their applications. This 200-page book is written by three acclaimed 
> leaders in the field. The early access version is available now. 
> Download your free book today! http://p.sf.net/sfu/neotech_d2d_may_______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers