[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