I create tables in an update script. To avoid errors on further updates, the tables are created with
IF NOT EXISTS like this:
CREATE TABLE IF NOT EXISTS nodes ( NODEID INT NOT NULL, LASTACTIVITY TIMESTAMPTZ NOT NULL, PRIMARY KEY (NODEID) );
Sadly, I get these notices:
NOTICE: relation “nodes” already exists, skipping
What is the reason for that? I mean, I used
IF NOT EXISTS to avoid such messages.
Can I stop that easily?