Subject: Re: Serial sequence name when table/column name in uppercase
To: pgsql-sql@lists.postgresql.org
References: <cc5742f1-7b3f-5051-e033-e99ff69245e7@4js.com>
 <CAB8KJ=hnuX0aKLj490Q2ryX0aFRg-z-aur=JtiW=7r4-prT+mQ@mail.gmail.com>
 <87d8f930-a87c-2d08-f362-d59655ca6c24@4js.com>
 <3167888.1617198904@sss.pgh.pa.us>
From: Sebastien FLAESCH <sf@4js.com>
Organization: Four Js Development Tools
Message-ID: <9a4f52ca-29be-34c6-08a7-0fbf7974e630@4js.com>
Date: Wed, 31 Mar 2021 17:13:06 +0200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.8.0
MIME-Version: 1.0
In-Reply-To: <3167888.1617198904@sss.pgh.pa.us>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/9a4f52ca-29be-34c6-08a7-0fbf7974e630%404js.com>
Precedence: bulk

Side notes:

1) Seems ALTER SEQUENCE xxx START WITH 100 does not have any
impact on serial/bigserial sequences... expected?

2) I know there is a setval() function. But I was looking for
ALTER SEQUENCE to not produce a result set.

Any way to execute setval() without a preceding SELECT?

test1=> setval('public.tab1_pkey_seq',100,false);
ERROR:  syntax error at or near "setval"
LINE 1: setval('public.tab1_pkey_seq',100,false)
         ^

test1=> select setval('public.tab1_pkey_seq',100,false);
  setval
--------
     100
(1 row)


I am using the C interface libpq.so ... I assume it's not a
problem to use SELECT setval() but was wondering if there is
a smarter solution.

Seb