| From: | Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com> |
|---|---|
| To: | Lonni J Friedman <netllama(at)gmail(dot)com> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: 9.3-beta postgres-fdw COPY error |
| Date: | 2013-06-21 18:20:22 |
| Message-ID: | 89CBF1EE-CBBB-4DFF-8125-B7D6EF059E0C@enterprisedb.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Jun 21, 2013, at 1:56 PM, Lonni J Friedman <netllama(at)gmail(dot)com> wrote:
> I was afraid someone would say that. Is this a limitation that might
> be removed in the future (like 9.4), or is there a technical reason
> why its not possible to do a COPY against a foreign table?
I think reason is, FDW is a way of representation of foreign table in your current database. And when you take logical backup (pg_dump), you actually dump the definition of representation, not table. And if its allowed then, in my view you are losing the idea of representation with idea of actually creating that table in database.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Postgres Database Company
Blog:http://vibhork.blogspot.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hartrc | 2013-06-21 18:58:27 | PostgreSQL 9.1.10 release date? |
| Previous Message | Adrian Klaver | 2013-06-21 18:05:47 | Re: 9.3-beta postgres-fdw COPY error |