X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id ACA148BA282
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 17 Feb 2005 17:36:24 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 84060-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 17 Feb 2005 17:36:21 +0000 (GMT)
Received: from unisoft.unisoftbg.com (unisoft.unisoftbg.com [194.12.229.193])
	by svr1.postgresql.org (Postfix) with SMTP id 62EDC8BA2CB
	for <pgsql-sql@postgresql.org>; Thu, 17 Feb 2005 17:36:18 +0000 (GMT)
Received: (qmail 35556 invoked by uid 1011); 17 Feb 2005 17:39:36 -0000
Received: from pginfo@t1.unisoftbg.com by unisoft.unisoftbg.com by uid 1009
	with qmail-scanner-1.22-st-qms (clamdscan: 0.75. spamassassin: 2.60.
	Clear:RC:0(192.168.1.201):SA:0(-4.7/5.0):.
	Processed in 15.381906 secs); 17 Feb 2005 17:39:36 -0000
X-Antivirus-MYDOMAIN-Mail-From: pginfo@t1.unisoftbg.com via
	unisoft.unisoftbg.com
X-Antivirus-MYDOMAIN: 1.22-st-qms (Clear:RC:0(192.168.1.201):SA:0(-4.7/5.0):.
	Processed in 15.381906 secs Process 35548)
Received: from unknown (HELO t1.unisoftbg.com)
	(pginfo@t1.unisoftbg.com@192.168.1.201)
	by unisoft.unisoftbg.com with SMTP; 17 Feb 2005 17:39:20 -0000
Message-ID: <4214C94F.2050806@t1.unisoftbg.com>
Date: Thu, 17 Feb 2005 17:41:51 +0100
From: pginfo <pginfo@t1.unisoftbg.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.0.1) Gecko/20020823 Netscape/7.0
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Richard_D_Levine@raytheon.com,
	Michael Glaesemann <grzm@myrealbox.com>, pgsql-sql@postgresql.org,
	pgsql-sql-owner@postgresql.org
Subject: Re: pg primary key bug?
References: <OFEF67063C.F61988F3-ON05256F9D.005A91D6@ftw.us.ray.com>
	<4214B466.20908@t1.unisoftbg.com> <8125.1108661189@sss.pgh.pa.us>
Content-Type: multipart/alternative;
	boundary="------------020704050408020801060300"
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=2.133 tagged_above=0 required=5 tests=AWL, HTML_50_60,
	HTML_MESSAGE, HTML_TITLE_EMPTY, RCVD_IN_XBL
X-Spam-Level: **
X-Archive-Number: 200502/194
X-Sequence-Number: 20305


--------------020704050408020801060300
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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.

--------------020704050408020801060300
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <title></title>
</head>
<body>
Hi,<br>
<br>
Tom Lane wrote:<br>
<blockquote type="cite" cite="mid8125.1108661189@sss.pgh.pa.us">
  <pre wrap="">pginfo <a class="moz-txt-link-rfc2396E" href="mailto:pginfo@t1.unisoftbg.com">&lt;pginfo@t1.unisoftbg.com&gt;</a> writes:
  </pre>
  <blockquote type="cite">
    <pre wrap="">01=# select * from a_constants_str where constname='DOCPLAID' ;
 constname | fid | constvalue
-----------+-----+------------
 DOCPLAID  |   0 | SOF_19738
 DOCPLAID  |   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>
&nbsp; oid&nbsp;&nbsp; |&nbsp; xmin&nbsp;&nbsp; |&nbsp; cmin&nbsp;&nbsp; |&nbsp; xmax&nbsp;&nbsp; |&nbsp; cmax&nbsp;&nbsp; |&nbsp; ctid&nbsp;&nbsp; | constname | fid
| constvalue <br>
--------+---------+---------+---------+---------+---------+-----------+-----+------------<br>
&nbsp; 17910 |&nbsp;&nbsp; 22331 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 |&nbsp;&nbsp; 26679 |&nbsp;&nbsp; (0,7) | ANMGRID&nbsp;&nbsp; |&nbsp;&nbsp;
0 | SOF_10<br>
&nbsp; 17908 |&nbsp;&nbsp;&nbsp;&nbsp; 985 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp; (0,18) | AKLTYPID&nbsp; |&nbsp;&nbsp;
0 | SOF_3<br>
&nbsp; 17907 |&nbsp;&nbsp;&nbsp;&nbsp; 985 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp; (0,21) | ADARID&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;
0 | SOF_2<br>
&nbsp; 17921 |&nbsp;&nbsp;&nbsp;&nbsp; 985 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 34 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 34 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp; (0,22) | AOBLASTID |&nbsp;&nbsp;
0 | SOF_3<br>
&nbsp; 17911 |&nbsp;&nbsp;&nbsp; 4640 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6 |&nbsp;&nbsp; 26679 |&nbsp; (0,24) | AACCGRID&nbsp; |&nbsp;&nbsp;
0 | SOF_3<br>
&nbsp; 17920 | 1220598 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 | 1475630 |&nbsp; (0,47) | ASLUID&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;
0 | SOF_17<br>
&nbsp; 17917 |&nbsp; 643083 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 | 1475630 |&nbsp; (0,49) | LOCAID&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;
0 | SOF_13<br>
&nbsp; 17918 |&nbsp; 762851 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3 | 1475630 |&nbsp; (0,50) | AUSERID&nbsp;&nbsp; |&nbsp;&nbsp;
0 | SOF_3<br>
&nbsp; 17923 |&nbsp;&nbsp; 35539 |&nbsp;&nbsp;&nbsp;&nbsp; 165 |&nbsp;&nbsp;&nbsp;&nbsp; 165 | 1475630 |&nbsp; (0,51) | ASETUPID&nbsp; |&nbsp;&nbsp;
0 | SOF_399<br>
&nbsp;283686 |&nbsp; 514327 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3 | 1475630 |&nbsp; (0,52) | NASTRF&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;
0 | SOF_1<br>
&nbsp; 17909 | 2156667 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 | 2193198 |&nbsp; (0,54) | AKLGRID&nbsp;&nbsp; |&nbsp;&nbsp;
0 | SOF_8<br>
&nbsp; 17922 | 2103298 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 | 2193198 |&nbsp; (0,55) | AGRADID&nbsp;&nbsp; |&nbsp;&nbsp;
0 | SOF_165<br>
&nbsp; 17913 | 2092705 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 | 2193198 |&nbsp; (0,56) | ANOMID&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;
0 | SOF_747<br>
&nbsp; 63247 | 2226373 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 | 2233003 | (0,126) | TDOCID&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;
0 | SOF_47<br>
&nbsp; 17914 | 2232893 | 2235861 | 2235861 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3 | (1,125) | DOCID&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;
0 | SOF_25658<br>
&nbsp; 17915 | 2232893 | 2235861 | 2235861 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 19 |&nbsp; (3,38) | DOCRID&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;
0 | SOF_184547<br>
&nbsp; 17916 | 2232893 | 2235861 | 2235861 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 42 |&nbsp; (4,71) | DOCPLAID&nbsp; |&nbsp;&nbsp;
0 | SOF_19738<br>
&nbsp; 17919 | 2232893 |&nbsp;&nbsp;&nbsp;&nbsp; 231 |&nbsp;&nbsp;&nbsp;&nbsp; 231 | 2233003 | (5,104) | DOCPOGPLA |&nbsp;&nbsp;
0 | SOF_24281<br>
&nbsp; 17912 | 2231139 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 |&nbsp;&nbsp; (6,1) | AKLIID&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;
0 | SOF_3513<br>
&nbsp; 17916 | 2232893 | 2235861 | 2235861 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 41 |&nbsp; (7,62) | DOCPLAID&nbsp; |&nbsp;&nbsp;
0 | SOF_19738<br>
&nbsp; 63249 | 2226373 |&nbsp;&nbsp;&nbsp;&nbsp; 103 |&nbsp;&nbsp;&nbsp;&nbsp; 103 |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 | (16,31) | TDOCRID&nbsp;&nbsp; |&nbsp;&nbsp;
0 | SOF_2439<br>
(21 rows)<br>
<br>
and <br>
<br>
01=# select oid,xmin,cmin,xmax,cmax,ctid,* from a_constants_str where constname='DOCPLAID';<br>
&nbsp; oid&nbsp; |&nbsp; xmin&nbsp;&nbsp; |&nbsp; cmin&nbsp;&nbsp; |&nbsp; xmax&nbsp;&nbsp; | cmax |&nbsp; ctid&nbsp; | constname | fid |
constvalue <br>
-------+---------+---------+---------+------+--------+-----------+-----+------------<br>
&nbsp;17916 | 2232893 | 2235861 | 2235861 |&nbsp;&nbsp; 42 | (4,71) | DOCPLAID&nbsp; |&nbsp;&nbsp; 0 |
SOF_19738<br>
&nbsp;17916 | 2232893 | 2235861 | 2235861 |&nbsp;&nbsp; 41 | (7,62) | DOCPLAID&nbsp; |&nbsp;&nbsp; 0 |
SOF_19738<br>
(2 rows)<br>
<br>
regards,<br>
ivan.<br>
</body>
</html>

--------------020704050408020801060300--