Re: permission denied for large object 200936761

From: Andrus <kobruleht2(at)hot(dot)ee>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: permission denied for large object 200936761
Date: 2021-02-02 12:12:06
Message-ID: b140314e-c4c5-8ba6-69b7-969f9e160391@hot.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

> So? What is your point?
> Somebody created a large object of size 0.

report table has bytea column. It looks like  psqlodbc driver adds ::lo
cast  when inserting binary data:

https://github.com/hlinnaka/psqlodbc/blob/master/convert.c#L4564

and this adds row to pg_largeobject_metadata table.

Why it adds cast to lo type ? This type does not exist in Postgres
server and causes server error.

Andrus.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martín Marqués 2021-02-02 12:34:19 Re: vacuum is time consuming
Previous Message Markhof, Ingolf 2021-02-02 12:05:53 RE: Foreign table performance issue / PostgreSQK vs. ORACLE