Look close to books definition you've posted:
> create table books (id serial not null, author serial, primary key (id))

Author column should be integer, not serial.