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