[teiid-issues] [JBoss JIRA] (TEIID-1460) Have teiid emulate a native postgresql database connection

Steven Hawkins (JIRA) jira-events at lists.jboss.org
Wed Aug 15 08:44:15 EDT 2012


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

Steven Hawkins updated TEIID-1460:
----------------------------------

    Affects: Documentation (Ref Guide, User Guide, etc.),Compatibility/Configuration,Release Notes


See also the admin guide for the system properties to emulate pg query semantics.
                
> Have teiid emulate a native postgresql database connection
> ----------------------------------------------------------
>
>                 Key: TEIID-1460
>                 URL: https://issues.jboss.org/browse/TEIID-1460
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: Server
>    Affects Versions: 7.3
>         Environment: All environments
>            Reporter: Graeme Gillies
>            Assignee: Steven Hawkins
>            Priority: Minor
>             Fix For: 7.1.1, 7.4.1, 7.5
>
>         Attachments: pgclient.py, preparedodbctest.pl, testselect.py
>
>
> Currently we are using postgresql-odbc, and unixODBC to connect to teiid via the emulated postgresql ODBC connection on port 35432. Unfortunately, this is cumbersome to use, requires fiddling with setting up ODBC, and is difficult for integration into non-java languages (that have to use the ODBC connection).
> What we would like is for teiid to emulate a postgresql database such that we can point typical postgresql tools (such as psql) to port 35432 (or some other port) and they will "work". That would also allow us to use each languages native/preferred method of connecting to a postgresql database to connect to teiid. E.g. DBD::Postgres for perl, ruby-pg for ruby, pg/pgdb in python, etc.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        


More information about the teiid-issues mailing list