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

From Andrus
Subject Re: permission denied for large object 200936761
Date
Msg-id b140314e-c4c5-8ba6-69b7-969f9e160391@hot.ee
Whole thread Raw
In response to permission denied for large object 200936761  (Andrus <kobruleht2@hot.ee>)
Responses Re: permission denied for large object 200936761
List 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.

pgsql-general by date:

Previous
From: "Markhof, Ingolf"
Date:
Subject: RE: Foreign table performance issue / PostgreSQK vs. ORACLE
Next
From: Martín Marqués
Date:
Subject: Re: vacuum is time consuming