<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#3366ff">
BladeOfLight16 wrote:
<blockquote
cite="mid:CA+=1U=WCeyhSka3=+ttR_3_yi9wWCUtp4kmcoLX4bSAGJtH6fw@mail.gmail.com"
type="cite">
<div dir="ltr">
<div class="gmail_extra">
<div class="gmail_quote">On Tue, Feb 3, 2015 at 11:41 PM, Puthick Hok
<span dir="ltr"><<a moz-do-not-send="true"
href="mailto:hputhick@gmail.com" target="_blank">hputhick@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;">
<div bgcolor="#ffffff" text="#3366ff"><font size="+1"><font
face="Helvetica, Arial, sans-serif">
I use Perl DBI to connect to Postgresql. If I create the postgis
database using 'CREATE EXTENSION' method, Perl DBI returns 'layer_id'
as the primary key of my layer table. If I create the postgis database
using the old incompatible way of loading postgis.sql and
spatial_ref_sys.sql, Perl DBI returns 'id' as it is named as the
primary key of my layer table.</font></font><br>
</div>
</blockquote>
<div><br>
</div>
<div>That doesn't make sense. I'm pretty sure that neither <span
style="font-family: monospace,monospace;">CREATE EXTENSION</span> nor
running postgis.sql and spatial_ref_sys.sql would affect the primary
key of an existing table. Most likely, you're running some other SQL of
your own, and you have something weird going on in that. How are you
creating your "layer table"?<br>
</div>
</div>
</div>
</div>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<font size="+1"><font face="Helvetica, Arial, sans-serif">My create
table and index are:<br>
<br>
CREATE TABLE layer (<br>
id integer NOT NULL,<br>
parent bigint NOT NULL,<br>
name character varying(100) NOT NULL,<br>
alias character varying(100),<br>
layertype character varying(30) DEFAULT 'layer'::character varying
NOT NULL,<br>
layermetadata text,<br>
iseditable smallint DEFAULT 1 NOT NULL,<br>
createuser bigint DEFAULT 0 NOT NULL,<br>
createtime timestamp without time zone NOT NULL,<br>
lastupdateuser bigint NOT NULL,<br>
lastupdatetime timestamp without time zone NOT NULL,<br>
srid bigint DEFAULT 4326 NOT NULL,<br>
geometrytype character varying(30),<br>
description character varying(254),<br>
owngroupid bigint NOT NULL,<br>
accessgroupid bigint DEFAULT 0 NOT NULL,<br>
owngroupperm smallint NOT NULL,<br>
accessgroupperm smallint DEFAULT 0 NOT NULL,<br>
otherperm smallint DEFAULT 0 NOT NULL<br>
);<br>
<br>
CREATE SEQUENCE layer_id_seq<br>
START WITH 1<br>
INCREMENT BY 1<br>
NO MAXVALUE<br>
NO MINVALUE<br>
CACHE 1;<br>
<br>
<br>
ALTER TABLE public.layer_id_seq OWNER TO auser;<br>
<br>
ALTER SEQUENCE layer_id_seq OWNED BY layer.id;<br>
<br>
SELECT pg_catalog.setval('layer_id_seq', 1, false);<br>
<br>
ALTER TABLE ONLY layer<br>
ADD CONSTRAINT layer_pkey PRIMARY KEY (id);<br>
</font></font>
</body>
</html>