Re: [postgis-users] Typmod and triggers

2011-11-23 Thread Jose Carlos Martinez
Thanks Regina, Robe and Paul as usual you answer fast and giving us a lot of information. I will be checking out the ticket to know the status of this bug. To know it is working with geography type let me get rid of some fear about if it was a PostgreSQL issue. As Regina said we can use still c

Re: [postgis-users] Typmod and triggers

2011-11-22 Thread Paragon Corporation
Jose, slight omission in my last > -- to put back constraints on it -- > SELECT populate_geometry_columns('a'::regclass); > I forgot that use type mod is the default now -- so the above should be SELECT populate_geometry_columns('a'::regclass, false); To force it to constrain the geometry us

Re: [postgis-users] Typmod and triggers

2011-11-22 Thread Paragon Corporation
I figure out where to put that. Hope that helps, Regina http://www.postgis.us > -Original Message- > From: postgis-users-boun...@postgis.refractions.net > [mailto:postgis-users-boun...@postgis.refractions.net] On > Behalf Of Jose Carlos Martinez > Sent: Tuesday, Novemb

[postgis-users] Typmod and triggers

2011-11-22 Thread Jose Carlos Martinez
Hi all, Im using PostgreSQL 9.1 and PG 2.0 under MS Windows. Lets say I have a tabla A with a geometry column 'geom' of type geometry(MultiPolygon, 23030). then I wrote a trigger (BEFORE INSERT ON, FOR EACH ROW) that changes: New.geom:= ST_GeometryN (New.geom, 1). After inserting a row: inser