On Tue, 23 Nov 2010 12:30:52 +0200
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> wrote:
> The docs need some work. The CREATE FOREIGN TABLE reference page seems
> to be copy-pasted from CREATE TABLE, because it talks about constraints
> and WITH/WITHOUT OIDS which surely don't apply to foreign tables.
Thanks for the comments.
The page you pointed has been edited for foreign table. In current
design, OID system column and CHECK constraints are supported.
OID is supported to get oid from the source table (yes, it works only
for postgresql_fdw but it seems useful to support). CHECK constraint
is supported to enable constraint exclusion. In addition, TABLEOID is
supported to show which table is the actual source.
I agree that some kind of documents, such as "How to create new FDW",
should be written.
Regards,
--
Shigeru Hanada