Hi All, I am having an issue with a deadlock scenario in PostgreSQL 8.3.1I have the following database postgres, what I do is create two tables t1 and t2 in this database and I have the following fileds t1(a_id smallint, fn character(20), ln character(20), rt smallint)t2( c_id smallint, c_name character(20));The connection to the "postgres" database is established through two terminals;From the 1st terminal I give the following command1) begin transaction; update t2 set c_name = 'lock' where c_id = 1;From the 2nd terminal I give the following command2) begin transaction; update t1 set ln = 'lock' where a_id = 1;Then I come back to the 1st terminal and execute the following3) update t1 set ln = 'lock' where a_id = 1;Then I come to 2nd Terminal and execute the following 4) update t2 set c_name = 'lock' where c_id = 1;When I come out I get the following error message ERROR: deadlock detected
DETAIL: Process 15171 waits for ShareLock on transaction 12738; blocked by process 15183.
Process 15183 waits for ShareLock on transaction 12739; blocked by process 15171.This is perfectly fine, but what i am trying to acheive is that I am putting the above four queries in 4 different .sql files and executing it in the same way as displayed above by using two different terminals, please refer below the sequence which I am using.From the 1st terminal I give the following command1) psql -f dl11.sql -U postgres -d postgresFrom the 2nd terminal I give the following command2) psql -f dl21.sql -U postgres -d postgresThen I come back to the 1st terminal and execute the following3) psql -f dl12.sql -U postgres -d postgresThen I come to 2nd Terminal and execute the following4) psql -f dl22.sql -U postgres -d postgresI should be getting the same message about deadlock detection, but I am unable to get that.Could anyone please tell me where I am going wrong and if there is a way I can get the same behaviour that I am getting while I am executing the
through psql prompt.Thanks in advanceWaiting for replyRegardsCinu
Explore your hobbies and interests. Go to http://in.promos.yahoo.com/groups/