<!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>
<br>
I have double checked my code 'layer_id' is coming straight from
calling $dbh->primary_key( undef, undef, 'layer');<br>
</body>
</html>