Re: [Dbix-class] SELECT ... FOR UPDATE SKIP LOCKED

2016-05-04 Thread Dmitry Belyavsky
Thank you! It seems to be old enough for my Debian installations. 4 Май 2016 г. 23:51 пользователь "Matthew Somerville" написал: > On 4 May 2016 at 21:19, Dmitry Belyavsky wrote: > > When did this possibility appeared? > > Looks like it first appeared in 0.08204 (2012-11-08), Changes has: >

Re: [Dbix-class] SELECT ... FOR UPDATE SKIP LOCKED

2016-05-04 Thread Matthew Somerville
On 4 May 2016 at 21:19, Dmitry Belyavsky wrote: > When did this possibility appeared? Looks like it first appeared in 0.08204 (2012-11-08), Changes has: * New Features / Changes - SQLMaker now accepts \'literal' with the 'for' rs attribute as an override to the builtin FOR o

Re: [Dbix-class] SELECT ... FOR UPDATE SKIP LOCKED

2016-05-04 Thread Francisco Obispo
I’m not sure, but I do know that it wasn’t supported and the most recent re-write introduced it. On 4 May 2016, at 13:19, Dmitry Belyavsky wrote: > Dear Francisco,  > Thank you! > When did this possibility appeared? signature.asc Description: OpenPGP digital signature ___

Re: [Dbix-class] SELECT ... FOR UPDATE SKIP LOCKED

2016-05-04 Thread Dmitry Belyavsky
Dear Francisco, Thank you! When did this possibility appeared? 4 Май 2016 г. 23:09 пользователь "Francisco Obispo" написал: > just use the scalar version: > > for > Value: ( 'update' | 'shared' | \$scalar ) > >Set to 'update' for a SELECT ... FOR UPDATE or 'shared' for a SELECT >... FOR

Re: [Dbix-class] SELECT ... FOR UPDATE SKIP LOCKED

2016-05-04 Thread Francisco Obispo
just use the scalar version: for Value: ( 'update' | 'shared' | \$scalar ) Set to 'update' for a SELECT ... FOR UPDATE or 'shared' for a SELECT ... FOR SHARED. If \$scalar is passed, this is taken directly and embedded in the query. with ``` { for => \q{U

[Dbix-class] SELECT ... FOR UPDATE SKIP LOCKED

2016-05-04 Thread Dmitry Belyavsky
Hello, is there a support for the PostgreSQL SELECT FOR UPDATE SKIP LOCKED clause in the DBIx::Class? And how difficult is to add it if not? Thank you! -- SY, Dmitry Belyavsky ___ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC