Re: Ask ctid - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Ask ctid
Date
Msg-id 20080310134124.GA7077@alvh.no-ip.org
Whole thread Raw
In response to Re: Ask ctid  (Achmad Nizar Hidayanto <nizar@cs.ui.ac.id>)
List pgsql-general
Achmad Nizar Hidayanto wrote:

> The two records are identical. But if i display the ctid, the two
> records differ as they
> have different ctid (suppose i display the ctid in the first column):
> R1: 8888, 1001, 1, 02-25-2008, Present, 1
> R2: 9999, 1001, 1, 02-25-2008, Present, 1

This would be a bug.  Please post the unmodified output of

select ctid, xmin, xmax, cmin, cmax, id_absensi, id_user, tanggal
from absensi

The ctid column must differ because it is the physical address of the
tuple.


--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: Achmad Nizar Hidayanto
Date:
Subject: Re: Ask ctid
Next
From: "Pau Marc Munoz Torres"
Date:
Subject: Fwd: pgsql configuration