Re: Relation does not exist

April L <april@i-netco.com> writes:
> in your queries you have to refer to it with propercase and enclose in "
> quotes
> so books_bookid_seq will cause the error
> "Books_BookID_seq" will be ok...

It's been awhile, but I think that 7.0's nextval() would take the given
string literally, while later versions follow the downcase-unless-quoted
rule that applies to names in normal query contexts.  So if you had
    nextval('Books_BookID_seq')
before, you now need
    nextval('"Books_BookID_seq"')

Or you could recreate the sequence with an all-lower-case name...

            regards, tom lane