Re: pg primary key bug? - Mailing list pgsql-sql

Hi,<br /><br /> Tom Lane wrote:<br /><blockquote cite="mid8125.1108661189@sss.pgh.pa.us" type="cite"><pre
wrap="">pginfo<a class="moz-txt-link-rfc2396E"
href="mailto:pginfo@t1.unisoftbg.com"><pginfo@t1.unisoftbg.com></a>writes: </pre><blockquote type="cite"><pre
wrap="">01=#select * from a_constants_str where constname='DOCPLAID' ;constname | fid | constvalue
 
-----------+-----+------------DOCPLAID  |   0 | SOF_19738DOCPLAID  |   0 | SOF_19738
(2 rows)   </pre></blockquote><pre wrap="">
Could we see the system columns on these rows?
select oid,xmin,cmin,xmax,cmax,ctid,* from a_constants_str where ...
        regards, tom lane

 </pre></blockquote> yes,<br /> 01=# select oid,xmin,cmin,xmax,cmax,ctid,* from a_constants_str;<br />   oid   | 
xmin  |  cmin   |  xmax   |  cmax   |  ctid   | constname | fid | constvalue <br />
--------+---------+---------+---------+---------+---------+-----------+-----+------------<br/>   17910 |   22331
|      2 |       2 |   26679 |   (0,7) | ANMGRID   |   0 | SOF_10<br />   17908 |     985 |       6 |       6 |       0
| (0,18) | AKLTYPID  |   0 | SOF_3<br />   17907 |     985 |      30 |      30 |       0 |  (0,21) | ADARID    |   0 |
SOF_2<br/>   17921 |     985 |      34 |      34 |       0 |  (0,22) | AOBLASTID |   0 | SOF_3<br />   17911 |    4640
|      6 |       6 |   26679 |  (0,24) | AACCGRID  |   0 | SOF_3<br />   17920 | 1220598 |       2 |       2 | 1475630
| (0,47) | ASLUID    |   0 | SOF_17<br />   17917 |  643083 |       2 |       2 | 1475630 |  (0,49) | LOCAID    |   0 |
SOF_13<br/>   17918 |  762851 |       3 |       3 | 1475630 |  (0,50) | AUSERID   |   0 | SOF_3<br />   17923 |   35539
|    165 |     165 | 1475630 |  (0,51) | ASETUPID  |   0 | SOF_399<br />  283686 |  514327 |       3 |       3 |
1475630|  (0,52) | NASTRF    |   0 | SOF_1<br />   17909 | 2156667 |       2 |       2 | 2193198 |  (0,54) | AKLGRID  
|  0 | SOF_8<br />   17922 | 2103298 |       2 |       2 | 2193198 |  (0,55) | AGRADID   |   0 | SOF_165<br />   17913
|2092705 |       2 |       2 | 2193198 |  (0,56) | ANOMID    |   0 | SOF_747<br />   63247 | 2226373 |       2 |      
2| 2233003 | (0,126) | TDOCID    |   0 | SOF_47<br />   17914 | 2232893 | 2235861 | 2235861 |       3 | (1,125) |
DOCID    |   0 | SOF_25658<br />   17915 | 2232893 | 2235861 | 2235861 |      19 |  (3,38) | DOCRID    |   0 |
SOF_184547<br/>   17916 | 2232893 | 2235861 | 2235861 |      42 |  (4,71) | DOCPLAID  |   0 | SOF_19738<br />   17919 |
2232893|     231 |     231 | 2233003 | (5,104) | DOCPOGPLA |   0 | SOF_24281<br />   17912 | 2231139 |       2 |      
2|       0 |   (6,1) | AKLIID    |   0 | SOF_3513<br />   17916 | 2232893 | 2235861 | 2235861 |      41 |  (7,62) |
DOCPLAID |   0 | SOF_19738<br />   63249 | 2226373 |     103 |     103 |       0 | (16,31) | TDOCRID   |   0 |
SOF_2439<br/> (21 rows)<br /><br /> and <br /><br /> 01=# select oid,xmin,cmin,xmax,cmax,ctid,* from a_constants_str
whereconstname='DOCPLAID';<br />   oid  |  xmin   |  cmin   |  xmax   | cmax |  ctid  | constname | fid | constvalue
<br/> -------+---------+---------+---------+------+--------+-----------+-----+------------<br />  17916 | 2232893 |
2235861| 2235861 |   42 | (4,71) | DOCPLAID  |   0 | SOF_19738<br />  17916 | 2232893 | 2235861 | 2235861 |   41 |
(7,62)| DOCPLAID  |   0 | SOF_19738<br /> (2 rows)<br /><br /> regards,<br /> ivan.<br />