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
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:
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 is empty.
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
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