Re: [Postgres-xc-developers] Patch for bug#3013984: Sequence scope

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

This is going to be a pretty long message, but...
I made a couple of tests with this patch.

Successively I created two databases, sequences on it, then dropped the
databases.
I created again and a couple of times databases (and so sequences) and
didn't notice any error.
What are the SQL you used for your tests? Is it reproducible?

-- create databases
template1=# create database foo1;
CREATE DATABASE
template1=# create database foo2;
CREATE DATABASE
template1=# \c foo1
psql (8.4.5, サバ 8.4.3)
デタベス "foo1" に接しました。.
foo1=# create sequence foo;
CREATE SEQUENCE
foo1=# create sequence foo2;
CREATE SEQUENCE
foo1=# \c foo2
psql (8.4.5, サバ 8.4.3)
デタベス "foo2" に接しました。.
foo2=# create sequence foo;
CREATE SEQUENCE
foo2=# create sequence foo2;
CREATE SEQUENCE
foo2=# select nextval('foo');
 nextval
---------
       1
(1 行)

foo2=# select nextval('foo');
 nextval
---------
       2
(1 行)

foo2=# \c template1
psql (8.4.5, サバ 8.4.3)
デタベス "template1" に接しました。.
template1=# drop database foo1;
DROP DATABASE
template1=# clean connection to all for database foo2;
CLEAN CONNECTION
template1=# drop database foo2;
DROP DATABASE
template1=# create database foo2;
CREATE DATABASE
template1=# \c foo2
psql (8.4.5, サバ 8.4.3)
デタベス "foo2" に接しました。.
foo2=# create sequence foo;
CREATE SEQUENCE
foo2=# create sequence foo2;
CREATE SEQUENCE
foo2=# select nextval('foo');
 nextval
---------
       1
(1 行)

foo2=# select nextval('foo');
 nextval
---------
       2
(1 行)

foo2=# select nextval('foo2');
 nextval
---------
       1
(1 行)

foo2=# select nextval('foo2');
 nextval
---------
       2
(1 行)

foo2=# \c template1
psql (8.4.5, サバ 8.4.3)
デタベス "template1" に接しました。.
template1=# create database foo1;
CREATE DATABASE
template1=# \c foo1
psql (8.4.5, サバ 8.4.3)
デタベス "foo1" に接しました。.
foo1=# create sequence foo;
CREATE SEQUENCE
foo1=# create sequence foo2;
CREATE SEQUENCE
foo1=# select nextval('foo');
 nextval
---------
       1
(1 行)

foo1=# select nextval('foo');
 nextval
---------
       2
(1 行)

foo1=# select nextval('foo2');
 nextval
---------
       1
(1 行)
foo1=# \c template1
psql (8.4.5, サバ 8.4.3)
デタベス "template1" に接しました。.
template1=# clean connection to all for database foo1;
CLEAN CONNECTION
template1=# clean connection to all for database foo2;
CLEAN CONNECTION
template1=# drop database foo1;
DROP DATABASE
template1=# drop database foo2;
DROP DATABASE
template1=# create database foo1;
CREATE DATABASE
template1=# create database foo2;
CREATE DATABASE
template1=# \c foo1
psql (8.4.5, サバ 8.4.3)
デタベス "foo1" に接しました。.
foo1=# create sequence foo1;
CREATE SEQUENCE
foo1=# create sequence foo2;
CREATE SEQUENCE
foo1=# create sequence foo;
CREATE SEQUENCE
foo1=# select nextval('foo1');
 nextval
---------
       1
(1 行)

foo1=# alter sequence foo2 increment 2;
ALTER SEQUENCE
foo1=# select nextval('foo2');
 nextval
---------
       1
(1 行)

foo1=# select nextval('foo2');
 nextval
---------
       3
(1 行)

foo1=# select nextval('foo2');
 nextval
---------
       5
(1 行)

-- 
Michael Paquier
http://michaelpq.users.sourceforge.net