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