Re: Delete Problem

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Jamie Deppeler <jamie(at)doitonce(dot)net(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Delete Problem
Date: 2006-07-13 05:10:07
Message-ID: 20060713051007.GA24387@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-07-13 06:18:16 Re: Delete Problem
Previous Message mike 2006-07-13 04:13:03 Re: Crystal Reports 8.5 - SQL Expressions