[unixODBC-support] BUG: postgresql prepare statment doesn't support creating tables

support at vip-consult.co.uk support at vip-consult.co.uk
Mon Oct 26 18:13:40 GMT 2015


Hi all could you please comment on this bug report ?


Kind Regards Chris    Happy with our service ? 
      Join us and leave feedback 
     

        
      08455 271771    01202 232240 
      Company Registration No. 8434950  


From: support at vip-consult.co.uk 
Sent: Thursday, October 22, 2015 5:39 PM
To: unixodbc-support at mailman.unixodbc.org 
Subject: BUG: postgresql prepare statment doesn't support creating tables

hi all 

the postgresqk  unixdbc driver doesn’t seem to work with table create statments on Debian Jessie
on isql trying to execute 
CREATE TABLE a (c integer)
ERROR:  syntax error at or near "create" at character 29

I have looked at the logs and it seems that is uses PREPARE create table   statments which as far as I know  is not supported in postgresql
ERROR:  syntax error at or near "create" at character 29
STATEMENT:  PREPARE "_PLAN0x25ca9e0" as create table aaa (aa integer);;EXECUTE "_PLAN0x25ca9e0"

is there any way to disable prepare statements or  a better way fix this bug ?

Debian jessie 
unixODBC 2.3.4
postgresql 9.3 (also tried latest)


[freeswitch]
Driver        = /usr/lib/x86_64-linux-gnu/odbc/psqlodbcw.so
Description=Connection to LDAP/POSTGRESQL
Servername=localhost 
Port=5432   
Protocol=6.4
FetchBufferSize=99
Username=fs 
Password=xxxxx
Database=fs 
ReadOnly=no
Debug=1
CommLog=1



Kind Regards Chris 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20151026/f2dcb01e/attachment.html>


More information about the unixODBC-support mailing list