From: Thomas Kellerer <shammat@gmx.net>
To: Pgsql Performance <pgsql-performance@lists.postgresql.org>
Subject: Re: Out of memory error
Date: Wed, 24 Nov 2021 13:10:45 +0100
Message-ID: <a772e833-1c0f-4cae-4d08-04bfdfb2fb5e@gmx.net> (raw)
In-Reply-To: <CAN0SRDGEJ32wrqizdY_7KVQztOuvmn9+Mbw2_m6LqOU0AOgpOA@mail.gmail.com>
References: <CAN0SRDGg3-wH+y7bNvJQa7cdR4wY+7AqoeHbV0urVfBCszSCqg@mail.gmail.com>
<97240.1637733158@sss.pgh.pa.us>
<CAN0SRDGZeRyxcB-LWKjNQSi0O3tcK_xKPZdhaLvj_8+sbNPoBA@mail.gmail.com>
<4af2ff21-1140-ccbd-5adf-926dc816782f@gmx.net>
<CAN0SRDGEJ32wrqizdY_7KVQztOuvmn9+Mbw2_m6LqOU0AOgpOA@mail.gmail.com>
aditya desai schrieb am 24.11.2021 um 08:35:
> Hi Thomas,
> v_message is of composite data type r_log_message and it's definition is as shown below.
>
> postgres=# \d r_log_message;
> Composite type "public.r_log_message"
> Column | Type | Collation | Nullable | Default
> -------------+-------------------------+-----------+----------+---------
> column_name | character varying(30) | | |
> oldvalue | character varying(4000) | | |
> newvalue | character varying(4000) | | |
>
> Regards,
> Aditya.
Sorry, didn't see that.
Then you need to create records of that type in the array:
v_message := array[('empName', old.empname, new.empname)::r_log_message, ('location', old.location, new.location)::r_log_message];
or an array of that type:
v_message := array[('empName', old.empname, new.empname), ('location', old.location, new.location)]::r_log_message[];
Btw: why don't you use `text` instead of varchar(4000).
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: shammat@gmx.net, pgsql-performance@lists.postgresql.org
Subject: Re: Out of memory error
In-Reply-To: <a772e833-1c0f-4cae-4d08-04bfdfb2fb5e@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox