e(dot)ellenkamp(at)copernicus-it(dot)nl (Egbert Ellenkamp) writes:
> select setval('mytable_myrowid_seq',select max(myrowid) from mytable);
That should work if you put in the required parentheses around the
sub-select:
select setval('mytable_myrowid_seq', (select max(myrowid) from mytable));
regards, tom lane