Re: Delete Problem

PostgreSQL 8.1.3  on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3
20060104 (prerelease) (Debian 4.0.2-6)


Michael Fuhr wrote:
> 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;
>
>


--

*Jamie Deppeler
*Database Administrator

*once:technologies pty ltd
*
*Do It Once!*

46 Roseneath Street
North Geelong
Victoria 3215 Australia

Ph: +61 3 5278 6699
Fax: +61 3 5278 6166
Email: jamie@doitonce.net.au
Web: http://www.oncefabrik.com <http://www.oncefabrik.com/>