Re: Foreign table permissions and cloning

On Fri, Apr 1, 2011 at 5:13 AM, Thom Brown <thom@linux.com> wrote:
> On 1 April 2011 12:57, Shigeru HANADA <hanada@metrosystems.co.jp> wrote:
>> NOT NULL constraint on foreign table is just declaration and can't
>> force data integrity.  And I noticed that CREATE FOREIGN TABLE
>> document doesn't mention that serial and bigserial can't be used in
>> foreign table.  Please see foreign_table_doc.patch for this fix.
>
> I'd be inclined to generalise it to say that default values can't be
> used on a foreign table, and then say that as a result, serial and
> bigserial can't be used.

+1.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company