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