Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Postgres for_update skip locking #19

Closed
fhendrikx opened this issue Aug 9, 2019 · 1 comment

Comments

@fhendrikx
Copy link

commented Aug 9, 2019

Hi,

Postgres supports for_update locking with either "nowait" or "skip locked", however, adding skip_locked => 1 has no effect.

Can this be added to the Rose/DB/Pg.pm module?

I believe the following should be sufficient:

diff -w Pg.pm Pg.pm.new
154a155,159

if($lock->{'skip_locked'})
{
$sql .= ' SKIP LOCKED';
}

Thank you.

@siracusa

This comment has been minimized.

Copy link
Owner

commented Aug 9, 2019

Fixed in Rose::DB 0.779, just uploaded to CPAN.

@siracusa siracusa closed this Aug 9, 2019

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
2 participants
You can’t perform that action at this time.