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)
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 |