in PostgreSQL 9.0.2 / pgAdmin III - ERROR: relation "[table name]" already exists

I'm a super noob, and based on the advice of friends, I chose the PostgreSQL
platform to install on my Mac 10.6.5 and I just bought a copy of Simply SQL.

The problem is, I've created a database in the graphical interface other
than the 'postgres' default database (for some reason, I was unable to do
this same thing in the command line interface for psql console, I think I've
followed the instructions, but neither here nor there)

I click on the "SQL" button at the top and it brings up the Query tool.

In chapter two of SIMPLY SQL, i'm just cutting and pasting / manually typing
in this code

_________________________________________________
/*  Chapter 2: SELECT Overview  */

/*  Title and Category of Entries  */

CREATE TABLE entries
(
  id         INTEGER      NOT NULL  PRIMARY KEY
, title      VARCHAR(99)  NOT NULL
/*  Note: use DATETIME if your database system does not support TIMESTAMP
*/
, created    TIMESTAMP     NOT NULL
, updated    TIMESTAMP       NULL
, category   VARCHAR(37)    NULL
, content    TEXT           NULL
);

INSERT INTO entries
  ( id , title , created , updated , category )
VALUES
  (423 , 'What If I Get Sick and Die?' , '2008-12-30' , '2009-03-11' ,
'angst')
;
INSERT INTO entries
  ( id , title , created , updated , category )
VALUES
  (524 , 'Uncle Karl and the Gasoline' , '2009-02-28' , NULL , 'humor')
;
INSERT INTO entries
  ( id , title , created , updated , category )
VALUES
  (537 , 'Be Nice to Everybody' , '2009-03-02' , NULL , 'advice')
;
INSERT INTO entries
  ( id , title , created , updated , category )
VALUES
  (573 , 'Hello Statue' , '2009-03-17' , NULL , 'humor')
;
INSERT INTO entries
  ( id , title , created , updated , category )
VALUES
  (598 , 'The Size of Our Galaxy' , '2009-04-03' , NULL , 'science')
;

SELECT
  title
, category
FROM
  entries
;
/* Results should look like this --
   title                        category
   What If I Get Sick and Die?  angst
   Uncle Karl and the Gasoline  humor
   Be Nice to Everybody         advice
   Hello Statue                 humor
   The Size of Our Galaxy       science
*/
_____________________________________

THe first time I execute it, it does it's table, just like in the book.

However, I'm called to put a WHERE filter on the code at the end

WHERE
  id = 524
;

THen when I try to execute it again, it gives this error message

ERROR:  relation "entries" already exists

********** Error **********

ERROR: relation "entries" already exists
SQL state: 42P07

Even when I try to Clear the History, delete the current document an make a
new one, or even try to do a DROP staement, I still get this same message.
The only way I can eliminate this message is if I delete the database in the
pgAdmin Object browser, recreate a new database and do it again, at which
point, it stops giving the error message, but only once.

So does this mean that I have to delete the database EVERY TIME I CHANGE THE
CODE?!?



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/in-PostgreSQL-9-0-2-pgAdmin-III-ERROR-relation-table-name-already-exists-tp3318303p3318303.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.