Yes, I heard MERGE is not a command in Postgres but the others said merge statement added stored procedures in version 11
I upgraded my postgresql from 10.6 to 11.1. in AWS, still not work.
thank you,
Bach-Nga
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
**Live simply **Love generously **Care deeply **Speak kindly.
*** Genuinely rich *** Faithful talent *** Sharing success
On Monday, September 23, 2019, 10:49:34 AM EDT, Keith <keith@xxxxxxxxxxx> wrote:
On Mon, Sep 23, 2019 at 10:34 AM Pepe TD Vo <pepevo@xxxxxxxxx> 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 variableLINE 14: MERGE INTO ecisdrdm.application_cdim prod^SQL state: 42601Character: 348v/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.
