Hi, I am using 7.2.
I have problem in deleting records from a particular table in my database. Say, if the DELETE command results deleting 10 records, the command is blocked at the end and is not returning. FYI, that table donot have any triggers/constraints/rules on delete. I have checked whether its due to the same table access by some other client, but it is not so. No other process is accessing this table by that time. Infact i am able to repeat the problem. To make sure, i wrote a plpgsql and tried deleting these 10 records one by one in a for loop. There too it is blocked for infinite time, after deleting the last record. what would be the problem? Is the table corrupted? FYI, table has a primary key which is referred from different tables. Anyhow i have deleted records from foreign key tables, before deleting from the primary key table. I am lucky if i have given enough information, you required. If not please get me back. It is quite urgent. Please.. TIA. regards, bhuvaneswaran ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
