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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
