Re: FDW for PostgreSQL

On 21 February 2013 10:30, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Shigeru Hanada <shigeru(dot)hanada(at)gmail(dot)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;
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------
Foreign Scan on 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.animals
Total runtime: 0.465 ms
(4 rows)

--
Thom