Commits

Tuukka Norri committed 085d7df

Schema qualification for lock table names

Comments (0)

Files changed (2)

Sources/BXPGClearLocksHandler.m

 		{
 			NSString* queryFormat =
 			@"SELECT DISTINCT ON (%@) l.* "
-			@"FROM %@ l NATURAL INNER JOIN %@ "
+			@"FROM baseten.%@ l NATURAL INNER JOIN %@ "
 			@"WHERE baseten_lock_cleared = true "
 			@" AND baseten_lock_backend_pid != pg_backend_pid () "
 			@" AND baseten_lock_timestamp > COALESCE ($1, '-infinity')::timestamp ";

Sources/BXPGLockHandler.mm

 	if ([notification backendPID] != backendPID)
 	{
 		NSString* query = 
-		@"SELECT * FROM %@ "
+		@"SELECT * FROM baseten.%@ "
 		@"WHERE baseten_lock_cleared = false "
 		@" AND baseten_lock_timestamp > COALESCE ($1, '-infinity')::timestamp "
 		@" AND baseten_lock_backend_pid != $2 "