BUG #5554: PostgreSQL 8.4.0 doesn't update my table

From: "jose soares" <jose(dot)soares(at)sferacarta(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5554: PostgreSQL 8.4.0 doesn't update my table
Date: 2010-07-12 10:23:09
Message-ID: 201007121023.o6CAN9Bn071951@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5554
Logged by: jose soares
Email address: jose(dot)soares(at)sferacarta(dot)com
PostgreSQL version: 8.4.0
Operating system: Linux Debian 4.3.3-13 64-bit
Description: PostgreSQL 8.4.0 doesn't update my table
Details:

I all,
I found a strange behavior in my DB, I have a table which Pg isn't be able
to update.
Take a look...

# select esito from scadenziario where id=564481;
esito
-------
C
(1 row)

# update scadenziario set esito='N' where id=564481;
UPDATE 1

# select esito from scadenziario where id=564481;
esito
-------
C
(1 row)

I already tried a vacumm without success,
this behavior is the same for all table's columns.

what's wrong?
thank you for any help.

j

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2010-07-12 14:17:36 Re: BUG #5554: PostgreSQL 8.4.0 doesn't update my table
Previous Message David Schmitt 2010-07-12 08:10:41 Re: BUG #5549: Feature: plpgsql should allow DECLARE cursor FOR EXECUTE '...'