Update Problem - Mailing list pgsql-sql

Hi,

I’m encountering some weird problem on Update.

I have a program that updates a table and it updates more than 1 column at a single query.

Like this one:

Update table1 set column1 = ‘a’, column2 = ‘b’, column3 = time ’08:00 AM’ where column1 = ‘c’

Sometimes only column1 and column2 is updated and column3 is not updated.

What could be the possible cause of this?

Thanks,

IANIAN