Select for update - Mailing list pgsql-general

Hi,

Is it normal that when I select for update a record, but I don't select all
the fields, that the contents of fields not selected will be deleted:

create table pidtest(pid integer, szoveg text) without oids;

select pid from pistest where pid>5 for update;

After committing (autocommit), the contents of the szoveg field for the
locked rows will be erased.

PostgreSQL 8.0.3 WinXP

Regards,
Otto