Relation does not exist

Hi everyone.

I am new to this list, and a real novice with databases.

A while back I created a database using postgres 7.03 in Mandrake 7.2.
It is a catalog for all my books.

Although not really knowing what I was doing, I have recently upgraded
it to 7.2 along with Mandrake 8.2. I did a dump_all from 7.03, and
then read it all in to psql in 7.2.

When I try to view the database, everything is there and looks OK. But
if I try to insert a new entry I get the following error:

ERROR: Relation "books_bookid_seq" does not exist.

Using phpPgadmin shows:

Field Type Length Not Null Default
BookId Int4 4 Yes nextval('Books_BookID_seq'::text)

What do I need to do?

Brian

_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx