Search Postgresql Archives

Re: pg_temp schema created while using DB Link

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, 2020-05-08 at 10:11 +0400, Jill Jade wrote:
> 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  
> 
> 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?

These schemas contain temporary tables and are not connected to your connection
from Oracle (unless you create temporary tables via that connection).

They are an implementation detail and should not bother you.

What is your problem with these schemmas?

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux