[postgis-users] Postgis extension

[Regina Obe]

Have you asked Alteryx about that.  The psqlodbc driver has no knowledge of
geometry_columns so I don't think this is an ODBC issue.  It would be
something in there use in their queries causing the failure.

Like for example if they are using GDAL (which underneath does use PSQLODBC)
it looks for geometry_columns table, but you can turn this off with an
environment variable.

 

https://gdal.org/drivers/vector/pg.html#vector-pg

 

In GDAL  LIST_ALL_TABLES=YES

 

A lot of third-party tools do use GDAL for spatial support so could be that.

 

But I wouldn't have a clue where you'd set that in their use if that were
the case.

 

 

 

 

 

From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf
Of imran hussain
Sent: Tuesday, June 30, 2020 7:24 PM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Subject: Re: [postgis-users] Postgis extension

 

I am trying to connect from Alteryx using psqlodbc driver. The
geometry_columns table is not populated for the table I am trying to access,
since it's got no spatial data.

 

  _____  

From: postgis-users <postgis-users-bounces at lists.osgeo.org
<mailto:postgis-users-bounces at lists.osgeo.org> > on behalf of Simon Greener
<simon at spatialdbadvisor.com <mailto:simon at spatialdbadvisor.com> >
Sent: Tuesday, June 30, 2020 4:46:40 PM
To: PostGIS Users Discussion <postgis-users at lists.osgeo.org
<mailto:postgis-users at lists.osgeo.org> >
Subject: Re: [postgis-users] Postgis extension 

 

Is geometry_columns fully populated?




Get BlueMail for Android <http://www.bluemail.me/r?b=15860>  

On 1 Jul 2020, at 07:19, Regina Obe <lr at pcorp.us <mailto:lr at pcorp.us> >
wrote: 

Which system are you connecting from?  Sounds like whatever system you are
using is designed to work with spatial tables. Like as I recall I think
ArcMap uses PostgreSQL ODBC driver.

 

There isn't any reason otherwise why you should be having issue connecting
to a non-spatial table.  I connect via SQL Server and MS Access all the time
even when I have spatial tables in my database.  There isn't even any reason
why a system would check geometry_columns unless it's designed to work with
spatial data.

 

Hope that helps,

Regina

 

From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On Behalf
Of imran hussain
Sent: Tuesday, June 30, 2020 3:47 PM
To: 'PostGIS Users Discussion' <postgis-users at lists.osgeo.org
<mailto:postgis-users at lists.osgeo.org> >
Subject: [postgis-users] Postgis extension

 

Hi,

 

I am trying to access the Postgres DB using ODBC driver. I have Postgis
extension installed on my DB and when trying to query the non-spatial tables
from the tool, I keep getting the error "no records returned from
GEOMETRY_COLUMNS for this table". Is there any environment variable that
would let the ODBC know that its a non spatial table and avoid looking into
GEOMETRY_COLUMNS view ?

 

Thanks,

Imran Hussain



  _____  


postgis-users mailing list
postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org> 
https://lists.osgeo.org/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200630/1151d44d/attachment.html>