Greg Smith <greg@2ndquadrant.com> writes:
> I was just reading
> http://www.postgresql.org/docs/9.0/static/ddl-system-columns.html and
> noted that the second part about the ctid being unstable: "a row's ctid
> will change if it is updated or moved by VACUUM FULL" is probably not
> true anymore. Is that worth updating?
It's still true. VACUUM FULL still reassigns ctids.
> What got me reading that section was a rather weird documentation
> question/addition from Edmund Horner. He noted that the following works
> on PG8.4 and 9.0:
> postgres=# select (row(1,2)).name;
This is the cast-a-composite-type-to-string-type issue that's come up in
several guises before, eg most recently at
http://archives.postgresql.org/pgsql-general/2010-05/msg01126.php
regards, tom lane