[Postgres-xc-bugs] Failed to recreate sequence after dropping database

[Dimitrije R. <tem...@gm...>]

Hi all,

I am considering Postgres-XC as a database backend for my project, and I
have decided to give it some testing. I think I encountered a bug, so here
are steps to reproduce (I am using version 1.0.0, compiled from tarball,
with initial setup as described here:
http://postgres-xc.sourceforge.net/docs/1_0/install-short.html):
1) create a database (CREATE DATABASE test WITH OWNER=postgres;)
2) create a table with serial primary key (CREATE TABLE test_table(id
SERIAL NOT NULL, data int4, PRIMARY KEY(id)) tablespace data; - not sure if
specifying tablespace has anything to do with this, this data tablespace
was created earlier)
3) drop database (DROP DATABASE test;)
4) repeat step 1-2)
5) this results in ERROR:  GTM error, could not create sequence

Here's relevant part of GTM log:
----
1:140436113319680:2012-06-14 16:04:42.847 CEST -LOG:  Sending transaction
id 11949
LOCATION:  ProcessBeginTransactionGetGXIDCommand,
/home/dimitrijer/Projekti/pgxc/build/../src/gtm/main/gtm_txn.c:1164
1:140436113319680:2012-06-14 16:04:42.851 CEST -LOG:  Sequence with the
given key already exists
LOCATION:  seq_add_seqinfo,
/home/dimitrijer/Projekti/pgxc/build/../src/gtm/main/gtm_seq.c:177
1:140436113319680:2012-06-14 16:04:42.851 CEST -ERROR:  Failed to open a
new sequence
LOCATION:  ProcessSequenceInitCommand,
/home/dimitrijer/Projekti/pgxc/build/../src/gtm/main/gtm_seq.c:883
1:140436113319680:2012-06-14 16:04:42.851 CEST -LOG:  Cancelling
transaction id 11949
----

Kind regards,
Dimitrije