Re: BUG: postgresql prepare statment doesn't support creating tables

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: BUG: postgresql prepare statment doesn't support creating tables

support
Hi all could you please comment on this bug report ?
 

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

Vip consult Logo
08455 271771    01202 232240
Company Registration No. 8434950
 
Sent: Thursday, October 22, 2015 5:39 PM
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

_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: BUG: postgresql prepare statment doesn't support creating tables

Nick Gorham-2
On 26/10/15 18:13, [hidden email] wrote:
Hi all could you please comment on this bug report ?
 

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

Vip
                        consult Logo
08455 271771    01202 232240
Company Registration No. 8434950
 
Sent: Thursday, October 22, 2015 5:39 PM
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

Try

isql -e freeswitch

To call SQLExecDirect instead of SQLPrepare/SQLExecute

Though thats just a workround, the bug is in the driver, so I would ask the driver writers as to the solution.

--
Nick

_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: postgresql prepare statment doesn't support creating tables

support
In reply to this post by support
For some reason I am not receiving any email from this mailing list.

I checked your reply in the website archive.
 
Thanks for the suggestion.

I am using freeswitch with the unixodbc driver and I don’t think I can set the –e param there.

I will wait until the driver is fixed hopefully it would be an easy one for the devs.
 
Thanks
 
Sent: Monday, October 26, 2015 8:13 PM
Subject: Re: BUG: postgresql prepare statment doesn't support creating tables
 
Hi all could you please comment on this bug report ?
 

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

Vip consult Logo
08455 271771    01202 232240
Company Registration No. 8434950
 
Sent: Thursday, October 22, 2015 5:39 PM
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

_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: postgresql prepare statment doesn't support creating tables

support
In reply to this post by Nick Gorham-2
 
is there any progress with this bug ?
 
I want to use it with freeswitch which doesn’t support the  isql –e switch

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

Vip consult Logo
08455 271771    01202 232240
Company Registration No. 8434950
 
Sent: Monday, October 26, 2015 8:24 PM
Subject: Re: BUG: postgresql prepare statment doesn't support creating tables
 
On 26/10/15 18:13, [hidden email] wrote:
Hi all could you please comment on this bug report ?
 

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

Vip
                        consult Logo
08455 271771    01202 232240
Company Registration No. 8434950
 
Sent: Thursday, October 22, 2015 5:39 PM
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

Try

isql -e freeswitch

To call SQLExecDirect instead of SQLPrepare/SQLExecute

Though thats just a workround, the bug is in the driver, so I would ask the driver writers as to the solution.

--
Nick

_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: postgresql prepare statment doesn't support creating tables

Nick Gorham-2
On 22/11/15 19:10, [hidden email] wrote:
 
is there any progress with this bug ?
 
I want to use it with freeswitch which doesn’t support the  isql –e switch

Kind Regards Chris

Sorry, are you asking me?

Its the driver, not unixODBC. I don;t know what freeswitch is. Does it call isql ?

--
Nick

_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: postgresql prepare statment doesn't support creating tables

support
No problem I will ask the driver’s devs
 

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

Vip consult Logo
08455 271771    01202 232240
Company Registration No. 8434950
 
Sent: Sunday, November 22, 2015 11:11 PM
Subject: Re: postgresql prepare statment doesn't support creating tables
 
On 22/11/15 19:10, [hidden email] wrote:
 
is there any progress with this bug ?
 
I want to use it with freeswitch which doesn’t support the  isql –e switch

Kind Regards Chris

Sorry, are you asking me?

Its the driver, not unixODBC. I don;t know what freeswitch is. Does it call isql ?

--
Nick

_______________________________________________
unixODBC-support mailing list
[hidden email]
http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support
Loading...