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
