Re: Merge statement - Mailing list pgsql-admin

From Keith
Subject Re: Merge statement
Date
Msg-id CAHw75vtAm-AGneOYLJ97QU=p-bxYaSnn1azwUZPonqjT1DBH5Q@mail.gmail.com
Whole thread Raw
In response to Re: Merge statement  (Pepe TD Vo <pepevo@yahoo.com>)
Responses Re: Merge statement  (Pepe TD Vo <pepevo@yahoo.com>)
List pgsql-admin


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.


If you need UPSERT like behavior, look at the INSERT ... ON CONFLICT statement.

pgsql-admin by date:

Previous
From: Pepe TD Vo
Date:
Subject: Re: Merge statement
Next
From: Pepe TD Vo
Date:
Subject: Re: Merge statement