Joshua b. Jore wrote:
> 1#
> I saw a post from Jan Wieck about how ctid can be used for a fast update.
> I noticed that ctid changes on update (as expected since it's really a new
> row). Is there anyway to get the new ctid from the update so later
> updates to the row can continue to use ctid to zero in on the row
> location?
That's one of the details I'm still thinking about. And in
the case of a cursor using a junk attribute it gets worse,
because there is no easy way to push that new value back into
the cursor's result set.
But I doubt that this would become a real world problem ever.
People who need to update one and the same DB row again and
again during the same transaction are spaghetti-code-script-
kiddies who know for sure that "a cursor's that thingy on ya
screen that ya move withe mouse", so we're pretty safe here
:-p
> 2#
> Also, is ctid unique for each row?
Yes, per table.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #