Re: TRUNCATE and CREATE TABLE LIKE for foreign tables

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "sri harsha *EXTERN*" <sriharsha9992(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: TRUNCATE and CREATE TABLE LIKE for foreign tables
Date: 2014-12-03 11:40:27
Message-ID: A737B7A37273E048B164557ADEF4A58B17DA7699@ntex2010a.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

sri harsha wrote:
> Is it possible to implement TRUNCATE and CREATE TABLE LIKE for a foreign table. Is there anyway i
> can write a function to implement those queries in my FDW ??

This is currently not possible, it would need an extension to the FDW API.

If you can come up with a good design, lobby for it in the hackers mailing list.

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2014-12-03 14:28:54 Re: Trying to get SSPI/JDBC working
Previous Message Craig Ringer 2014-12-03 11:22:30 Re: Fwd: [GENERAL] Trying to get SSPI/JDBC working