Postgresql: DROP CONSTRAINT IF EXISTS not working

Question

I want to delete a constraint only if it exists. But it's not working or I do something wrong.

Here is my query:

IF EXISTS (SELECT * FROM information_schema.table_constraints WHERE constraint_name='res_partner_bank_unique_number')
THEN ALTER TABLE res_partner_bank DROP CONSTRAINT res_partner_bank_unique_number;

It gives me this error:

ERROR: syntax error at or near "IF"

If anybody can help me please. Thanks.

Regards.

user330315 · Accepted Answer · 2019-12-02 13:53:21Z

13

There is no IFin SQL (only in PL/pgSQL).

But drop constraint supports the IF NOT EXISTS option:

ALTER TABLE res_partner_bank 
  DROP CONSTRAINT IF EXISTS res_partner_bank_unique_number;

answered Dec 2, 2019 at 13:53

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql: DROP CONSTRAINT IF EXISTS not working

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related