Re: SQL/MED - core functionality

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 - core functionality
Date: 2010-12-15 13:25:41
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Hi hackers,

Attached are revised version of SQL/MED core functionality patches.

In order to make review easier, fdw_core patch has been split into
two parts, fdw_syntax and fdw_scan. Please apply fdw_scan onto
fdw_syntax to test whole features.

The fdw_syntax.patch includes:

# RULE, DEFAULT, and column level generic option are excluded to
# make the patch simple. But NOT NULL constraint is included
# because it is required to inherit a table with NOT NULL
# constraint.
2) modified catalogs, pg_foreign_table and pg_foreign_data_wrapper
3) documentation about the syntax (maybe need enhancement, though)
4) regression tests for the syntax
5) psql and pg_dump support for foreign tables and FDWs (handler)

And the fdw_scan.patch includes:

1) FDW API definition
2) ForeignScan executor node
3) Planner hook and Executor hooks
4) EXPLAIN support (included because it would effect to FdwPlan)

Note that executing SELECT and EXPLAIN statement requires FDW with
HANDLER, such as file_fdw and pgsql_fdw. New version of file_fdw will
be posted in another thread "SQL/MED - file_fdw" soon.

Shigeru Hanada

Attachment Content-Type Size
fdw_syntax.patch.gz application/octet-stream 54.1 KB
fdw_scan.patch.gz application/octet-stream 11.7 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message David Christensen 2010-12-15 13:43:19 Re: ALTER TABLE ... REPLACE WITH
Previous Message Greg Smith 2010-12-15 13:18:08 Re: Re: Proposed Windows-specific change: Enable crash dumps (like core files)