Hi All, Please clarify me the following example.
I have 2 tables Table1 - ( it has one primary key and few columns ) Table2 - ( it has one primary key and few columns. It has one foreign key, which refers table1 primary key ). I have 2 operations, which are written in pl/pgsql procedure. Operation1() - Inserts the records to table2 at every hour basis. Operation2() - Delete the records from Table 1 and Table2 based on the primary key. What if both operations are running at the time for the same primary key. what I have to take care to run these two operations perfectly without creating inconsistency in database. Thanks & Regards, Ramkumar