Hmm... as usual this becomes a question of how many various DB
options we should support.
Per Chris's message, I was wrong in my assumption that a constraint
across schemas is not possible. This means that current behavior is
correct. My vote is to close CAY-522 issue and keep things as they
are (do not add an extra modeler checkbox).
Andrus
On Apr 20, 2006, at 9:00 PM, Mike Kienenberger wrote:
On 4/20/06, Chris Poulsen <[EMAIL PROTECTED]> wrote:
Cross schema constraints are available in oracle, however you need to
allow access to the object being referenced.
Something like:
as user core_work_mgmt:
grant references on statusable_work to eng_work_mgmt
before creating the constraint
Interesting. That makes sense.
I'll run it by our dev team and see if they want to do it.
Thanks.
It's still unclear what Cayenne's behavior should be, though.
Maybe a "Should generate cross-schema constraints" preference item or
method parameter?
