On Mon, Sep 23, 2019 at 10:34 AM Pepe TD Vo <pepevo@yahoo.com> wrote:
good morning, happy Monday.
fyi, I upgraded postgres in AWS to 11.1 and the merge function for procedure is still not working. Still complained the same error that:
ERROR: "ecisdrdm.application_cdim" is not a known variable
LINE 14: MERGE INTO ecisdrdm.application_cdim prod
^
SQL state: 42601
Character: 348
v/r,
Bach-Nga
As others have said, MERGE is not a command in Postgres. The document you linked is a development document from a long time ago when it was proposed at one time, but it was never accepted. Please reference the actual PostgreSQL documentation.