<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<pre>Hi Jérôme,</pre>
<pre>Hum...it seems that your geometry_columns' table is not updated for alpages' table.
First of all, as U did a backup from a PostgreSQL 8.0.3, did U so try to backup the table</pre>
<pre>geometry_columns in your sql file too ..???</pre>
<pre>
First try to see if your geometry_column is referenced is your geometry_columns table</pre>
<pre>
Select * from geometry_colmuns where f_table_name='alpages';</pre>
<pre>
if U got nothing do a manual insertion like this</pre>
<pre>
insert into geometry_columns(f_table_catalog,f_table_schema,f_table_name,f_geometry_column,coord_dimension,srid,type)
values ('','public','alpages','geounitealpage25',2,-1,'POLYGON');</pre>
<pre>
then a beautifyll:</pre>
<pre>
vacuum full analyze;</pre>
<pre>
and if your php script put this:</pre>
<pre>
$layer->set("data",$colonne_geometrique." from (select ".$colonne_geometrique.",gid from .".$table_choisie.") as foo
using unique gid using SRID=".$srid);
</pre>
<pre class="moz-signature" cols="72">--david;
-------------------------------------------------
Jean David TECHER
e-mail: davidtecher(at)yahoo(dot)fr
site: <a class="moz-txt-link-freetext" href="http://techer.pascal.free.fr/postgis/">http://techer.pascal.free.fr/postgis/</a>
-------------------------------------------------
</pre>
<pre>
</pre>
<pre>jerome a écrit :</pre>
<blockquote cite="mid438F2469.3000501@vanoise.com" type="cite">
<pre>Hello Steffen,
</pre>
<pre>
</pre>
<blockquote type="cite">
<pre>The unique column must be of your $table_choisie because the SRID
</pre>
<pre>will be the same for the whole table and thus not unique.
</pre>
<pre>
</pre>
<pre>
</pre>
</blockquote>
<pre>This simple query didn't work :
</pre>
<pre>select * from unites_alpage using unique code_unitealpage
</pre>
<pre>
The field "code_unitealpage" is my PK for the table "unites_alpage".
When I try it, I obtain the same error :
</pre>
<pre>"ERROR: syntax error at or near "using" at character 29"
</pre>
<pre>
May be, I must say that I have backuped the BD in SQL format to recreate
it after upgrading pgsql 8.03 with pgsql8.1. I have restored the BD with
SQL script exec. Is there something wrong with this ?
</pre>
<pre>
Thanks
</pre>
<pre>
Jerome Caba
</pre>
<pre>_______________________________________________
</pre>
<pre>postgis-users mailing list
</pre>
<pre><a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
</pre>
<pre><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>
<pre>
</pre>
</blockquote>
</body>
</html>
___________________________________________________________________________
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger
Téléchargez cette version sur http://fr.messenger.yahoo.com