Hi everyone, I'm having trouble with geometric types in postgresql
9.0. Please understand that I'm VERY new to nhibernate as well.
Unfortunately my project is a website and there's no postGIS installed
in my hosting company (plus, NHibernate Spatial seems abandoned to me,
am I right?).
So far I've only been using the point type, and I've been mapping it
to two different properties (xcoordinate and ycoordinate) by using
coordinates[0] and coordinates[1] (where coordinates is my point data
type in postgresql).
Take a closer look (small piece of my mapping file):
<property name="xcoordinate" column="coordinates[0]"></property>
<property name="ycoordinate" column="coordinates[1]"></property>
So far so good, everything works... however..
when trying to insert new data into the table, postgresql will
complaing that "coordinates" is not-nullable. I checked the query and
of course, it tries to insert two values, one for coordinates[0] and
one for coordinates[1], and postgresql doesn't understand that the
entire point is being inserted and returns an error for violating a
not-null constraint (it doesn't guarantee it will work.. only updates
and selects are specified in the docs:
http://www.postgresql.org/docs/9.0/interactive/functions-geometry.html
(check the bottom))
So I ask of you, what should I do?
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
