| From: | Keith <keith(at)keithf4(dot)com> |
|---|---|
| To: | Pepe TD Vo <pepevo(at)yahoo(dot)com> |
| Cc: | Morris de Oryx <morrisdeoryx(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Merge statement |
| Date: | 2019-09-23 14:48:39 |
| Message-ID: | CAHw75vtAm-AGneOYLJ97QU=p-bxYaSnn1azwUZPonqjT1DBH5Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, Sep 23, 2019 at 10:34 AM Pepe TD Vo <pepevo(at)yahoo(dot)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.
https://www.postgresql.org/docs/current/index.html
If you need UPSERT like behavior, look at the INSERT ... ON CONFLICT
statement.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pepe TD Vo | 2019-09-23 15:48:06 | Re: Merge statement |
| Previous Message | Pepe TD Vo | 2019-09-23 14:34:23 | Re: Merge statement |