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@sss.pgh.pa.us>
>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




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