Re: Relation does not exist

Thanks Tom, April for your help.

As soon as I get the chance in the next few days I will look into
your suggestions.

Brian.

>From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>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

_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com