Re: Binary large object processing problems

2023-03-13 Thread Raivo Rebane
Ok, I will do that. ANd it works now in both way Regards Raivo On Mon, Mar 13, 2023 at 6:18 PM Tom Lane wrote: > Raivo Rebane writes: > > Thank for answer, but I was also readed this manual and found there : > > 35.3.2. Importing a Large Object > > You need to read the start of that section, w

Re: Binary large object processing problems

2023-03-13 Thread Tom Lane
Raivo Rebane writes: > Thank for answer, but I was also readed this manual and found there : > 35.3.2. Importing a Large Object You need to read the start of that section, which says All large object manipulation using these functions must take place within an SQL transaction block, As

Re: Binary large object processing problems

2023-03-13 Thread Raivo Rebane
Thank for answer, but I was also readed this manual and found there : 35.3.2. Importing a Large Object To import an operating system file as a large object, call Oid lo_import(PGconn *conn, const char *filename); *filename* specifies the operating system name of the file to be imported as a larg

Re: Binary large object processing problems

2023-03-13 Thread Christoph Moench-Tegeder
## Raivo Rebane (raivor...@gmail.com): > Can anybody help me find where is my mistake an what is working solution ? The documentation clearly states "All large object manipulation using these functions must take place within an SQL transaction block" https://www.postgresql.org/docs/current/lo-int

Binary large object processing problems

2023-03-13 Thread Raivo Rebane
Hi I am novice in pogres C API user and I want to store Binary Large Object into database from C language program. I am using following source : Oid nloid = lo_import(conn, FileFUllName.c_str()); if (nloid == 0) { std::cerr << "Error importing large object: " << PQerrorMessage(conn) << std::endl