agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Sebastien FLAESCH <sf@4js.com>
To: pgsql-sql@lists.postgresql.org
Subject: perform setval() fails?
Date: Fri, 20 Nov 2020 18:00:10 +0100
Message-ID: <7f3fc08f-b65d-402c-bc29-9bdb19c2526c@4js.com> (raw)
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
view thread (2+ messages) latest in thread
Message-ID: <7f3fc08f-b65d-402c-bc29-9bdb19c2526c@4js.com>
Permalink: ../7f3fc08f-b65d-402c-bc29-9bdb19c2526c@4js.com/
Also on: postgresql.org/message-id/7f3fc08f-b65d-402c-bc29-9bdb19c2526c@4js.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sf@4js.com, pgsql-sql@lists.postgresql.org
Subject: Re: perform setval() fails?
In-Reply-To: <7f3fc08f-b65d-402c-bc29-9bdb19c2526c@4js.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox