Re: [postgis-users] postgis-users Digest, Vol 163, Issue 11

2015-09-25 Thread Bistrais, Bob
Hi Birgit and David, Many thanks for your replies. I actually tried what you had suggested. Quoting the variable as '@myvariable' caused the liteal string, @myvariable, to be passed. I also tried casting, but the variable still got passed as an integer, without quots, causing an error. In o

Re: [postgis-users] invalid join selectivity: 179531936.000000

2015-09-25 Thread Rémi Cura
Yep, I had the same problem https://trac.osgeo.org/postgis/ticket/2543 The issue is that this bug is hard to reproduce. As a workaround, you can try to drop and recreate the table : DROP TABLE VACUUM FULL ANALYZE CREATE TABLE CREATE INDEX Cheers, Rémi-C 2015-09-25 1:32 GMT+02:00 Paul J. Cari