Thanks for reporting this.
This is an issue that is already in the tracker, issue 3019765.
Thanks,
Mason
On 12/9/10 6:06 AM, xiong wang wrote:
> Dears,
>
> steps:
>
> postgres=# begin;
> BEGIN
> postgres=# create sequence seq2;
> CREATE SEQUENCE
> postgres=# rollback;
> ROLLBACK
> postgres=# create sequence seq2;
> ERROR: GTM error, could not create sequence
>
> GTM log:
> 2:1089829184:2010-12-09 19:02:41.941 CST -LOG: Sequence with the
> given key already exists
> LOCATION: seq_add_seqinfo, gtm_seq.c:169
> 3:1089829184:2010-12-09 19:02:41.941 CST -ERROR: Failed to open a new sequence
> LOCATION: ProcessSequenceInitCommand, gtm_seq.c:751
>
> When rollback a transaction, the sequence created in the transaction
> cann't be removed from GTM.
>
> Regards,
> Benny
>
> ------------------------------------------------------------------------------
> This SF Dev2Dev email is sponsored by:
>
> WikiLeaks The End of the Free Internet
> http://p.sf.net/sfu/therealnews-com
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
--
Mason Sharp
EnterpriseDB Corporation
The Enterprise Postgres Company
This e-mail message (and any attachment) is intended for the use of
the individual or entity to whom it is addressed. This message
contains information from EnterpriseDB Corporation that may be
privileged, confidential, or exempt from disclosure under applicable
law. If you are not the intended recipient or authorized to receive
this for the intended recipient, any use, dissemination, distribution,
retention, archiving, or copying of this communication is strictly
prohibited. If you have received this e-mail in error, please notify
the sender immediately by reply e-mail and delete this message.
|