<!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">
PostgreSQL already understands serials.<br>
<tt><br>
test=# create table tmp(id serial primary key);<br>
NOTICE: CREATE TABLE will create implicit sequence "tmp_id_seq" for
serial column "tmp.id"<br>
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"tmp_pkey" for table "tmp"<br>
CREATE TABLE<br>
<br>
test=# \d tmp<br>
Table "public.tmp"<br>
Column | Type | Modifiers <br>
--------+---------+--------------------------------------------------<br>
id | integer | not null default nextval('tmp_id_seq'::regclass)<br>
Indexes:<br>
"tmp_pkey" PRIMARY KEY, btree (id)</tt><br>
<br>
-- Kevin<br>
<br>
Gustavo Ces wrote:
<blockquote cite="mid:010201c8254b$44fac840$ba03a8c0@GUS" type="cite">
<title>3DSite</title>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<meta content="MSHTML 6.00.2900.2180" name="GENERATOR">
<style></style>
<div><font face="Arial" size="2">Hi,</font></div>
<div> </div>
<div><font face="Arial" size="2"> And how do you use serials? in
other words, how do you create Postgis-understands primary keys?</font></div>
<div> </div>
<div><font face="Arial" size="2">Gus</font></div>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
</body>
</html>