Postgres Pro
Downloads
Home   >   mailing lists

pg_temp schema created while using DB Link - Mailing list pgsql-general

From Jill Jade
Subject pg_temp schema created while using DB Link
Date
Msg-id CABGmvVOpKsyUMAUdBpg+rZKqn4noVdjyFPLtSBrayxy1=QFoog@mail.gmail.com
Whole thread Raw
Responses Re: pg_temp schema created while using DB Link  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Tree view
Hello Everyone,

We have an issue with DB_Link from Oracle to PostgreSQL. When we try to access tables from Oracle database via DB_link, temp schemas(pg_temp,pg_toast) are automatically created in the database while using the query below.

create table as select * from table@oralink  

image.png

Even if we reload the database, the temp schemas are still there. 

Do you know the reason why the temp schemas are being created with DB_link?Does anyone has a solution for this problem?

Thank you

Regards,
Jill
Attachment

pgsql-general by date:

Previous
From: github kran
Date:
Subject: Re: AutoVacuum and growing transaction XID's
Next
From: github kran
Date:
Subject: Re: AutoVacuum and growing transaction XID's