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

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

> 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
>
> Thanks for the bug report.
I found the origin of the problem and committed the fix with id c3e01a6:
https://github.com/postgres-xc/postgres-xc/commit/c3e01a6277f1d1d94c6d45114a710d47ddc6ece2

The fix has also been applied to 1.0 stable branch, so it will be included
in next maintenance release of 1.0.
You can still apply the commit to your 1.0.0 source if you want to avoid
the problem for the time being.

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