Horton
Menu

Re: Column defaults for foreign tables (was Re: [v9.3] writable foreign tables)

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thom Brown <thom@linux.com>
Cc: Albe Laurenz <laurenz.albe@wien.gv.at>, "pgsql-hackers@postgreSQL.org" <pgsql-hackers@postgresql.org>
Date: 2013-03-13T23:59:09Z
Lists: 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

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Fix postgres_fdw's issues with inconsistent interpretation of data values.