I am trying to connect web2py to GreenPlum 4.3.8.2, which does not support
the RETURNING clause of PostGreSQL by using the below DAL string:
db=DAL('postgres://user1:password@serverip/mydatabase')
The connection is established successfully, and auth tables are created.
However, when I attempt to register (and a record has to be inserted), I
get the following error:
*<class 'psycopg2.NotSupportedError'> The RETURNING clause of the INSERT
statement is not supported in this version of Greenplum Database.*
I am assuming this is happening because the default PostGreSQLAdapter is
including returning clause for passing on SQL queries for insertion. Please
let me know if there is any work-around, or if there is any alternative
adapter which I can use to work with web2py using GreenPlum smoonthly.
Thanks,
Madhavi
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
