On Mon, Feb 16, 2015 at 10:02:14PM +, Miller, Stephan wrote:
> I highlighted where I think the error is occurring in red below.
Please, *please*, don't use colors to highlight texts.
I know we're in 2015 and the internet is full of colorful moving puppets,
but if we stick to low tech it's eas
Hey Stephan,
I'm afraid I must say the coding style is not good and dangerous.
And I know that the very nature of plpgsql langage (and doc) make it
difficult to produce a nice function.
AS it is, it is very hard to read it, and any user of your function could
potentially inject SQL via your funct
Remi –
Thanks for your response.
I tried to use “execute format('CREATE TABLE %I AS SELECT objectid, f_code,
shape FROM %I ; ', updatedtablename, tablename) ;” as you suggested. I got
the following error
ERROR: prepared statement "format" does not exist
** Error **
ERROR:
Here is the "cleaned" version, still no good tough.
I don't understand what you want to do, I don't have your table structure
nor your data, so you will need to work from that.
CREATE OR REPLACE FUNCTION hc_check_gaps_in_linear_topology(IN tablename
text, IN cleantopo text)
RETURNS TABLE(obje
Hi Everybody,
Running:
POSTGIS="2.2.0dev r13208" GEOS="3.4.2-CAPI-1.8.2 r3921" PROJ="Rel. 4.8.0, 6
March 2012" GDAL="GDAL 1.10.1, released 2013/08/26" LIBXML="2.9.1"
LIBJSON="0.11.99" TOPOLOGY RASTER
In the process of loading 2014 TIGER data but see there are issues with the
TABBLOCK table as it