Questions tagged [largeobject]
7 questions
2
votes
1 answer
SQL Error [42704]: ERROR: large object xxxxxxx does not exist
I had a table with large object.
When I want to delete a row. I have an error: SQL Error [42704]:
ERROR: large object 123456 does not exist.
I checked in pg_largeobject and I didn't find a row with id = '123456'.
How can I delete an row which has a…
Gherta Nicolae
- 23
- 4
1
vote
2 answers
how to download larger binary object from postgres using nodejs express?
I have node js rest api script to query from Postgres tables. It's working fine, but When I try to fetch a large objects using "lo_get" of Postgres, I get
JavaScript heap out of memory
Below is the toy example.
index.js
const express =…
Monu
- 2,092
- 3
- 13
- 26
0
votes
0 answers
Taking too much time to fetch the data from Azure postgreSQL Large objects (pg_largeobjects)
We have bytea data stored in pg_largeobjects (Large objects table)
Here the data is 675 MB. We are using Large objects client interface API provided by postgreSQL to retrieve the data (lo_read, lo_open etc)
When I try to fetch the data from local it…
Dev-eloper
- 21
- 1
- 4
0
votes
1 answer
Postgres migrate from large object to normal column
We have a postgres database with a table with about 20K rows.
The software is written in java/spring using jpa and developers used large object (@Lob) to store some long strings without worry to the lenght but now, especially with quite large row…
Davide C
- 830
- 2
- 11
- 21
0
votes
0 answers
Reducing Pg_largeobject size in AWS RDS
We have RDS PostgreSQL database orignally-35GB (now extended to 60 GB). All our core tables not occupying more than 20mb space but our Pg_largeobject occupies -35Gb though we are not having any blob storage.
1.Want to know what actually fills the…
Arun
- 15
- 4
0
votes
1 answer
Does PostgreSQL use pg_largeobject table internally?
I want to clean all large objects created by users and I'm using the following script:
SELECT lo_unlink(l.loid) FROM pg_largeobject l
Is it safe operation? Does postgresql use large objects for it's internal use?
Thanks.
alexlys
- 49
- 5
0
votes
1 answer
Read/write large object from postgres using pqxx
The main pqxx API works with columns as text. So how to access binary data from large objects (LOB) using the pqxx library?
loshad vtapkah
- 429
- 4
- 11