Re: Delete Problem

Not sure if it disk space as i have around 10gig free

surabhi.ahuja wrote:
> 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
>
> ------------------------------------------------------------------------
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.394 / Virus Database: 268.9.10/387 - Release Date: 12/07/2006
>