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.
Author by
Fopa Léon Constantin
Updated on November 25, 2022Comments
-
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 anINDEX
and therefore the second query fail. Am I right ?