BUG #13978: xmin,xmax not current for foreign table

From: digoal(at)126(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13978: xmin,xmax not current for foreign table
Date: 2016-02-23 03:29:16
Message-ID: 20160223032916.8552.92982@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13978
Logged by: digoal
Email address: digoal(at)126(dot)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)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2016-02-23 03:38:29 Re: BUG #13978: xmin,xmax not current for foreign table
Previous Message David G. Johnston 2016-02-22 22:05:45 Re: BUG #13976: how to declare an empty password on .pgpass file