Locking a table read-only temporarilty

2022-03-31 Thread Digimer
hit me with a clue-stick? Thanks! -- Digimer Papers and Projects: https://alteeve.com/w/ "I am, somehow, less interested in the weight and convolutions of Einstein’s brain than in the near certainty that people of equal talent have lived and died in cotton fields and sweatshops." - Stephen Jay Gould

Single mater replica setup for an existing DB

2021-08-15 Thread Digimer
ly ideally though async might be OK.   Any pointers / advice documentation links would be much appreciated. :) -- Digimer Papers and Projects: https://alteeve.com/w/ "I am, somehow, less interested in the weight and convolutions of Einstein’s brain than in the near certainty

Re: Weird procedure question

2018-09-25 Thread digimer
On 2018-09-25 6:41 p.m., digimer wrote: On 2018-09-25 6:22 p.m., Tim Cross wrote: digimer writes: Hi all,    I've got an interesting use case that I am stuck on. It's a bit of a complicated environment, but I'll try to keep it simple.    In short; I have a history schema

Re: Weird procedure question

2018-09-25 Thread digimer
On 2018-09-25 6:22 p.m., Tim Cross wrote: digimer writes: Hi all, I've got an interesting use case that I am stuck on. It's a bit of a complicated environment, but I'll try to keep it simple. In short; I have a history schema that has tables that match the public s

Re: Weird procedure question

2018-09-24 Thread digimer
Oh, this is a very interesting approach! I didn't realize any UUIDs could be created in a predictable way. Thank you, this might be what I need. digimer On 2018-09-25 1:47 a.m., James Keener wrote: Also, modified time doesn't need to be the current time, if it starts as "n

Re: Weird procedure question

2018-09-24 Thread digimer
nd up with different history_uuids on each database that I ran the query against. If I am missing something (and entirely possible I am), please hit me with a clue stick. :) digimer

Re: Weird procedure question

2018-09-24 Thread digimer
On 2018-09-25 1:22 a.m., digimer wrote:   Can I tell a produce to use a specific UUID? s/produce/procedure/

Weird procedure question

2018-09-24 Thread digimer
Hi all,   I've got an interesting use case that I am stuck on. It's a bit of a complicated environment, but I'll try to keep it simple.   In short; I have a history schema that has tables that match the public schema, plus one 'history_id' column that has a simple sequential bigserial value.