From: | Jasvant Singh <jasingh(at)watermarkinsights(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Unable to migrate from postgres-13 to 14 |
Date: | 2022-01-12 13:59:04 |
Message-ID: | CAPGEVuCaGPuybxLjtd0_tL8Ud4j9FFnLQLHhDPxx5sdAO3-pMQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I am trying to migrate my database from postgres-13 to 14 but getting
following error:
pg_restore: error: could not execute query: ERROR: function
array_append(anyarray, anyelement) does not exist
Command was: CREATE AGGREGATE "public"."mode"("anyelement") (
SFUNC = "array_append",
STYPE = "anyarray",
INITCOND = '{}',
FINALFUNC = "public"."_final_mode"
);
To work around this problem I decided to drop this aggregate in postgres-13
and create it again with the supported version of array_append in
postgres-14.
But when I tried to drop it in postgres-13 I got following error:
#drop aggregate mode("anyelement") CASCADE;
ERROR: cannot drop function mode(anyelement) because it is required by the
database system
I don't understand why the database system is using my user defined
aggregate. If it is a system defined aggregate then it should not be copied
from postgres-13 to postgres-14. It should be there in postgres-14.
Please suggest some work around.
Thanks,
Jasvant
From | Date | Subject | |
---|---|---|---|
Next Message | Дмитрий Иванов | 2022-01-12 14:32:36 | Re: How to read an external pdf file from postgres? |
Previous Message | Simon Riggs | 2022-01-12 13:17:17 | Re: pg_stat_statements |