perform setval() fails?

From: Sebastien FLAESCH <sf(at)4js(dot)com>
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: perform setval() fails?
Date: 2020-11-20 17:00:10
Message-ID: 7f3fc08f-b65d-402c-bc29-9bdb19c2526c@4js.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello!

What I am missing here?

test1=> perform setval('mytab1_pkey_seq',5000,false);
ERROR: syntax error at or near "perform"
LINE 1: perform setval('mytab1_pkey_seq',5000,false);
^

test1=> select setval('mytab1_pkey_seq',5000,false);
setval
--------
5000
(1 row)

Seb

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Christophe Pettus 2020-11-20 17:01:39 Re: perform setval() fails?
Previous Message Sebastien FLAESCH 2020-11-20 10:23:24 Re: Get last generated serial sequence and set it up when explicit value is used