grep RETURNING
web2py/gluon/packages/dal/pydal/adapters/*.py
returns nothing. Perhaps the driver is adding it. Not web2py.
Massimo
On Monday, 25 July 2016 12:50:25 UTC-5, Madhavi wrote:
>
> 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 [email protected].
For more options, visit https://groups.google.com/d/optout.
