<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-15">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi,<br>
I'm a postgis/postgres newbie and I <span id="result_box" class=""
lang="en"><span class="hps">I would like to</span> <span
class="hps">get some help</span> <span class="hps">on the
topics</span> <span class="hps">that</span> <span class="hps">I'm
going to</span> <span class="hps">describe.<br>
</span></span><br>
<div id="gt-src-tools">
<div id="gt-src-tools-l">
<div style="display: inline-block;" id="gt-input-tool">
<div id="itamenu"><span class="ita-kd-inputtools-div"></span></div>
</div>
</div>
</div>
<div id="gt-res-content" class="almost_half_cell">
<div dir="ltr" style="zoom:1">
<div id="tts_button"><object
type="application/x-shockwave-flash"
data="//ssl.gstatic.com/translate/sound_player2.swf"
id="tts" width="18" height="18"></object></div>
<span id="result_box" class="" lang="en"><span class="hps">I
have</span> <span class="hps">imported into the database</span>
<span class="hps">the shapefile</span> <span class="hps">"survey"
of points</span> <span class="hps atn">(</span><span>trees</span><span>)</span><span>.</span>
<span class="hps">The</span> <span class="hps">spatial</span>
<span class="hps atn">table "</span><span>survey</span><span>"</span>
<span class="hps">contains</span> <span class="hps">five</span>
<span class="hps">columns</span><span>:</span><br>
<span class="hps">-</span> <span class="hps atn">"</span><span>Gid</span><span>"</span>
<span class="hps atn">(</span><span>created</span> <span
class="hps">during import and</span> <span class="hps">primary
key</span><span>, integer)</span><br>
<span class="hps">-</span> <span class="hps atn">"</span><span>Id</span><span>"</span><br>
<span class="hps">-</span> <span class="hps">"Code</span><span>"</span><br>
<span class="hps">-</span> <span class="hps atn">"</span><span>Old
number</span><span>"</span><br>
<span class="hps">-</span> <span class="hps atn">"</span><span>Geom</span><span>"</span>
<span class="hps atn">(</span><span>it</span> <span
class="hps">also</span> <span class="hps">created</span> <span
class="hps">during import</span><span class="">).<br>
</span></span><span id="result_box" class="" lang="en"><span
class="hps"><br>
</span></span><span id="result_box" class="" lang="en"><span
class="hps">The database includes</span> <span class="hps
alt-edited">several tables</span> <span class="hps atn">(</span><span
class="hps">"Species</span><span>"</span><span>,</span> <span
class="hps atn">"</span><span>Defects</span><span>"</span><span>,</span>
<span class="hps atn">"</span><span>Disease</span><span>"</span>
<span class="hps">and</span> <span class="hps alt-edited">others</span><span>)</span>
<span class="hps">related</span> <span class="hps">to the
main table</span> <span class="hps atn">"</span><span>VTA</span><span>"</span><span>.</span><br>
<span class="hps">Now I would like</span> <span class="hps">to
know why</span><span>,</span> <span class="hps">unlike what
happened</span> <span class="hps">to</span> <span
class="hps">the other</span> <span class="hps">tables,</span>
<span class="hps">I can not connect</span> <span class="hps">with</span>
<span class="hps atn">"</span><span class="">ADD</span> <span
class="hps">CONSTRAINT</span><span>"</span> <span
class="hps">column</span> <span class="hps atn">"</span><span>code</span><span>"</span>
<span class="hps">(integer</span><span>, not null</span><span>,</span>
<span class="hps">unique)</span> <span class="hps atn">of the
table "</span><span>VTA</span><span>"</span> <span
class="hps">to the corresponding</span> <span class="hps">column</span>
<span class="hps atn">"</span><span>code</span><span>"</span>
<span class="hps">(also</span> <span class="hps">integer</span><span>,
not null</span><span>)</span> <span class="hps">the</span>
<span class="hps">spatial</span> <span class="hps atn">table
"</span><span>survey</span><span>"</span><span>.</span><br>
<br>
<span class="hps">Another question</span><span>:</span> <span
class="hps">when I'm</span> <span class="hps">editing a</span>
<span class="hps">field</span> <span class="hps atn">(</span><span
class="">for</span> <span class="hps">example</span> <span
class="hps atn">"</span><span class="">species name</span><span>"</span>
<span class="hps atn">in the column "</span><span class="">species</span><span
class="">" of table</span> <span class="hps atn">"</span><span>VTA</span><span>"</span><span>,</span>
<span class="hps">related</span> <span class="hps">to the
table</span> <span class="hps">"Species</span><span>"</span><span>,</span>
<span class="hps">would that</span> <span class="hps">"species</span>
<span class="hps">name"</span> <span class="hps">could</span>
<span class="hps">be</span> <span class="hps">completed</span>
<span class="hps">on the basis</span> <span class="hps">of
the records</span> <span class="hps">in the table</span> <span
class="hps">"Species</span><span>"</span><span>.</span></span>
How can I do this?<br>
<span id="result_box" class="short_text" lang="en"><span
class="hps">Thanks in advance.<br>
<br>
Alessio<br>
<br>
</span></span><br>
</div>
</div>
<br>
<pre class="moz-signature" cols="72">
</pre>
</body>
</html>