Re: Sequential scan where Index scan expected (update)

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(at)crankycanuck(dot)ca
When my information changes, I alter my conclusions. What do you do sir?
--attr. John Maynard Keynes