How to force delete foreign key?

On request:
ALTER TABLE public.aircrafts DROP CONSTRAINT aircrafts_aircrafts_models_id_fk RESTRICT;

Mistake:
ERROR: constraint "aircrafts_aircrafts_models_id_fk" of relation "aircrafts" does not exist


Table "aircrafts_models" has been removed. The corresponding field from the table "aircrafts" is also removed. Manually.

How do I now remove the foreign key?
July 9th 19 at 11:08
1 answer
July 9th 19 at 11:10
Solution
So don't have it already, it will automatically deleted.

Written dosnt exists
Yeah, me too confused. Forgot to clarify that sit under DataGrip. There are all these "external" is displayed... And when the table edit, you also have everything. Emphasizes red and still does not delete.

Then, as I understand it, you just drop it? - alfonzo.Zeml commented on July 9th 19 at 11:13
: maybe there is some kind of cache sitting in the soft. Sure she removes the database connection, if the delete column. - bailee_Stant commented on July 9th 19 at 11:16
: okay, thank you. - alfonzo.Zeml commented on July 9th 19 at 11:19

Find more questions by tags PostgreSQLSQL