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

2014-12-07 Thread Hugues François
Hello, I'm not sure to understand well your problems but it seems you have sql questions rather than postgis ones... For the first one, I don't really understand what you are looking for but I think what you want to add is constraint called foreign key (you will find useful information in

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

2014-12-07 Thread Rémi Cura
For the second part, it depends hugely on how you edit the field. Are you editing with psql, pgadmin, qgis, ... Cheers, Rémi-C 2014-12-07 10:39 GMT+01:00 Hugues François hugues.franc...@irstea.fr: Hello, I’m not sure to understand well your problems but it seems you have sql questions

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

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