BUG #13978: xmin,xmax not current for foreign table - Mailing list pgsql-bugs

From digoal@126.com
Subject BUG #13978: xmin,xmax not current for foreign table
Date
Msg-id 20160223032916.8552.92982@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #13978: xmin,xmax not current for foreign table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      13978
Logged by:          digoal
Email address:      digoal@126.com
PostgreSQL version: 9.5.0
Operating system:   CentOS 6.x x64
Description:

tbl0 is a foreign table with postgres_fdw
master=# select tableoid,ctid,xmin,xmax,* from tbl0;
 tableoid |  ctid  | xmin |    xmax    | id | info |          crt_time

----------+--------+------+------------+----+------+----------------------------
    20304 | (0,11) |  192 | 4294967295 |  4 | test | 2016-02-23
11:25:20.440349
    20304 | (0,12) |  192 | 4294967295 |  8 | test | 2016-02-23
11:25:20.440349
(2 rows)

but the right values is:
db0=# select tableoid,ctid,xmin,xmax,* from tbl0;
 tableoid |  ctid  |   xmin   |   xmax   | id | info |          crt_time

----------+--------+----------+----------+----+------+----------------------------
    20280 | (0,11) | 38232587 | 38232588 |  4 | test | 2016-02-23
11:25:20.440349
    20280 | (0,12) | 38232587 | 38232588 |  8 | test | 2016-02-23
11:25:20.440349
(2 rows)

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #13976: how to declare an empty password on .pgpass file
Next
From: Tom Lane
Date:
Subject: Re: BUG #13978: xmin,xmax not current for foreign table