Subject: Re: Out of memory error
To: Pgsql Performance <pgsql-performance@lists.postgresql.org>
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>
From: Thomas Kellerer <shammat@gmx.net>
Message-ID: <a772e833-1c0f-4cae-4d08-04bfdfb2fb5e@gmx.net>
Date: Wed, 24 Nov 2021 13:10:45 +0100
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23)
 Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666
MIME-Version: 1.0
In-Reply-To: 
 <CAN0SRDGEJ32wrqizdY_7KVQztOuvmn9+Mbw2_m6LqOU0AOgpOA@mail.gmail.com>
Content-Type: text/plain; charset=utf-8
Content-Language: de-DE
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/a772e833-1c0f-4cae-4d08-04bfdfb2fb5e%40gmx.net>
Precedence: bulk

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=3D# \d r_log_message;
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Composite =
type "public.r_log_message"
> =C2=A0 =C2=A0Column=C2=A0 =C2=A0 |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Typ=
e=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| Collation | Nullable | Default
> -------------+-------------------------+-----------+----------+---------
> =C2=A0column_name | character varying(30)=C2=A0 =C2=A0|=C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0|=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 |
> =C2=A0oldvalue=C2=A0 =C2=A0 | character varying(4000) |=C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0|=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 |
> =C2=A0newvalue=C2=A0 =C2=A0 | character varying(4000) |=C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0|=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 |
>
> Regards,
> Aditya.

Sorry, didn't see that.

Then you need to create records of that type in the array:

   v_message :=3D array[('empName', old.empname, new.empname)::r_log_messa=
ge, ('location', old.location, new.location)::r_log_message];

or an array of that type:

   v_message :=3D 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).