Announcement

Collapse
No announcement yet.

possible to DELETE CASCADE?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • possible to DELETE CASCADE?

    Is it possible for a query to delete a record and all of its foreign-key dependents?
    In native pgAdmin3 we have Drop Cascaded option

  • #2
    We are sorry that Navicat does not support your mentioned feature. Your request has been forwarded to our development team. We will keep improving our Navicat in the future. Thank you for your advice.

    Comment


    • #3
      I, too, would really like to see a "DROP CASCADED..." option in Navicat for PostgreSQL. It has been almost two years since the original poster requested this feature, and as of Navicat 11.2.9, the feature still has not been implemented.

      The lack of this capability has forced me to keep pgAdmin III installed, just so I can use it to drop with cascading. Given how thorough PostgreSQL is with regard to data integrity, the absence of this feature creates a lot of extra work for me and my team.

      Candidly, this feature does not seem difficult to implement, given that PostgreSQL already includes the ability to do this natively with
      Code:
      DROP SCHEMA ... [CASCADE]
      and
      Code:
      DROP TABLE ... [CASCADE]
      . It's hard to believe that a premium product like Navicat lacks this ability when the cost-free pgAdmin includes it.

      Please implement this feature. Thank you very much for your consideration.

      Comment


      • #4
        Hi cbj4074,

        Thanks for your suggestion. We will consider to implement it in the future version. I will contact you when any progress is made.

        Comment


        • #5
          It's been 4 years since the original post about this functionality. I too would like this basic and common functionality made available as a right click menu option.

          While I can run a manual SQL query to do the same, isn't the whole point of a GUI to make it so I don't have to do that?

          Comment


          • #6
            Hi craigmiller,

            We will consider to include this request in the next major version. I will keep you updated on the progress.

            Comment


            • #7
              Hi

              This request has been added to Navicat Windows and Linux version 12.1.15 . If you are using Windows / Linux version, please upgrade to this version.

              If you are using macOS version, please wait for the new version.

              Comment

              Working...
              X