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 <mailinglis..esluop.dk> 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?
>
This archive was generated by hypermail 2.0.0 : Thu Apr 20 2006 - 13:06:03 EDT