Because to select a composite type column PG need to wrap the
composite column name with parentheses but doesn`t allow parentheses when
inserting the composite column values.
So you could NOT define the component with columns wrapped with parentheses
as below:
<component name="SomeCompositeType">
<property name="Field1" column="(SomeCompositeColumn).Field1"/>
</component>
because it would not work while inserting rows.
Also, PG fails when selecting the composite column by using
*tableAlias.compositeColumn.compositeField* notation:
SELECT environmentId,
env.(EnabledTracking).changedby
FROM schema.environment env
with error: ERROR: syntax error at or near "("
So either wrap or not the composite column name with parentheses should be
decided inside NHibernate PG adapter.
Or maybe NH has some special hints to define the composite column fields in
the mapping?
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.
