On Thu, Jul 28, 2016 at 10:18 AM, Josh Berkus wrote:
> On 07/26/2016 01:16 AM, David Harrison wrote:
> where sps.sessionid = ses and
> sps.rankid = rank and
> ...
> pg_try_advisory_lock(seatid)
> order by s.row_number, s.seat_number_in_row
> limit 1
> for
On 07/26/2016 01:16 AM, David Harrison wrote:
> Hi Josh,
>
> Attached is the function and below the query that calls it, below that the
> result of SELECT version();
>
> SELECT tl_guest_list('13313880', '174880', null, '151094636600', null, null);
>
>
>
>
>
> "PostgreSQL 8.4.9 on
Hi everyone,
I am running 'PostgreSQL 9.1.4, compiled by Visual
C++ build 1500, 64-bit' on a Windows Server and I am having some Locking
issues. Maybe anyone can let me know what is wrong with my example:
Imagine that we have two tables (t_users and t_records)
t_users contains 1 row per