Re: permission denied for large object 200936761

Поиск
Список
Период
Сортировка
От Andrus
Тема Re: permission denied for large object 200936761
Дата
Msg-id 00d9c25a-8336-adbd-45da-37c946edb9a4@hot.ee
обсуждение исходный текст
Ответ на Re: permission denied for large object 200936761  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Hi!

I don't suppose this was done in a structured way that could be gone back over?

Accidently  '200936767'::lo cast was issued :

INSERT INTO report ( ...  ) values (.. , '200936767'::lo, ... )

server throws error   type "lo" does not exist for this.

Maybe this causes orphan large object creation by server or by odbc driver. How to fix this ?

report table shoud not have lo type columns. No idea why this cast is generated using psqlodbc

Andrus.

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

Предыдущее
От: Andrus
Дата:
Сообщение: Re: permission denied for large object 200936761
Следующее
От: unilynx
Дата:
Сообщение: Index created with PGSQL11 on ubuntu 18.04 corrupt with PGSQL11 on ubuntu 20.04