Delete oid giving problems

From: "rai lalit" <rai_l(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Delete oid giving problems
Date: 2001-06-06 15:14:14
Message-ID: F163zmQVuRWCy7rjcxt0000310a@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-06-06 15:18:30 Re: Can the backend return more than one error message per PQexec?
Previous Message Jan Wieck 2001-06-06 15:13:02 Re: place for newbie postgresql hackers to work