title: PostgreSQL Error: Relation already exists
body: <p>I am trying to create a table that was dropped previously.  </p>
  
  <p>But when I do the <code>CREATE TABLE A ..</code>. I am getting below error: </p>
  
  <blockquote>
    <p>Relation 'A' already exists.</p>
  </blockquote>
  
  <p>I verified doing <code>SELECT * FROM A</code>, but then I got another error: </p>
  
  <blockquote>
    <p>Relation 'A' does not exists.</p>
  </blockquote>
  
  <p>I already tried to find it in <code>\dS+</code> listing all relations, and it is not there.<br>
  To complicate this, I have tested this by creating this table in another database and I got the same error. I am thinking that could be an error when this table was dropped. Any ideas?</p>
  
  <p>Here is the code: I'm using a generated code from Power SQL. I have the same error without using the sequence. It just works when I change the name and in this case I can not do that.</p>
  
  <pre><code>CREATE SEQUENCE csd_relationship_csd_relationship_id_seq;
  CREATE TABLE csd_relationship (
      csd_relationship_id INTEGER NOT NULL DEFAULT nextval('csd_relationship_csd_relationship_id_seq'::regclass),  
      type_id INTEGER NOT NULL,
      object_id INTEGER NOT NULL,
      CONSTRAINT csd_relationship PRIMARY KEY (csd_relationship_id)
  );
  </code></pre>