Trouble with postgres_fdw & dblink extensions

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

Responses

Browse pgsql-general by date

  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