[postgis-users] Help CONSTRAINTS and others questions

2014-12-06 Thread Alessio Degioannini
Hi, I'm a postgis/postgres newbie and I I would like to get some help on the topics that I'm going to describe. I have imported into the database the shapefile "survey" of points (trees). The spatial table "survey" contains five columns: - "Gid" (created during import and primary key, integer

Re: [postgis-users] Help CONSTRAINTS and others questions

2014-12-07 Thread Hugues François
on to fill this column automatically) Hugues. De : postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-boun...@lists.osgeo.org] De la part de Alessio Degioannini Envoyé : samedi 6 décembre 2014 13:32 À : postgis-users Objet : [postgis-users] Help CONSTRAINTS and others questi

Re: [postgis-users] Help CONSTRAINTS and others questions

2014-12-07 Thread Rémi Cura
; > > > *De :* postgis-users-boun...@lists.osgeo.org [mailto: > postgis-users-boun...@lists.osgeo.org] *De la part de* Alessio Degioannini > *Envoyé :* samedi 6 décembre 2014 13:32 > *À :* postgis-users > *Objet :* [postgis-users] Help CONSTRAINTS and others questions > > >

Re: [postgis-users] Help CONSTRAINTS and others questions

2014-12-07 Thread Micha Silver
On 12/06/2014 02:32 PM, Alessio Degioannini wrote: Hi, I'm a postgis/postgres newbie and I I would like to get some help on the topics that I'm going to describe.

Re: [postgis-users] Help CONSTRAINTS and others questions

2014-12-07 Thread Alessio Degioannini
Maybe you already have some values in the code column of VTA which do not exist in the code column of the survey table? You can not create a constraint when existing data already violate the constraint. No, the table VTA is totally empty. Il 07/12/2014 13:54, Micha Silver ha scritto: On 12/06

Re: [postgis-users] Help CONSTRAINTS and others questions

2014-12-07 Thread Alessio Degioannini
I'm editing with pgadmin o, butI am considering whether to use phppgadmin... * Alessio Degioannini - dottore forestale PROTER - Studio Associato Agronomico e Forestale C.so Stati Uniti, 27 - 10128 TORINO (ITALY) Tel: +39 011 817 0767 Fax: +39 011 0