From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: Sequential scan where Index scan expected (update)
Date: Fri, 3 Mar 2006 07:47:12 -0500
Message-ID: <20060303124712.GC7057@phlogiston.dyndns.org> (raw)
In-Reply-To: <4407F031.6050706@obviously.com>
References: <244004377.20060302124132@isb.com.pl>
<2873.1141312882@sss.pgh.pa.us>
<4407F031.6050706@obviously.com>
On Thu, Mar 02, 2006 at 11:28:49PM -0800, Bryce Nesbitt wrote:
> Can anyone help figure out why?
Well. . .
>
>
> demo=# \d xx_thing
^^^^^^^^
> -------------------------+-----------------------------+-----------
> thing_id | bigint | not null
^^^^^^
> demo=# explain update xx_thing_event set thing_color='foo' where
^^^^^^^^^^^^^^
. . .you haven't actually given us the right schema here, but if I
had to guess, I'd say you could put this
> thing_event_id=10000;
^^^^^
in quotes. The automatic int4-int8 coercion is probably your
problem. Also
> ----------------------------------------------------------------------------------------------------------
> PostgreSQL 7.4.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3
^^^^^
you need to upgrade PostgreSQL Right Now. There are serious problems
with earlier 7.4 releases. Get the latest, or risk data corruption.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
When my information changes, I alter my conclusions. What do you do sir?
--attr. John Maynard Keynes
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ajs@crankycanuck.ca
Subject: Re: Sequential scan where Index scan expected (update)
In-Reply-To: <20060303124712.GC7057@phlogiston.dyndns.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox