Skip to main content
Question

Changing RDM relationships from one parent table to another (few)


may_kwok
Star Blazer L3
Forum|alt.badge.img+4

Let’s say we currently have some tables:

TableA

TableB

TableC

TableD

 

TableA and TableB are parents of TableC, then TableC is parent of TableD.

So we have:

Relationship Parent Table Child Table
Rel1 TableA TableC
Rel2 TableB TableC
Rel3 TableC TableD

 

We are trying to get rid of Table C, so that the new relationships will be:

Relationship Parent Table Child Table
Rel4 TableA TableD
Rel5 TableB

TableD

 

I’ve tried to deploy the model and I get validation messages of missing parent values. Trouble is TableD is quite big in RDM terms (in the magnitude of 200k rows) and I think the application is struggling to start at the moment with all these failed validations.

Is there some specific alter hints that can be used or am I going to have to anticipate going into repair mode somehow?

 

may_kwok
Star Blazer L3
Forum|alt.badge.img+4
  • Star Blazer L3
  • July 11, 2025

Or is it better to take a backup of the data, truncate the table before deployment, then reload the data back in afterwards?


may_kwok
Star Blazer L3
Forum|alt.badge.img+4
  • Star Blazer L3
  • July 14, 2025

I forgot about the “fix pk” button in the repair data mode!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings