[Info-ingres] x100 transaction

[Martin Bowes]

Hi All,

On an x100 enabled database I did:

drop table if exists base;
create table base(...) with structure = x100;

The base table does not exist, I only added the drop command in case I need to rerun this creation script.

So I was somewhat surprised to be confronted with error:
E_US250E X100 statements are not allowed in this transaction.
    Create or access an X100 table at the start of a new transaction
    to enable X100 statement processing.

But I can do this with no error:
drop table if exists normal;
create table normal(a integer4 not null not default);
select count(1) from normal;
insert into normal values(1);
drop table if exists base;
create table base(...) with structure = x100;

This doesn't look right to me. Any ideas?

Martin Bowes

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20210507/abc2e717/attachment.html>