From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | April L <april(at)i-netco(dot)com> |
Cc: | "Brian Schroeder" <bjswm(at)hotmail(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Relation does not exist |
Date: | 2002-05-08 04:08:30 |
Message-ID: | 28991.1020830910@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
April L <april(at)i-netco(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-05-08 04:44:18 | Re: more voodoo planner bs :) |
Previous Message | Brian Schroeder | 2002-05-08 03:28:05 | Re: Relation does not exist |