| 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: | Whole Thread | Raw Message | 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 |