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 | [EMAIL PROTECTED]
When my information changes, I alter my conclusions. What do you do sir?
--attr. John Maynard Keynes
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
