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:
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