From: | Lukáš Sobotka <sobotka(dot)luk(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Trouble with postgres_fdw & dblink extensions |
Date: | 2018-11-15 23:23:41 |
Message-ID: | CAJif3kL6tKJG+JS3N2oBiwOB7Nxa8a9yKvo6uLe30UYQuHKKDQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi guys,
I would be grateful for some help. I am writing you because I am confused
about using data foreign wrappers and dblink. I attached simplified script
describing the problem.
What I am trying to do?
I have two databases and I need to copy table from local database to the
remote one. For copying is used function which contains a few parts:
-
loading setting from foreign table (this part became a problematic)
-
creating destination table on remote db
-
importing foreign table
-
insert data into foreign table
If query using foreign table (with setting) is performed, command for
importing schema does not import new created table (it looks like table is
not created yet). So copying ends with error. The second calling of
function is all right (because destination table is already created from
first calling).
If function does not use foreign table, the first calling of function
copies all data.
Why the new created remote table can not be imported to local database when
I had performed query on other foreign table? What am I missing?
I am using PG 9.6 (PostgreSQL 9.6.10 on x86_64-pc-linux-gnu, compiled by
gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-28), 64-bit).
Best regards, Lukas
Attachment | Content-Type | Size |
---|---|---|
script.sql | application/sql | 2.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2018-11-15 23:45:21 | Re: Trouble with postgres_fdw & dblink extensions |
Previous Message | Thomas Munro | 2018-11-15 22:05:43 | Re: Impact on PostgreSQL due to Redhat acquisition by IBM |