Yes, putting the extra " in as Tom suggested has fixed it.
Thankyou.
>From: "Brian Schroeder" <bjswm@hotmail.com>
>
>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
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com