Re: Delete Problem

Поиск
Список
Период
Сортировка
От surabhi.ahuja
Тема Re: Delete Problem
Дата
Msg-id 8626C1B7EB748940BCDD7596134632BE398696@jal.iiitb.ac.in
обсуждение исходный текст
Ответ на Delete Problem  (Jamie Deppeler <jamie@doitonce.net.au>)
Ответы Re: Delete Problem  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список pgsql-general
even i have seen this problem
 
i am using postgres 8.0.0
 
i open psql <dbname>
 
and there i try to do
delete from <tab1>
 
it seems that psql gets stuck.
 
even after 5 mins or something, no deletion happens.
 
generally this happens when the disk is nearing to full
 
cant this be avoided, why does postgres hang.
 
thanks,
regards
Surabhi
 
 


From: pgsql-general-owner@postgresql.org on behalf of Michael Fuhr
Sent: Thu 7/13/2006 11:48 AM
To: Jamie Deppeler
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Delete Problem

***********************
Your mail has been scanned by InterScan VirusWall.
***********-***********


[Please copy the mailing list on replies so others can participate
in and learn from the discussion.]

On Thu, Jul 13, 2006 at 03:32:43PM +1000, Jamie Deppeler wrote:
> Michael Fuhr wrote:
> >On Thu, Jul 13, 2006 at 01:45:36PM +1000, Jamie Deppeler wrote:
> >>Just today i have noticed i have one certain table  that i cannot delete
> >>any records from
> >
> >What happens when you try to delete?  Do you get an error?  Does
> >the delete succeed but report zero rows deleted?  Something else?
> >What does "EXPLAIN ANALYZE DELETE ..." show?  Is the delete done
> >in a transaction that doesn't commit?
>
> Delete is performed without any errors or warnings but when i refresh
> the found set it is still in the table

What do you mean by "refresh the found set"?  What client interface
are you using?  Might the deleting transaction not be committing?
What happens if you do the delete using psql?  What version of
PostgreSQL are you running?

--
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

В списке pgsql-general по дате отправления:

Предыдущее
От: "Christian Rengstl"
Дата:
Сообщение: Performance problem with query
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Delete Problem