phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergey Soldatov <sergeysolda...@gmail.com>
Subject Re: how to update cache_size in SYSTEM."SEQUENCE"
Date Mon, 06 Nov 2017 18:42:13 GMT
Well, the regular way how to do that is :
upsert into TABLE (pk1, pk2, pk3, column_to_change) select pk1, pk2, pk3,
'new_value' from TABLE where ...

So you have to provide ALL columns for PK.

Thanks,
Sergey

On Mon, Nov 6, 2017 at 8:04 AM, Adi Kadimetla <kadimetla@gmail.com> wrote:

> Hi Team,
>
> I need help  to update cache_size in SYSTEM."SEQUENCE" for a
> SEQUENCE_NAME.  I tried below upsert command but there is no upsert syntax
> with where clause.
>
>
> upsert into SYSTEM."SEQUENCE"(CACHE_SIZE) VALUES(0) where
> SEQUENCE_NAME='SUBSCRIPTION_SEQUENCE'
>
> Thanks
>
>

Mime
View raw message