Foreign key index support

[pblachut]

I`ve just tried to use foreign key support as it was described here.

I`ve noticed two issues:

• ForeignKey attribute on document definition does not create index in postgres, where fluent definition does as it should.

Used attribute definition
Used fluent definition

• I`ve noticed some unexpected behavior for me during inserting new document with invalid foreign key. It just allowed me to do that without any error and additional column contained invalid id. Should I add some additional configuration to force checking this constraint?

My example of usage can be found here.

[jeremydmiller]

@pblachut I'm looking at this now.

[jeremydmiller]

@pblachut I've got the [ForeignKey] behavior fixed. From my experimentation this morning, it's behaving the way I'd expect. You can insert data with NULL fk id's, but using a nonexistent FK id threw an exception from Postgresql the way you'd expect it to.

We have a test for this behavior from when the feature was built that's been passing every since.

[jeremydmiller]

There was a 2nd problem with using FK's against a nullable field or property. That's fixed as well.

[pblachut]

Yes, it was indeed. Constraint for not nullable id worked correctly. Thanks.