<html>
<head>
</head>
<body style="margin-right: 4px; margin-top: 4px; margin-left: 4px; margin-bottom: 1px; line-height: normal; font-variant: normal">
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">All,</font> </p>
<br>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">made nice progress from Simon's suggestions, but . . .</font> </p>
<br>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">Ok, I'm probably trying to push this harder than I need to, but, I'm trying to ST_Transform the data from 4326 to 200068 (Our private projection) in the construction of the view, but I keep hitting permission errors. </font> </p>
<br>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">NOTE: we use the 200068 projection for all of our data, have for years. It's definition in SPATIAL_REF_SYS is correct. </font> </p>
<br>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">This works fine:</font> </p>
<br>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3">select</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> ST_SetSRID(ST_MakePoint(part3::numeric, part4::numeric),4326) as geom,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> ST_AsText(ST_SetSRID(ST_MakePoint(part3::numeric, part4::numeric),4326)) as geom_text</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> from</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> (select rxtime,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> split_part(cmd, ',', 3) as part3,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> split_part(cmd, ',', 4) as part4</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> from </font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> cmdstpinfo</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> where cmd </font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> like '>Plot:%') AS first_pass;</font><font face="Comic Sans MS" size="3"></font> </p>
<br>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">But this give me an error, do I have the ST_Transform in the right spot, is 8.4.2 too old of a release? :</font> </p>
<br>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3">select</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> ST_SetSRID(ST_MakePoint(part3::numeric, part4::numeric),4326) as geom,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> ST_AsText(ST_SetSRID(ST_MakePoint(part3::numeric, part4::numeric),4326)) as geom_text,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> ST_AsText(ST_Transform(ST_SetSRID(ST_MakePoint(part3::numeric, part4::numeric),4326)), 200068) as geom_city</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> from</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> (select rxtime,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> split_part(cmd, ',', 3) as part3,</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> split_part(cmd, ',', 4) as part4</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> from </font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> cmdstpinfo</font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> where cmd </font> </p>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Courier New" size="3"> like '>Plot:%') AS first_pass;</font><font face="Comic Sans MS" size="3"></font> </p>
<br>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">Like:</font> </p>
<br>
<div>
<font face="Courier New">ERROR: function st_transform(geometry) does not exist<br style="font-family: Courier New">LINE 4: ST_AsText(ST_Transform(ST_SetSRID(ST_MakePoint(pa...<br style="font-family: Courier New"> ^<br style="font-family: Courier New">HINT: No function matches the given name and argument types. You might need to add explicit type casts.</font> </div>
<div>
<font face="Courier New"> </font> </div>
<div>
<font face="Courier New">********** Error **********</font> </div>
<div>
<font face="Courier New"> </font> </div>
<div>
<font face="Courier New">ERROR: function st_transform(geometry) does not exist<br style="font-family: Courier New">SQL state: 42883<br style="font-family: Courier New">Hint: No function matches the given name and argument types. You might need to add explicit type casts.<br style="font-family: Courier New">Character: 212</font> </div>
<br> <br>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">Thanks</font> </p>
<br>
<p style="margin-bottom: 0; margin-top: 0">
<font face="Comic Sans MS" size="3">bobb</font> </p>
<br> <br>
</body>
</html>