<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1522" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have recently read about bug 1443 (about "using
unique" clause).</FONT></DIV>
<DIV><FONT face=Arial size=2>My apollogies for my previous post about this bug
but I didn't see it before.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I have tryed to using only "using SRID=-1" instead
of "using unique att using SRID=-1" but another error occoured:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>msPOSTGISLayerRetrievePK(): Error executing POSTGIS
statement (msPOSTGISLayerRetrievePK():select attname from pg_attribute,
pg_constraint, pg_class where pg_constraint.conrelid = pg_class.oid and
pg_class.oid = pg_attribute.attrelid and pg_constraint.contype = "p" and
pg_constraint.conkey[1] = pg_attribute.attnum and pg_class.relname = "(SELECT
the_geom,gid,type,name from places WHERE site_id = 1037 and layer = 'lyr_1158')
as foo" and pg_constraint.conkey[2] is null</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I think that the error is occoured because in my
select query there is the ' that is not escaped.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Is this another bug?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks.</FONT></DIV>
<DIV><FONT face=Arial size=2>Stefano</FONT></DIV></BODY></HTML>