Support for postgres DROP CONSTRAINT ... CASCADE

31 views
Skip to first unread message

Matt Stubbs

unread,
Mar 10, 2023, 1:48:54 AM3/10/23
to elixir-ecto

Support for the CASCADE option was added to DROP command previously. However, attempting to use it to drop a constraint is prevented with the error:

  ** (ArgumentError) PostgreSQL does not support CASCADE in DROP CONSTRAINT commands

According to the PostgresQL docs CASCADE is supported (by all current versions from what I can see).

  DROP CONSTRAINT [ IF EXISTS ] constraint_name [ RESTRICT | CASCADE ]

Is there a reason DROP CONSTRAINT ... CASCADE is not supported? If not, would support be welcome?

(BTW - first time posting. Feedback appreciated.)

-matt

José Valim

unread,
Mar 10, 2023, 2:13:33 AM3/10/23
to ma...@yellowrobot.com.au, elixir-ecto
PRs welcome!

--
You received this message because you are subscribed to the Google Groups "elixir-ecto" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elixir-ecto...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elixir-ecto/855871de-405d-4501-8439-30d450a0dee7n%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages