Обсуждение: BUG #5554: PostgreSQL 8.4.0 doesn't update my table

Поиск
Список
Период
Сортировка

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

От
"jose soares"
Дата:
The following bug has been logged online:

Bug reference:      5554
Logged by:          jose soares
Email address:      jose.soares@sferacarta.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

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

От
Tom Lane
Дата:
"jose soares" <jose.soares@sferacarta.com> writes:
> I found a strange behavior in my DB, I have a table which Pg isn't be able
> to update.

Maybe you've got a rule or trigger on the table that is interfering with
the update?

If there actually is a bug here, you've not provided nearly enough
information for anyone else to diagnose or reproduce it.  Please see
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
for some help in composing useful bug reports.

            regards, tom lane