Re: [BUGS] BUG #14791: Error 42P07 but the relation DOESN'T Exists!Error 42P01

jfblazquez.ayesa@gmail.com wrote:

> I was creating tables using scripts via pgAdmin when it suddenly crashed
> while creating a table: "scada_equipment_instance"
> 
> After restarting pgAdmin and psql service, I can't create or use
> "scada_equipment_instance" table anymore. It says:
> 
> ERROR: la relación «scada_equipment_instance» ya existe
> SQL state: 42P07

[Translation: relation "scada_equipment_instance" already exists]

Juan Francisco followed up to the moderator address to indicate that he
found the problem -- there's a constraint that uses the same name as the
table, causing the error.

Case closed.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs