Re: Serial sequence name when table/column name in uppercase - Mailing list pgsql-sql

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