Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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.


pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group