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