[postgis-users] MapServer interface to PostGIS errors

[Vinko Vrsalovic]

Hi, just to set a record in the archives.

If you want to render data from a subquery as in:

geom from (<subquery>) as foo using unique <uniquecol> using SRID=<srid>

make sure 'from' is in lowercase.

and make sure everything you'll use in the layer (classitem, labelitem)
is actually selected in the subquery.

I'm sending this as the error messages thrown in mappostgis.c when the
above conditions are not met are not very descriptive (Postgresql reports the error '')



-- 
Vinko Vrsalovic <el[|- at -|]vinko.cl>
http://www.cprsig.cl

  From MAILER-DAEMON  Mon Sep  8 16:46:19 2003
Return-Path: <>
Delivered-To: postgis-users at offsite.refractions.net
Received: from GWOUT.thalesgroup.com (gwout.thalesgroup.com [195.101.39.227])
	by offsite.refractions.net (Postfix) with ESMTP id 4A022437A7
	for <postgis-users at postgis.refractions.net>;
	Mon,  8 Sep 2003 16:46:19 -0700 (PDT)
Received: from thalescan.corp.thales (200.3.2.3) by GWOUT.thalesgroup.com
	(NPlex 6.5.026)
	id 3F4C863C000AA073 for postgis-users at postgis.refractions.net;
	Tue, 9 Sep 2003 01:49:06 +0200
Received: from lowplex.mut.thales ([10.33.37.2]) by thalescan with InterScan
	Messaging Security Suite; Tue, 09 Sep 2003 01:46:15 +0200
Received: from tisplex.tisfr.thales (142.1.6.1) by lowplex.mut.thales (NPlex
	6.5.026)
	id 3F52DE21000609E7 for postgis-users at postgis.refractions.net;
	Tue, 9 Sep 2003 01:53:57 +0200
Received: from tisplex.tisfr.thales (142.1.6.1) by tisplex.tisfr.thales (NPlex
	6.5.026)        id 3F5C42BB0000877D; Tue, 9 Sep 2003 01:46:15 +0200
Received: by sysecaplex.velizy.syseca (NPlex 6.5.026) id 3F52D43000020642;
	Tue, 9 Sep 2003 01:46:15 +0200
From: cedric.bernier at thales-is.com
Subject: Re: [postgis-users] MapServer interface to PostGIS errors
To: vinko at cprsig.cl, postgis-users at postgis.refractions.net
Date: Tue, 9 Sep 2003 01:46:15 +0200
Message-ID: <3F52D43000020641 at sysecaplex.velizy.syseca>
In-Reply-To: <20030908235006.GA29460 at landsat.cprsig.cl>
Precedence: junk
Delivered-To: cedric.bernier at thales-is.com
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: quoted-printable
X-BeenThere: postgis-users at postgis.refractions.net
X-Mailman-Version: 2.1b4
Reply-To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
List-Id: PostGIS Users Discussion <postgis-users.postgis.refractions.net>
List-Post: <mailto:postgis-users at postgis.refractions.net>
List-Subscribe: <http://postgis.refractions.net/mailman/listinfo/postgis-users>,
	<mailto:postgis-users-request at postgis.refractions.net?subject=subscribe>
List-Unsubscribe: <http://postgis.refractions.net/mailman/listinfo/postgis-users>,
	<mailto:postgis-users-request at postgis.refractions.net?subject=unsubscribe>
List-Archive: <http://offsite.refractions.net/pipermail/postgis-users>
List-Help: <mailto:postgis-users-request at postgis.refractions.net?subject=help>
X-List-Received-Date: Mon, 08 Sep 2003 23:46:20 -0000

  -----  The following is an automated response=0D
  -----  to your message generated on behalf of cedric.bernier at thales-is.=
com=0D

Bonjour,
Actuellement en mission =E0 l'=E9tranger, je suis indisponible du 7 Septe=
mbre au 8 Octobre 2003 .
Cordialement.