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