[odb-users] CASCADE on delete/update

[nima chavooshi]

Hi Marcel,

Thanks for your attention. So With this version, I can not do what I
expected about automate add CASCADE to my schema, right? and I must use the
pre-release version that is not stable yet.


On Fri, Sep 19, 2014 at 11:42 AM, Boris Kolpackov <boris at codesynthesis.com>
wrote:

> Hi Nima,
>
> Marcel Nehring <mne at qosmotec.com> writes:
>
> > did you have a look at section 14.4.15 of the ODB manual? The
> > on_delete specifier might be what you are looking for.
>
> Yes, except that this is only available in the pre-release. Here is
> the pre-release distribution with the Windows binary of the ODB
> compiler. If you need a binary for some other platform, let me
> know:
>
> http://codesynthesis.com/~boris/tmp/odb/pre-release/
>
> Here is also the pre-release manual where you can find Section 14.4.15:
>
> http://codesynthesis.com/~boris/tmp/odb/odb-manual.pdf
>
> As for the 'ON UPDATE' clause, this is not really needed in ODB since
> we assume that object ids (which translate to primary keys) are immutable
> (which is also generally a good idea).
>
> Boris
>