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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thom Brown <thom(at)linux(dot)com>
Cc: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>, "pgsql-hackers(at)postgreSQL(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Column defaults for foreign tables (was Re: [v9.3] writable foreign tables)
Date: 2013-03-13 23:59:09
Message-ID: 9848.1363219149@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thom Brown <thom(at)linux(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim Nasby 2013-03-14 00:06:39 Re: Temporal features in PostgreSQL
Previous Message Jim Nasby 2013-03-13 23:51:28 Re: Using indexes for partial index builds