On Sun, 26 Oct 2003, Hannu Krosing wrote: > I brought it up once and Tom answered that TOAST tables are not > transaction aware, so you can't update just some parts of toasted > entities - you must always write the whole fields. So this will not be > just an api change.
Yes, the blocks (or what one selects to work with) in a toasted field have to have transaction stuff stored, just like tuples. That is clear if different transactions shall have different views of the "file". -- /Dennis ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match