🚀 go-pugleaf

Hi List,

I have a table with following structure:

CREATE TABLE InvMst(
    InvNo       integer     NOT NULL,
    DocRef      integer    NOT NULL,
    CONSTRAINT InvMst_PK PRIMARY KEY (InvNo),
) ;
CREATE UNIQUE INDEX InvMst_DocRef ON InvMst(DocRef);

Following are steps taken to insert a new record:

#1 Start a read commited transaction(read commited, rec_version, nowait)

#2 use a generator to assign a unique value to invno as primary key
#3 use  'select docref  from invmst order by docref desc' and get the first
record, plus 1 to get
    the next unused doc number and insert into the table(this is only
temporary)

#4 adding some records to the detail table(not listed here)

#5 repeat #3 to fetch a new doc number(just in case a record has been added
by other user), then commit.

my problem is, when multi users are connected, at step #3 I got an
exception:
"lock conflict on no wait transaction, attempt to store duplicate
values(visible to active transactions)
in unique index"

my understanding is, if not commited nothing can be seen by other
transactions, looks like not the case.
what should I do to be able to serialize(not using generator) docref in a
multi user version? thanks.

Frank