Skip site navigation (1) Skip section navigation (2)


From: Shigeru Hanada <hanada(at)metrosystems(dot)co(dot)jp>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: FOREIGN TABLE doc fix
Date: 2011-06-09 10:11:59
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Hi hackers,

At first I've posted to pgsql-docs but there is no reply at present.

So I post revised patch to pgsql-hackers, because the patch is for
documents under development for 9.1 beta2. Please let me know if this
was wrong list to discuss these issues.

Attached patch includes fixes for FOREIGN TABLE documents:

1) "NOT NULL" should be added to syntax of ALTER FOREIGN TABLE ADD
COLUMN command.

2) Mentions about unsupported features should be removed from ALTER
FOREIGN TABLE document. They had been proposed but haven't been
committed for 9.1. These unsupported features are not mentioned in

  - table inheritance
  - oid system column
  - CHECK constraint
  - per-column FDW options

3) It would be useful to mention differences between ordinary tables and
foreign tables in CREATE FOREIGN TABLE document.

  - NOT NULL constraint is just for optimization, at least at present
  - serial/bigserial can't be used because they need default value

The description in the patch are based on the advice which were posted
by Thom Brown and Robert Haas in the thread:

Shigeru Hanada

Attachment: fix_foreign_table_doc.patch
Description: text/plain (5.9 KB)


pgsql-hackers by date

Next:From: Kohei KaiGaiDate: 2011-06-09 10:17:07
Subject: [v9.2] sepgsql - userspace access vector cache (Re: [v9.1] sepgsql - userspace access vector cache)
Previous:From: Pavan DeolaseeDate: 2011-06-09 09:26:02
Subject: Re: Autoanalyze and OldestXmin

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group