Re: [GENERAL] table insert/primary key question

2014-04-04 Thread Albe Laurenz
Scot Kreienkamp wrote: > I have a table like so: > > Receiptlimitid: BIGINT (Primary Key) > Profitcenterid: BIGINT > Receiptnumber: INTEGER > > All are set to Not Null also. > > > My question is, if I have an insert that goes idle in transaction for a while > before it commits, will > it stop

[GENERAL] table insert/primary key question

2014-04-02 Thread Scot Kreienkamp
Hey everyone, I have a table like so: Receiptlimitid: BIGINT (Primary Key) Profitcenterid: BIGINT Receiptnumber: INTEGER All are set to Not Null also. My question is, if I have an insert that goes idle in transaction for a while before it commits, will it stop all other inserts from happening