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