Re: permission denied for large object 200936761 - Mailing list pgsql-general

From Andrus
Subject Re: permission denied for large object 200936761
Date
Msg-id 00d9c25a-8336-adbd-45da-37c946edb9a4@hot.ee
Whole thread Raw
In response to Re: permission denied for large object 200936761  (Adrian Klaver <adrian.klaver@aklaver.com>)
List 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 by date:

Previous
From: Andrus
Date:
Subject: Re: permission denied for large object 200936761
Next
From: unilynx
Date:
Subject: Index created with PGSQL11 on ubuntu 18.04 corrupt with PGSQL11 on ubuntu 20.04