ERROR Relation already exists in PostgreSQL when creating an index on a table

11,577

The problem is that the primary key constraint name is equal the table name. I don know how postgres represents constraints, but I think the error "Relation already exists" was being triggered during the creation of the primary key constraint because the table was already declared. But because of this error, the table wasnt created at the end.

Share:
11,577
Fopa Léon Constantin
Author by

Fopa Léon Constantin

Updated on November 25, 2022

Comments

  • Fopa Léon Constantin
    Fopa Léon Constantin 12 months

    I have an error when running the the queries below on PostgreSQL from a Java code

     .....
     sql =  "CREATE TABLE IF NOT EXISTS table1 (s VARCHAR(100), p VARCHAR(100), o VARCHAR(100), PRIMARY KEY (s,p,o)) ; ";                   
     pgsql.runUpdateQuery(sql);         
    
     sql =  "CREATE INDEX indextable1 ON table1 (s,p,o);";  
     pgsql.runUpdateQuery(sql);         
     .....
    

    But i got the following Error

    org.postgresql.util.PSQLException: ERROR: relation "indextable1" already exists         
    

    Can someone explain me what its happening? My understanding is that PRIMARY KEY is consider to be an INDEX and therefore the second query fail. Am I right ?