ERROR: cannot drop view csw_breweryanalytics because other objects depend on it about cds-dbm HOT 5 CLOSED

Reference commit: 41cd76a

@gregorwolf
The issue should be fixed in version 0.0.20. I am now safely handling cascading views on create and drop. Tested also with your beershop and worked for me.

from cds-dbm.

might not be an issue with cds-dbm. had a similar issue w/o it - root cause was the docker volume. manually deleted it, all good afterwards.

from cds-dbm.

It's an issue with cds-dbm:
Internally I am creating a liquibase changelog, that I have to manually reorder before deploying to the database. It seems, that dependent views are not being handled correctly when they are dropped. I am already checking for references when creating views and I am going to add this kind of check for drop statements as well.

Relevant code part is here:
https://github.com/mikezaschka/cds-dbm/blob/main/src/ChangeLog.ts#L35

from cds-dbm.

It should also work with the latest @sap/cds releases (4.4.4 and 4.4.6).

from cds-dbm.

Thank you. Works now like a charm.

from cds-dbm.