On Tue, Sep 28, 2010 at 10:07 PM, Marcelo Zabani <[email protected]> wrote:
> 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?). > No you aren't > 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]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- Fabio Maulo -- 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.
