[HACKERS] Delete oid causing problems

2001-06-06 Thread rai lalit
Hi all, I am trying to delete a record which had one of the fields as oid. I was able to delete all the records except for 3. I tried: select lo_unlink(64445) from tablename And then: delete from tablename where id=1; it worked But for 3 records the delete command goes in hang. on executing:

[HACKERS] Delete oid giving problems

2001-06-06 Thread rai lalit
Hi all, I am having problems deleting a record with oid. I tried select lo_unlink(68778) from tablename where 68778 is the oid but it gives : lo_unlink --- -1 -1 (2 rows) and when I try to delete that record by: delete from tablename where id=1; it goes on hang. I want