[teiid-issues] [JBoss JIRA] (TEIID-4851) Random errors about PostGIS without using it

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4851?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-4851.
-----------------------------------
    Fix Version/s: 10.1
                   9.3.6
                   10.0.2
       Resolution: Done


Postgresql will invalidate a connection in a transaction after a query with an error, so a savepoint was added to isolate the failure.

[~mcouliba] Please let cee know if you need this in a product release.

> Random errors about PostGIS without using it
> --------------------------------------------
>
>                 Key: TEIID-4851
>                 URL: https://issues.jboss.org/browse/TEIID-4851
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 8.12.8.6_3
>         Environment: Squirrel v3.7
> Teiid JDBC 8.13.1
> JDV 6.3.4
> PostgreSQL 9.6
>            Reporter: Madou Coulibaly
>            Assignee: Steven Hawkins
>             Fix For: 10.1, 9.3.6, 10.0.2
>
>         Attachments: server.log
>
>
> When I issue queries using SQuirrel, I get the following error at random whereas I do not use any Geo functions:
> Originally TeiidProcessingException 'ERROR: function postgis_full_version() does not exist
> Hint: No function matches the given name and argument types. You might need to add explicit type casts.
> Position: 8' QueryExecutorImpl.java:2455. Enable more detailed logging to see the entire stacktrace.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)