From: pgsql-general-owner@xxxxxxxxxxxxxx on behalf of Michael Fuhr
Sent: Thu 7/13/2006 11:48 AM
To: Jamie Deppeler
Cc: pgsql-general@xxxxxxxxxxxxxx
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
