Hi,
after upgrading to version 11, I see the error pattern "found xmin x
from before relfrozenxid y" in different databases on different hosts.
From https://www.postgresql.org/docs/10/static/release-10-3.html, I
learned that this was an error caused by pg_upgrade, which apparently
had been fixed
Thanks for your answer.
On 21/10/2018 16.24, Tom Lane wrote:
> In the meantime, the only answer I can think of offhand is to manually
> do VACUUM FREEZE on each of your MVs, and then refresh anything that
> shows up with an error.
Since I have so many of them, I decided to go for a quick-and-dirt
On 9/25/20 7:40 AM, tutilu...@tutanota.com wrote:
> I don't mean this to sound rude, but it's like talking to a wall... What
> I mean is that there are obviously technical means for software to know
> whether they are exhausting the system they are running on or not, and
> expecting people to under
On 20/01/2022 15.42, Avi Weinberg wrote:
Thanks David for the reply, but my question was a little different.
I know I can have multiple CTE queries like you showed, but I want to
have one single WITH query, and use it in multiple queries, not just by
one query the directly proceed the CTE.
Hi,
I am constructing a tsvector representation of some text manually
because I need to provide explicit positional parameters. In some cases,
the conversion fails and I get a "syntax error in tsvector".
This is a minimal example that goes wrong (but shouldn't IMHO:
SELECT format('%L:1',
Thanks, Tom.
On 23/02/2022 23.30, Tom Lane wrote:
=?UTF-8?Q?Johannes_Gra=c3=abn?= writes:
This is a minimal example that goes wrong (but shouldn't IMHO:
SELECT format('%L:1', '\:')::tsvector
format(%L) is designed to produce a SQL literal, which does not
have the same requirements as a
