Delete oid giving problems

Поиск
Список
Период
Сортировка
От rai lalit
Тема Delete oid giving problems
Дата
Msg-id F163zmQVuRWCy7rjcxt0000310a@hotmail.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: place for newbie postgresql hackers to work
Следующее
От: "rai lalit"
Дата:
Сообщение: Delete oid causing problems