On 21 February 2013 10:30, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Shigeru Hanada <shigeru.hanada@gmail.com> writes:
>> [ postgres_fdw.v5.patch ]
>
> Applied with a lot of revisions.
Bit of an issue with selecting rows:
postgres=# SELECT * FROM animals;id | animal_name | animal_type | lifespan
----+-------------+-------------+---------- 1 | cat | mammal | 20 2 | dog | mammal |
12 3 | robin | bird | 12 4 | dolphin | mammal | 30 5 | gecko | reptile |
18 6 | human | mammal | 85 7 | elephant | mammal | 70 8 | tortoise | reptile
| 150
(8 rows)
postgres=# SELECT animals FROM animals;animals
---------(,,,)(,,,)(,,,)(,,,)(,,,)(,,,)(,,,)(,,,)
(8 rows)
postgres=# SELECT animals, animal_name FROM animals; animals | animal_name
---------------+-------------(,cat,,) | cat(,dog,,) | dog(,robin,,) | robin(,dolphin,,) |
dolphin(,gecko,,) | gecko(,human,,) | human(,elephant,,) | elephant(,tortoise,,) | tortoise
(8 rows)
postgres=# EXPLAIN (ANALYSE, VERBOSE) SELECT animals FROM animals;
QUERYPLAN
-----------------------------------------------------------------------------------------------------------------Foreign
Scanon public.animals (cost=100.00..100.24 rows=8 width=45)
(actual time=0.253..0.255 rows=8 loops=1) Output: animals.* Remote SQL: SELECT NULL, NULL, NULL, NULL FROM
public.animalsTotalruntime: 0.465 ms
(4 rows)
--
Thom
