We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Unable to Find Dependencies to Drop Table — Vertica Forum
Options

Unable to Find Dependencies to Drop Table

Patrick_Ting_1Patrick_Ting_1
in General Discussion
Regarding this error: DROP TABLE a.b; Error: [Vertica][VJDBC](3128) ROLLBACK: DROP failed due to dependencies [Vertica][VJDBC]Detail: Cannot drop Table b because other objects depend on it SQLState: 2BV01 ErrorCode: 3128 How do you enumerate all dependencies for table b? I've already tried looking for entries in system tables table_constraints and foreign_keys, but I don't see any relevant entries.

Comments

  • Daniel_LeybovicDaniel_Leybovic
    Hi! To see all dependencies(projections) you can use in query: select * from projections where anchor_table_name = 'A_TABLE'; or select export_objects('','A_TABLE'); https://my.vertica.com/docs/6.1.x/HTML/index.htm#1294.htm
    HINT: Use DROP ... CASCADE to drop the dependent objects too.
  • Patrick_Ting_1Patrick_Ting_1
    Thanks for the pointers. I didn't see anything obvious besides the super projections, so I decided to just drop with cascade and it worked. It would be much better if the error message at least reported the 1st dependency found so I know what to manually drop without the use of cascade.
  • jiahe1224jiahe1224 Vertica Customer ✭

    I found that the super projection automatically built by vertica will not affect the delete table, but the manually built super projection will affect the delete table

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...