Can you show the full traceback? On Thursday, 21 July 2016 15:53:04 UTC-5, Richard wrote: > > Did we open a ticket and solve this one... I think I have this issue... I > try to create an archive table and I fall on this error > > dal/pydal/adapters/postgres.py", line 181, in lastrowid > > return int(self.cursor.fetchone()[0]) > > > I can't figure out why so far... > > Richard > > On Wed, Aug 6, 2014 at 2:48 PM, Niphlod <niph...@gmail.com> wrote: > >> not really (scouting through code and docs seems that we're using only >> for postgresql something that isn't that "stable" when triggers are >> involved), but it's anyway fixable. >> >> >> On Wednesday, August 6, 2014 8:24:24 PM UTC+2, Leonel Câmara wrote: >>> >>> I don't think this "bug" is just in PostgreSQL. For instance MSSQL >>> should probably use OUTPUT INSERTED.ID to get the id and Oracle can use >>> RETURNING >>> like PostgreSQL too. >>> >>> Basically any kind of lastval variant can be problematic. >>> >>> >>> >> -- >> 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. >> > >
-- 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.