Re: programmatically retrieve details of a custom Postgres type

2022-11-11 Thread Konstantin Izmailov
Thank you, Pavel and Tom! It works great! On Thu, Nov 10, 2022 at 9:30 PM Tom Lane wrote: > I wrote: > > For a composite type, pg_type.typrelid links to pg_class and pg_attribute > > entries that work much like a table. > > Actually, you could reverse that: for a table, pg_type.typrelid links to

programmatically retrieve details of a custom Postgres type

2022-11-10 Thread Konstantin Izmailov
Hello, I was unable to find how to get column names, sizes and types for a given composite type. Example. For a type defines as: CREATE TYPE inventory_item AS ( name text, supplier_id integer, price numeric ); I have a plpgsql stored proc that returns SETOF inventory_item (i.e. there is n

Re: COPY command returns "ERROR: invalid XML content"

2019-10-07 Thread Konstantin Izmailov
Please ignore this thread. After several days of debugging I found bug in my application. It was misalignment of data when internal buffers reallocated. After the application fix it all works as expected. Sorry for the false alarm. On Mon, Oct 7, 2019 at 7:03 PM Konstantin Izmailov wrote

Re: COPY command returns "ERROR: invalid XML content"

2019-10-07 Thread Konstantin Izmailov
that someone came across similar issue, and bring some insight. I continue researching the issue. On Mon, Oct 7, 2019 at 5:13 AM Tomas Vondra wrote: > On Sun, Oct 06, 2019 at 08:45:40PM -0700, Konstantin Izmailov wrote: > >Hi, > >I'm using libpq (v10) to import lots of xml f

COPY command returns "ERROR: invalid XML content"

2019-10-06 Thread Konstantin Izmailov
Hi, I'm using libpq (v10) to import lots of xml files into a PG10 table. I noticed if number of records imported exceeds 2100 then the following error is returned: ERROR: invalid XML content DETAIL: line 1: Couldn't find end of Start Tag timeBasedFileNamingAndTriggerin line 1 logFile.%d{-MM-d

Re: assembling PGresults from multiple simultaneous queries (libpq, singlerowmode)

2019-04-07 Thread Konstantin Izmailov
Got it! Thanks!

Re: assembling PGresults from multiple simultaneous queries (libpq, singlerowmode)

2019-04-07 Thread Konstantin Izmailov
Never mind, I found the link to the github in emails from the link. Thanks again! Konstantin On Sun, Apr 7, 2019 at 1:28 PM Konstantin Izmailov wrote: > Yes, Andres, I meant "pipelining", just couldn't choose correct word. > Thank you for the answer(s)! > > I also

Re: assembling PGresults from multiple simultaneous queries (libpq, singlerowmode)

2019-04-07 Thread Konstantin Izmailov
ch with mine. I couldn't figure out how to get the patch from the link. Thanks so much! On Sun, Apr 7, 2019 at 12:21 PM Andres Freund wrote: > Hi, > > On 2019-04-07 20:57:56 +0200, Pavel Stehule wrote: > > ne 7. 4. 2019 v 20:47 odesílatel Konstantin Izmailov > > naps

assembling PGresults from multiple simultaneous queries (libpq, singlerowmode)

2019-04-07 Thread Konstantin Izmailov
Hi, I'm experimenting with Postgres 10 and protocol v3. I noticed that the Postgres allows executing multiple queries simultaneously (I basically commented out a check that prevents sending another query in libpq while previous result(s) reading is not complete). Things appear like working, but I j

Re: is libpq and openssl 1.1.* compatible?

2018-02-26 Thread Konstantin Izmailov
Thank you everyone who posted answers! I went back to openssl-1.0.2. On Mon, Feb 26, 2018 at 1:15 AM, Michael Paquier wrote: > On Mon, Feb 26, 2018 at 12:30:38AM -0700, Konstantin Izmailov wrote: > > Let me ask this differently: can Visual Studio 2013/2017 compile libpq > with >

Re: is libpq and openssl 1.1.* compatible?

2018-02-25 Thread Konstantin Izmailov
? Magnus please. On Sun, Feb 25, 2018 at 10:44 PM, Michael Paquier wrote: > On Sun, Feb 25, 2018 at 09:06:39PM -0800, Adrian Klaver wrote: > > On 02/25/2018 08:36 PM, Konstantin Izmailov wrote: > >> I wonder if I'm not doing smth right, or libpq is not compatible with > &

is libpq and openssl 1.1.* compatible?

2018-02-25 Thread Konstantin Izmailov
I got the latest libpq (from pg 10.1), and tried to compile it with openssl 1.1. I got errors: libpq10\fe-secure-openssl.c(1582): error C2037: left of 'ptr' specifies undefined struct/union 'bio_st' libpq10\fe-secure-openssl.c(1582): error C2198: 'pqsecure_raw_read' : too few arguments for call lib