| 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: | Whole Thread | Raw Message | 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.
| 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 |