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 to drop this table and create a new one with the same name. But I am stuck. Any help would be greatly appreciated. Thanks, Rai _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])