Re: FDW for PostgreSQL

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