Re: Column defaults for foreign tables (was Re: [v9.3] writable foreign tables) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Column defaults for foreign tables (was Re: [v9.3] writable foreign tables)
Date
Msg-id 9848.1363219149@sss.pgh.pa.us
Whole thread Raw
In response to Re: Column defaults for foreign tables (was Re: [v9.3] writable foreign tables)  (Thom Brown <thom@linux.com>)
List pgsql-hackers
Thom Brown <thom@linux.com> writes:
> How about:

> CREATE FOREIGN TABLE tablename (id int DEFAULT PASSTHROUGH) SERVER pg_server;

> That way it will pass DEFAULT through to the remote table as it's
> defined on the table.  Users can then explicitly insert values, or
> select the default, which will configured to ensure the default on the
> remote server is used... although I suspect I'm overlooking something
> here.

Yeah ... how to implement it.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Using indexes for partial index builds
Next
From: Jim Nasby
Date:
Subject: Re: Temporal features in PostgreSQL