Re: [SQL] Does a the block of code within a stored procedure constitute a transaction?

2003-07-31 Thread btober
>> What I need to know is whether or not this is multi-user safe, i.e., >> will the block of code in the procedure execute as a transaction so >> that if more than one clerk creates an expense report for the same >> employee simultaneously is it possible or impossible that value of >> the >> employ

Re: [SQL] Does a the block of code within a stored procedure constitute

2003-07-31 Thread Rod Taylor
> What I need to know is whether or not this is multi-user safe, i.e., will > the block of code in the procedure execute as a transaction so that if > more than one clerk creates an expense report for the same employee > simultaneously is it possible or impossible that value of the > employee.expen

[SQL] Does a the block of code within a stored procedure constitute a transaction?

2003-07-31 Thread btober
I need to "manually" keep a sequence for each row of the employee table, i.e., I don't want to use postgres's built-in sequences for this application because the sequence numbers are used to generate expense report numbers on a "per-employee" basis. That is, each employee has a separate sequence co