the returning statement is in /dialects/ :-P
it definitely is a huge improvement over the "usual"
lastval()/currval()/etc, BUT AFAIK it's not turned on by default.
@giobar0, thoughts ?
On Wednesday, July 27, 2016 at 9:21:04 AM UTC+2, Massimo Di Pierro wrote:
>
> 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.
