pg.ddx.io pgsql-sql@postgresql.org mailing list archive help / color / mirror / Atom feed From: pginfo <pginfo@t1.unisoftbg.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Richard_D_Levine@raytheon.com, Michael Glaesemann <grzm@myrealbox.com>
Cc: pgsql-sql@postgresql.org
Cc: pgsql-sql-owner@postgresql.org
Subject: Re: pg primary key bug?
Date: Thu, 17 Feb 2005 17:41:51 +0100
Message-ID: <4214C94F.2050806@t1.unisoftbg.com> (raw )
References: <OFEF67063C.F61988F3-ON05256F9D.005A91D6@ftw.us.ray.com >
<4214B466.20908@t1.unisoftbg.com >
<8125.1108661189@sss.pgh.pa.us >
Hi,
Tom Lane wrote:
>pginfo <pginfo@t1.unisoftbg.com> writes:
>
>
>>01=# select * from a_constants_str where constname='DOCPLAID' ;
>> constname | fid | constvalue
>>-----------+-----+------------
>> DOCPLAID | 0 | SOF_19738
>> DOCPLAID | 0 | SOF_19738
>>(2 rows)
>>
>>
>
>Could we see the system columns on these rows?
>
> select oid,xmin,cmin,xmax,cmax,ctid,* from a_constants_str where ...
>
> regards, tom lane
>
>
>
>
yes,
01=# select oid,xmin,cmin,xmax,cmax,ctid,* from a_constants_str;
oid | xmin | cmin | xmax | cmax | ctid | constname |
fid | constvalue
--------+---------+---------+---------+---------+---------+-----------+-----+------------
17910 | 22331 | 2 | 2 | 26679 | (0,7) | ANMGRID
| 0 | SOF_10
17908 | 985 | 6 | 6 | 0 | (0,18) | AKLTYPID
| 0 | SOF_3
17907 | 985 | 30 | 30 | 0 | (0,21) | ADARID
| 0 | SOF_2
17921 | 985 | 34 | 34 | 0 | (0,22) | AOBLASTID
| 0 | SOF_3
17911 | 4640 | 6 | 6 | 26679 | (0,24) | AACCGRID
| 0 | SOF_3
17920 | 1220598 | 2 | 2 | 1475630 | (0,47) | ASLUID
| 0 | SOF_17
17917 | 643083 | 2 | 2 | 1475630 | (0,49) | LOCAID
| 0 | SOF_13
17918 | 762851 | 3 | 3 | 1475630 | (0,50) | AUSERID
| 0 | SOF_3
17923 | 35539 | 165 | 165 | 1475630 | (0,51) | ASETUPID
| 0 | SOF_399
283686 | 514327 | 3 | 3 | 1475630 | (0,52) | NASTRF
| 0 | SOF_1
17909 | 2156667 | 2 | 2 | 2193198 | (0,54) | AKLGRID
| 0 | SOF_8
17922 | 2103298 | 2 | 2 | 2193198 | (0,55) | AGRADID
| 0 | SOF_165
17913 | 2092705 | 2 | 2 | 2193198 | (0,56) | ANOMID
| 0 | SOF_747
63247 | 2226373 | 2 | 2 | 2233003 | (0,126) | TDOCID
| 0 | SOF_47
17914 | 2232893 | 2235861 | 2235861 | 3 | (1,125) | DOCID
| 0 | SOF_25658
17915 | 2232893 | 2235861 | 2235861 | 19 | (3,38) | DOCRID
| 0 | SOF_184547
17916 | 2232893 | 2235861 | 2235861 | 42 | (4,71) | DOCPLAID
| 0 | SOF_19738
17919 | 2232893 | 231 | 231 | 2233003 | (5,104) | DOCPOGPLA
| 0 | SOF_24281
17912 | 2231139 | 2 | 2 | 0 | (6,1) | AKLIID
| 0 | SOF_3513
17916 | 2232893 | 2235861 | 2235861 | 41 | (7,62) | DOCPLAID
| 0 | SOF_19738
63249 | 2226373 | 103 | 103 | 0 | (16,31) | TDOCRID
| 0 | SOF_2439
(21 rows)
and
01=# select oid,xmin,cmin,xmax,cmax,ctid,* from a_constants_str where
constname='DOCPLAID';
oid | xmin | cmin | xmax | cmax | ctid | constname | fid |
constvalue
-------+---------+---------+---------+------+--------+-----------+-----+------------
17916 | 2232893 | 2235861 | 2235861 | 42 | (4,71) | DOCPLAID | 0 |
SOF_19738
17916 | 2232893 | 2235861 | 2235861 | 41 | (7,62) | DOCPLAID | 0 |
SOF_19738
(2 rows)
regards,
ivan.
view thread (27+ messages) latest in thread
Message-ID: <4214C94F.2050806@t1.unisoftbg.com>
Permalink: ../4214C94F.2050806@t1.unisoftbg.com/
Also on: postgresql.org/message-id/4214C94F.2050806@t1.unisoftbg.com
copy link · copy postgr.es
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: pgsql-sql@postgresql.org
Cc: pginfo@t1.unisoftbg.com, tgl@sss.pgh.pa.us, grzm@myrealbox.com, pgsql-sql-owner@postgresql.org
Subject: Re: pg primary key bug?
In-Reply-To: <4214C94F.2050806@t1.unisoftbg.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox