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

Dmitry Belyavsky beldmit at gmail.com
Wed May 4 20:19:01 GMT 2016


Dear Francisco,

Thank you!

When did this possibility appeared?
4 Май 2016 г. 23:09 пользователь "Francisco Obispo" <francisco at obispo.link>
написал:

> 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{UPDATE SKIP LOCKED}
> }
>
> On 4 May 2016, at 12:59, Dmitry Belyavsky wrote:
>
> 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: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive:
> http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
>
>
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive:
> http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20160504/580bd73d/attachment.htm>


More information about the DBIx-Class mailing list