Re: [SQL] pg primary key bug?

[pginfo]

Hi,

Tom Lane wrote:

pginfo <[EMAIL PROTECTED]> 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.