DROP CASCADE

  • 70Views
  • Last Post 25 February 2020
  • Topic Is Solved
0
votes
Bart Jonk posted this 24 February 2020

Hi,

 

My replaction is failing since I created a view on a atble on which increaments are not possible.

I need to do a drop & recreate.

https://app.skyvia.com/#/packages/80908/edit

 

Can I do a DROP CASCADE?

or alternaternatively (better), DROP and Recreate the view as well?

 

Any other alternatives?

Order By: Standard | Newest | Votes
0
votes
Mariia Zaharova posted this 24 February 2020

Hello Bart,

 

Can I do a DROP CASCADE?

or alternaternatively (better), DROP and Recreate the view as well?

 

Unfortunately, this cannot be done via Skyvia. It does not support DROP CASCADE and re-creating views. We will consider possible solutions for such scenarios and let you know if any is available.

 

Best regards,

Mariia

0
votes
Bart Jonk posted this 24 February 2020

Any idea why https://app.skyvia.com/#/packages/81270 succeeds? and https://app.skyvia.com/#/packages/80908 fails?

 

should be axactly the same....

 

 

 

0
votes
Bart Jonk posted this 24 February 2020

Leave that.... I just saw that the last run of the former was in october.

Do you perhaps support TRUNCATE in stead of DROP?

 

regards,

Bart.

 

0
votes
Mariia Zaharova posted this 25 February 2020

Hello Bart,

 

TRUNCATE is also not supported now.

 

Best regards,

Mariia

0
votes
Bart Jonk posted this 25 February 2020

Thanks for now, I'll copy the table using a script

Close