Re: Delete Problem - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Delete Problem
Date
Msg-id 20060713051007.GA24387@winnie.fuhr.org
Whole thread Raw
In response to Delete Problem  (Jamie Deppeler <jamie@doitonce.net.au>)
List pgsql-general
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?

--
Michael Fuhr

pgsql-general by date:

Previous
From: mike
Date:
Subject: Re: Crystal Reports 8.5 - SQL Expressions
Next
From: "surabhi.ahuja"
Date:
Subject: cant connect to the database, even after doing start of postmaster using a script