From e8f97c9e357ed0793ce11086823f83aa4a8bb4ad Mon Sep 17 00:00:00 2001
From: Jack Zhou <univerio@gmail.com>
Date: Tue, 31 May 2016 10:01:46 -0400
Subject: Add SKIP LOCKED support for Postgresql, Oracle

This adds `SELECT ... FOR UPDATE SKIP LOCKED`/
`SELECT ... FOR SHARE SKIP LOCKED` rendering.

Change-Id: Id1dc4f1cafc1de23f397a6f73d54ab2c58d5910d
Pull-request: https://bitbucket.org/zzzeek/sqlalchemy/pull-requests/86
---
 lib/sqlalchemy/dialects/postgresql/base.py | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'lib/sqlalchemy/dialects/postgresql/base.py')

diff --git a/lib/sqlalchemy/dialects/postgresql/base.py b/lib/sqlalchemy/dialects/postgresql/base.py
index 136cb1b28..1bc4409f2 100644
--- a/lib/sqlalchemy/dialects/postgresql/base.py
+++ b/lib/sqlalchemy/dialects/postgresql/base.py
@@ -1185,6 +1185,8 @@ class PGCompiler(compiler.SQLCompiler):
 
         if select._for_update_arg.nowait:
             tmp += " NOWAIT"
+        if select._for_update_arg.skip_locked:
+            tmp += " SKIP LOCKED"
 
         return tmp
 
-- 
cgit v1.2.1