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