Re: Delete Problem

On Thu, Jul 13, 2006 at 04:58:26PM +1000, Jamie Deppeler wrote:
> db=# \d job
> Table "job"
> Column | Type
> | Modifiers
> ---------------------+-----------------------------+----------------------------------------------------------------
> primary | integer | not null default
> nextval('job_primary_seq'::regclass)
> jobnumber | text |
> jobname | text |
> jobdetails | text |
> Indexes:
> "job_pkey" PRIMARY KEY, btree ("primary")

You said you were running 8.0 but "nextval('job_primary_seq'::regclass)"
suggests 8.1. What does "SELECT version()" show?

What are the output of the following?

EXPLAIN ANALYZE SELECT "primary" FROM job WHERE "primary" = 370;
EXPLAIN ANALYZE DELETE FROM job WHERE "primary" = 370;

If these commands use index or bitmap index scans, do you get
different results if you execute the following commands and then
try the delete again?

SET enable_indexscan TO off;
SET enable_bitmapscan TO off;

--
Michael Fuhr