SQL/MED - FDW API

Lists: pgsql-hackers
From: Shigeru HANADA <hanada(at)metrosystems(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: SQL/MED - FDW API
Date: 2011-01-12 12:11:22
Message-ID: 20110112211121.827B.6989961C@metrosystems.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Attached are WIP version of patches for FDW API. Basically not
changed from last version but rebased to current HEAD.

To make review easier, I split core functionality into 3 patches.
Please apply these patches in the following order.

1) fdw_handler - this patch adds HANDLER option to both syntax and
catalog of FOREIGN DATA WRAPPER.

2) foreign_scan - this patch adds following: ForeignScan executor-node,
hooks in planner and executor, and FdwRoutine (FDW API).

3) catalog_lookup - this patch adds GetForeignTable() whicch returns
ForeignTable object, similar to GetForeignDataWrapper(),
GetForeignServer(), and GetUserMapping(). This function is assumed to
be used by FDWs.

You would be able to test these patches with file_fdw wrapper which
would be posted in another thread.

Regards,
--
Shigeru Hanada

Attachment Content-Type Size
fdw_handler.patch.gz application/octet-stream 8.0 KB
foreign_scan.patch.gz application/octet-stream 11.8 KB
catalog_lookup.patch.gz application/octet-stream 948 bytes

From: Shigeru HANADA <hanada(at)metrosystems(dot)co(dot)jp>
To: Shigeru HANADA <hanada(at)metrosystems(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: SQL/MED - FDW API
Date: 2011-01-14 12:23:59
Message-ID: 20110114212358.82C7.6989961C@metrosystems.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Attached are rebased version of patches for FDW API.

To make review easier, I split core functionality into 3 patches.
Please apply these patches in the following order.

1) fdw_handler - this patch adds HANDLER option to both syntax and
catalog of FOREIGN DATA WRAPPER.

2) foreign_scan - this patch adds following: ForeignScan executor-node,
hooks in planner and executor, and FdwRoutine (FDW API).

3) fdw_catalog_lookup - this patch adds GetForeignTable() whicch
returns ForeignTable object, similar to GetForeignDataWrapper(),
GetForeignServer(), and GetUserMapping(). This function is assumed to
be used by FDWs.

You would be able to test these patches with "20110114" version of file_fdw
wrapper patches which will be posted in another thread.

Regards,
--
Shigeru Hanada

Attachment Content-Type Size
20110114-fdw_handler.patch.gz application/octet-stream 8.4 KB
20110114-foreign_scan.patch.gz application/octet-stream 12.1 KB
20110114-fdw_catalog_lookup.patch.gz application/octet-stream 979 bytes

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Shigeru HANADA <hanada(at)metrosystems(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: SQL/MED - FDW API
Date: 2011-01-14 19:59:00
Message-ID: 4D30AB04.3090601@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 01/14/2011 07:23 AM, Shigeru HANADA wrote:
> You would be able to test these patches with "20110114" version of file_fdw
> wrapper patches which will be posted in another thread.
>

Have you actually posted this version of file_fdw? I haven't seen it.

cheers

andrew


From: Shigeru HANADA <hanada(at)metrosystems(dot)co(dot)jp>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: SQL/MED - FDW API
Date: 2011-01-15 00:02:51
Message-ID: 20110115090250.82D7.6989961C@metrosystems.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On Fri, 14 Jan 2011 14:59:00 -0500
Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
> Have you actually posted this version of file_fdw? I haven't seen it.

Sorry, now it's been posted.
http://archives.postgresql.org/pgsql-hackers/2011-01/msg01205.php

Regarads,
--
Shigeru Hanada