Title: Re: [GENERAL] threads and transaction ...sample code and stored procedure
hi
everyone!
Thanks to Tom, the problem is fine ..The
mistake I was doing was setting the isolation level to
serializable.
and i have imposed an exclusive lock
instead of the access exclusive lock
"Surabhi Ahuja " <[EMAIL PROTECTED]> writes:
> CREATE OR REPLACE FUNCTION insert_patient (varchar(65),varchar(65),date,var=
> char(256)) RETURNS retval AS'
> ...
> LOCK TABLE patient in ACCESS EXCLUSIVE mode;
> select patient_id into patId from patient where patient_key = patKey;
> if not found
> T
