From: | aditya desai <admad123(at)gmail(dot)com> |
---|---|
To: | Thomas Kellerer <shammat(at)gmx(dot)net> |
Cc: | Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Out of memory error |
Date: | 2021-11-24 14:32:59 |
Message-ID: | CAN0SRDHzbBk4N65aR+scXgJRgcybzr4kzR8kZ4cpbiyeNpSQjQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Thanks Thomas! Sorry to say this but ,this was migrated from Oracle to PG
:) and the app team just wants to keep the data type as it is :(
On Wed, Nov 24, 2021 at 5:40 PM Thomas Kellerer <shammat(at)gmx(dot)net> wrote:
> 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).
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Creager | 2021-11-24 21:13:27 | Re: Need help identifying a periodic performance issue. |
Previous Message | Tomas Vondra | 2021-11-24 12:22:00 | Re: Postgres process count GCC vs Clang is Different on autovaccum=on |