attached, lmk if you have questions.
Robert Treat
https://xzilla.net
replication-wordsmithing.patch
Description: Binary data
On Fri, Sep 11, 2020 at 9:46 PM Michael Paquier wrote:
>
> On Fri, Sep 11, 2020 at 07:16:43PM -0400, Robert Treat wrote:
> > A recent discussion on slack prompted me to read through the
> > high-availability section of the docs, turning in to some suggested
> > changes th
On Mon, Sep 14, 2020 at 4:11 AM Michael Paquier wrote:
>
> On Sat, Sep 12, 2020 at 12:40:45PM -0400, Robert Treat wrote:
> > maybe "to one or more replicas." or maybe "to one or more replica
> > targets." I'd avoid the word cluster because you could set
et again, and applied most of the
> suggested changes on HEAD as of 8550cbd, updating while on it some
> extra instances of "master" to "primary" to be more consistent with
> the other changes of this patch.
Merci monsieur!
Robert Treat
https://xzilla.net
ementation to put into core, but there
are some attempts to solve this problem floating around in extension
land. See https://github.com/mweber26/timestampandtz/blob/master/README.md
as one such attempt.
Robert Treat
https://xzilla.net
From 359a2df63065e3327ca3ab7cb0cfb73da6934a31 Mon Sep 17 00
On Mon, Feb 3, 2025 at 12:23 PM Tom Lane wrote:
>
> =?utf-8?Q?=C3=81lvaro?= Herrera writes:
> > On 2025-Feb-03, Robert Treat wrote:
> >> This does seem to come up often enough that it probably is worth being
> >> a bit more explicit about how this works; att
On Fri, Feb 7, 2025 at 11:56 AM Miłosz Chmura wrote:
>
>
>
> On Thu, Feb 6, 2025 at 10:22 PM Robert Treat wrote:
> > On Wed, Feb 5, 2025 at 5:11 AM PG Doc comments form
> > wrote:
> > >
> > > The following documentation comment has been logg
ot;name": "Wonder", "authors": [{"name": "Jun Murakami"},
{"name":"Craig Doe"}]}]
}}'::json, '$.favorites[*]' as fav
COLUMNS (
user_id FOR ORDINALITY,
NESTED '$.movies[*]'
COLUMNS (
movie_id FOR ORDINALITY,
mname text PATH '$.name',
director text),
NESTED '$.books[*]' as book
COLUMNS (
book_id FOR ORDINALITY,
bname text PATH '$.name',
NESTED '$.authors[*]' as writer
COLUMNS (
author_id FOR ORDINALITY,
author_name text PATH '$.fav.book.writer.name';
Note the last line. My assumption is that people concoct complIcated
enough json objects and path expressions that the aliasing makes it a
bit easier to follow. If that example sparks an example that you think
is worth adding (or maybe you think the above is?) please post it to
the list, I'd be happy to work it into a patch.
Robert Treat
https://xzilla.net
On Thu, Feb 6, 2025 at 5:33 PM Tom Lane wrote:
> Robert Treat writes:
> > On Mon, Feb 3, 2025 at 12:23 PM Tom Lane wrote:
> >> Hmm, I kind of like the up-front statement that timestamptz stores
> >> UTC. How about this simpler change?
>
> > I thought the re-
On Fri, Feb 14, 2025 at 3:00 AM Amit Langote
wrote:
> On Sun, Feb 9, 2025 at 12:59 AM Robert Treat wrote:
> > So, how does this thing get used? AFAIK there is no way to reference
> > these aliases at the query level, instead they only show up within
> > EXPLAIN VERBOSE
e talking about either streaming or wal shipping,
so I don't think we can completely eliminate that, but hopefully this
improves what we have.
> I don't think our current setup is sustainable so I think it does need
> to be cleaned up. Also, physical/logical replication slots also n
nd discussed.
> + the script used to find that information so that both the script
> + and the information can be checked and discussed.
>
>
+1 from me.
Robert Treat
https://xzilla.net
ons should be able
to stand on their own while we are also making references back to
previous lessons. In this case, it does seem like we could satisfy
both use cases by adding:
DROP TABLE cities IF EXISTS;
DROP TABLE weather IF EXISTS;
Before the new create table commands. If you are following
sequentially, these will clean up for you, and if you came here as a
stand-alone these will no-op;
Robert Treat
https://xzilla.net
13 matches
Mail list logo
