Huh. Seems like they fixed that, or I overlooked it the first time.
You should still be careful and test it well, I'm relatively sure Postgres will generate a new number every time you ask it to, and if an INSERT fails it won't roll back. I think. Not sure if it does that if you put it in a transaction.
Yes, I know we're talking MSSQL here, but the same caveat might apply.
If the sequences absolutely had to have no gaps, I wouldn't really trust anything other than an exclusive lock.
Eg. What happens if there are two concurrent transactions trying to use one sequence, and the first one fails but the second didn't?
Down this path is madness, and is why Oracle and Postgres (and probably others) just go with the simple, burn-a-value approach.
Another thought about semi/demi/hemi-open setups - perhaps it'd be better to only reveal the setup to the players once the rolecards are out (with an early reveal/RFC for club ded, of course).
This way, players can't publicly over-analyze the game before it starts without regard for their future roles.
(Of course this is only a good idea if club ded will do the over-analyzing and pointing out of any flaws instead)
@accalia when someone is killed will we be told of any flowers they had that night?
I have thought on this and i have decreed thus:
any information that would have been presented to the faction killed player at the dawn checkin will be present in the flip post, although it may be phrased differently than it would have in the dawn checkin to fit better with the theme of the public dawn results.
"You have done well, you have even defeated us. This time at least. But know this, You still owe a blood debt, and those that it is owed to will collect it. Rest easy for now, for the next time they come to collect you will not prevail!"
So saying @ChaosTheEternal puts the gun to his chin and pulls the trigger. BLAM! HOLY CARP! The gun may have been unloaded, but the chamber hadn't been cleared. That gave @ChaosTheEternal only one shot, but then he only needed one.
With @ChaosTheEternal dead, the rest of the councilors look around at each other in surprise, shock and horror. No one is quite certain who started laughing first, but quickly the surviving councilors are all laughing, a tired and nervous laughing to be sure, but laughter it is.
With the villains defeated, for now, there is much work to be done by the council, they have an entire industry to reorganize, and then there is the work they must do to prepare for the next time...
Eventually a clerk taps @aliceif on the shoulder and hands her a note:
Welcome, ChaosTheEternal. You are a Mafia Goon. Your assigned flower is Oleander
Factional communication: During the night phase only you may talk with your partners here [QuickTopic link].
Factional kill: Each night phase, one of you or your partners may perform the factional kill. Once a mafia member has attempted a faction kill they may not do so again until all other surviving mafia members have attempted at least as many faction kills as they have.
You win when all members of the town have been eliminated or nothing can prevent this from occurring.
All players please stand by for the full reveal of club ded, and the scum thread as our neighborhood, friendly, admins clean up this game in preparation for (scrabbles with notes) "The Resistance" run by... @r10pez10? huh. well that should be an absolute blast!
You agree on your plan and set of into the night to do your nefarious deeds. You all hope that your planning this night was enough to do what must be done to secure the overthrow of the flower council.
@Captain is taken from the council chambers by @abarker and @Maciejasjmj and unceremoniously defenestrated. As the glass shatters on the first floor window @Captain shouts "I was loyal! Long Live Accalia!"