Re: pg primary key bug?

Hi,

Tom Lane wrote:

>pginfo <pginfo(at)t1(dot)unisoftbg(dot)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.