[postgis-users] Error while importing data

[strk at refractions.net]

On Mon, Mar 14, 2005 at 01:20:53PM +0000, Nigel Kukard wrote:
> is there somewhere in the code I can disable the constraint?

ALTER TABLE .. DROP CONSTRAINT ...

See:
http://www.postgresql.org/docs/8.0/interactive/sql-altertable.html

--strk;

> 
> Regards
> Nigel
> 
> strk at refractions.net wrote:
> 
> >On Mon, Mar 14, 2005 at 01:02:31PM +0000, Nigel Kukard wrote:
> >
> >
> >>strk at refractions.net wrote:
> >>
> >>
> >>
> >>>Here you specify that the geometry column will store geometries with
> >>>4 dimensions (XYZM).
> >>>
> >>>
> >>>
> >>heh, shp2pgsql specified that.. not me ... :-)
> >>
> >>
> >>
> >>>If you want to be free to add other-dimensioned
> >>>geometries an option you have is to drop the enforce_dims_the_geom
> >>>constraint
> >>>on your table.
> >>>
> >>>
> >>>
> >>cool
> >>
> >>
> >>
> >>>Note that in that case your geometry_columns entry will
> >>>contain a non-true specification.
> >>>
> >>>
> >>>
> >>would this affect mapserver btw? I'm up to try and experiment anything,
> >>and help where I can.
> >>
> >>
> >>
> >>>You might want to use a fake value
> >>>there, as a notice of 'freely-dimensioned', like '-1'.
> >>>
> >>>
> >>>
> >>>
> >>sounds like a good idea!
> >>
> >>
> >>
> >>>Maybe we should support -1 as a dimension value to specify this, like
> >>>we do for SRID...
> >>>
> >>>
> >>>
> >>>
> >>I'm up to test it out!!
> >>
> >>
> >
> >Nigel, to say the truth SRID=-1 *special* handling is not used yet,
> >but has been proposed. It won't be in PostGIS-1.0.0 though. The
> >dimension -1 will probably be implemented at the same time.
> >
> >About mapserver you shouldn't have any problem as all geometries are
> >converted to 2d before parsing anyway, I don't think it uses
> >the 'dimension' field of geometry_columns at all.
> >
> >--strk;
> >
> >
> >
> >>-Nigel
> >>
> >>
> >>
> >
> >
> >
> >
> >
> >>_______________________________________________
> >>postgis-users mailing list
> >>postgis-users at postgis.refractions.net
> >>http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>
> >>
> >
> >_______________________________________________
> >postgis-users mailing list
> >postgis-users at postgis.refractions.net
> >http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> 
> --
> Nigel Kukard, PhD CompSc
> (Chief Executive Officer)
> Linux Based Systems Design
> Web: www.lbsd.net          Email: nkukard at lbsd.net
> Tel: (+27) 023 349 8000     Cell: (+27) 082 333 3723
> Fax: (+27) 023 349 1395  Support: 086 747 7600
> Address: LIGT House, 2 Klipdrift Rd, Rawsonville
> Linux Systems Design & Technology Solutions
> 
> 
>   The best language to use is the language that was designed for
>                  what you want to use it for.
> 
> 
> =====================================================================
> 
> Disclaimer
> ----------
> The contents of this message and any attachments are intended
> solely for the addressee's use and may be legally privileged and/or
> confidential information. This message may not be retained,
> distributed, copied or used if you are not he addressee of this
> message. If this message was sent to you in error, please notify
> the sender immediately by reply e-mail and then destroy the message
> and any copies thereof.
> 
> Opinions, conclusions and other information in this message may be
> personal to the sender and is not that of Linux Based Systems Design,
> LinuxRulz or any of it's subsideries, associated companies or
> principals and is therefore not endorsed by Linux Based Systems
> Design or LinuxRulz. Due to e-maill communication being insecure,
> Linux Based Systems Design and LinuxRulz do not guarantee
> confidentiality, security, accuracy or performance of the e-mail.
> Any liability for viruses is excluded to the fullest extent.
> 



> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users