postgres-xc-bugs

[Postgres-xc-bugs] ALTER SEQUENCE

[Hitoshi H. <hem...@la...>]

Hi,

This error report is about ALTER SEQUENCE,
and does NOT include Japanese. ;-)

============================================================================
POSTGRES-XC BUG REPORT TEMPLATE
============================================================================

Your name : Hitoshi Hemmi
Your email address : hem...@la...


System Configuration:
---------------------
Architecture : x86_64

Operating System : CentOS release 6.2

Postgres-XC version : Postgres-XC 1.0beta2

Compilers used : gcc (GCC) 4.4.6 20110731 (Red Hat 4.4.6-3)
gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-51)
We tried both compilers. Why? Simply, by chance.


Description of problems:
==============================================

testdb=# CREATE SEQUENCE seq;
CREATE SEQUENCE

testdb=# ALTER SEQUENCE seq RESTART WITH 10;
ALTER SEQUENCE

testdb=# select nextval('seq');
nextval
---------
10
(1 row)

testdb=# ALTER SEQUENCE seq RESTART WITH 10;
ALTER SEQUENCE
testdb=# select nextval('seq');
nextval
---------
1
(1 row)

==============================================

Thanks.

-- 
Hitoshi HEMMI
NTT Open Source Software Center
hem...@la...
(Please note that my address has changed.)
Tel:(03)5860-5115
Fax:(03)5463-5490

Re: [Postgres-xc-bugs] ALTER SEQUENCE

[Michael P. <mic...@gm...>]

This is fixed by commit 41e78f3 and will be included in next release.
https://github.com/postgres-xc/postgres-xc/commit/41e78f38c0caf6ce41f148bc853e1869e06301b0

On Mon, May 28, 2012 at 4:58 PM, Hitoshi HEMMI
<hem...@la...>wrote:

> Hi,
>
> This error report is about ALTER SEQUENCE,
> and does NOT include Japanese. ;-)
>
>
> ============================================================================
> POSTGRES-XC BUG REPORT TEMPLATE
>
> ============================================================================
>
> Your name : Hitoshi Hemmi
> Your email address : hem...@la...
>
>
> System Configuration:
> ---------------------
> Architecture : x86_64
>
> Operating System : CentOS release 6.2
>
> Postgres-XC version : Postgres-XC 1.0beta2
>
> Compilers used : gcc (GCC) 4.4.6 20110731 (Red Hat 4.4.6-3)
> gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-51)
> We tried both compilers. Why? Simply, by chance.
>
>
> Description of problems:
> ==============================================
>
> testdb=# CREATE SEQUENCE seq;
> CREATE SEQUENCE
>
> testdb=# ALTER SEQUENCE seq RESTART WITH 10;
> ALTER SEQUENCE
>
> testdb=# select nextval('seq');
> nextval
> ---------
> 10
> (1 row)
>
> testdb=# ALTER SEQUENCE seq RESTART WITH 10;
> ALTER SEQUENCE
> testdb=# select nextval('seq');
> nextval
> ---------
> 1
> (1 row)
>
> ==============================================
>
> Thanks.
>
> --
> Hitoshi HEMMI
> NTT Open Source Software Center
> hem...@la...
> (Please note that my address has changed.)
> Tel:(03)5860-5115
> Fax:(03)5463-5490
>
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Postgres-xc-bugs mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-bugs
>



-- 
Michael Paquier
http://michael.otacoo.com