public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: Greg Smith <[email protected]>
Cc: [email protected]
Subject: Re: Special column trivia
Date: Sun, 06 Jun 2010 06:30:15 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

Greg Smith <[email protected]> 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

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Special column trivia
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox