<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hello Mark,<br>
<br>
I am using your suggestion at this moment but the problem is as follows:<br>
<br>
I do an insert into the final_geom table which then uses a new id<br>
but; <br>
<br>
I need this id to do an insert into the final_attrib table!<br>
<br>
Basically what I want to do is:<br>
<br>
INSERT geom into table1 AND INSERT attrib1, attrib2, attrib3 into
table2 FROM temp_table.<br>
The resulting table1 and table2 need to have exactly the same ID.<br>
<br>
I was first thinking about building an id in my temp_table and then do
the 2 insert; But..my temp table is constantly created automatically by
ogr2ogr, so I (seem to) have no influence on it's structure.<br>
<br>
Mark Cave-Ayland schreef:
<blockquote cite="mid:1185278343.6927.22.camel@mca-desktop" type="cite">
<pre wrap="">On Tue, 2007-07-24 at 12:49 +0200, Milo van der Linden wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hello list!
I have been thinking my head off trying to figure it out and
documentation won't help me.
Yesterday I recieved the tip to use a GUID as a database wide unique
key. Well, I think it is the only option I have.
I import a shape file into a temp table.
>From this temp table is then insert the content into 2 other tables:
final_attributes and final_geom
Final_attributes should contain all the attribute fields plus a column
to connect it to final_geom
Final_geom should contain a column to connect to Final_attributes plus
the_geom.
Because Final_attributes is a table that also connects to other
geom_tables; it needs a id that is unique over 3 or even more tables.
If I can generate GUIDs with php, Is that a good option?
Is there a way to use the geometry column to generate some sort of
unique ID? I would also like to check if the geometry is unique within
it's final_geom table!
What datatype should I use to store the GUID?
I cannot figure it out... please lend me a hand
</pre>
</blockquote>
<pre wrap=""><!---->
Hi Milo,
Can you not just use a sequence to have a unique key across multiple
tables as suggested by Stephen? For example:
CREATE SEQUENCE seq1;
CREATE TABLE t1 AS (
id int8 default nextval('seq1'),
the_geom geometry
);
CREATE TABLE t2 AS (
id int8 default nextval('seq1'),
the_geom geometry
);
INSERT INTO t1 SELECT the_geom FROM geom_temp_table;
INSERT INTO t2 SELECT the_geom FROM geom_temp_table;
If you then do:
SELECT id FROM t1;
SELECT id FROM t2;
you should find that id is unique across both tables since they share
the same sequence.
Kind regards,
Mark.
</pre>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
<title>3DSite</title>
<meta http-equiv="Content-Type" content="text/html; ">
<style type="text/css">
<!--
body {
background-color: #FFFFFF;
margin-left: 5px;
margin-top: 5px;
margin-right: 5px;
margin-bottom: 5px;
}
body,td,th {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
color: #333333;
}
.style4 {font-size: 9px; }
.style5 {font-size: 9px; color: #CCCCCC; }
-->
</style>
<meta content="MSHTML 6.00.2900.2912" name="GENERATOR">
<br>
<table border="0" cellpadding="0" cellspacing="0" width="400">
<tbody>
<tr>
<td rowspan="3" align="left" height="0" valign="bottom" width="15"><br>
</td>
<td colspan="2" align="left" height="78" valign="top" width="0">
<p class="style4">Milo van der Linden
<br>
<a href="mailto:mlinden@zeelandnet.nl">mlinden@zeelandnet.nl</a><br>
<a href="mailto:milovanderlinden@gmail.com">milovanderlinden@gmail.com</a><br>
<a href="mailto:milo@3dsite.nl">milo@3dsite.nl</a><br>
<a href="http://www.3dsite.nl">http://www.3dsite.nl</a><br>
</p>
</td>
<td rowspan="3" align="left" height="0" valign="top" width="15"> </td>
<td valign="top" width="300">
<p class="style5"><span lang="NL">De informatie in dit bericht
reflecteerd mijn persoonlijke mening en niet die van een bedrijf of
instantie. Aan de informatie kunnen geen rechten worden ontleend.
Indien dit bericht onderdeel is van een forum, mailing-list of
community dan gelden automatisch de bijbehorende voorwaarden.</span></p>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>