Postgres cannot find my sequence

Question

Although there are answers to this on internet but somehow not working for me.

I want to manually change next value for my sequence. In pgAdmin, I can see the sequence Substances_SUBID_seq in the list under Sequences but following query is not working in Query Tool of pgAdmin

select setval('Substances_SUBID_seq', (select max("SUBID") from "Substances"));

The error I get is:

ERROR:  relation "substances_subid_seq" does not exist 
LINE 1: select setval('Substances_SUBID_seq', (select max("SUBID") f...

What am I doing wrong?

zerkms · Accepted Answer · 2017-08-17 03:13:23Z

2

If you see it as Substances_SUBID_seq exactly then you should specify the name in double quotes (double quotes inside single quotes)

'"Substances_SUBID_seq"'

That way postgresql does not lowercase it during execution (see the error message).

answered Aug 17, 2017 at 3:13

zerkms

256k73 gold badges447 silver badges551 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres cannot find my sequence

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related