pg_temp schema created while using DB Link

Поиск
Список
Период
Сортировка
От Jill Jade
Тема pg_temp schema created while using DB Link
Дата
Msg-id CABGmvVOpKsyUMAUdBpg+rZKqn4noVdjyFPLtSBrayxy1=QFoog@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_temp schema created while using DB Link
Список pgsql-general
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
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: github kran
Дата:
Сообщение: Re: AutoVacuum and growing transaction XID's
Следующее
От: github kran
Дата:
Сообщение: Re: AutoVacuum and growing transaction XID's