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

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

Thanks for quick response and fix, Michael! I am so glad people are working
hard to make Postgres-XC ready for production. I will continue testing
today, and will report if I find any more problems.

Dimitrije

2012/6/15 Michael Paquier <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.o <http://michael.otacoo.com>

*.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.*

tacoo.com <http://michael.otacoo.com>