We're seeing a segmentation fault when creating a partition of a
partitioned table with a primary key when there is a sql_drop trigger on
Postgres 11beta4.
We discovered it because the Citus extension creates a sql_drop trigger,
but it's otherwise unrelated to the Citus extension:
On Thu, Nov 28, 2019 at 6:18 AM Amit Langote wrote:
> Interesting. Still, I think you'd be in better position than anyone
> else to come up with reproduction steps for vanilla PostgreSQL by
> analyzing the stack trace if and when the crash next occurs (or using
> the existing core dump). It's
On Fri, Dec 20, 2019 at 11:07 AM Andrey Borodin wrote:
> I think changing synchronous_standby_names to some available standbys will
> resume all backends waiting for synchronous replication.
> Do we need to check necessity of synchronous replication in any other case?
The GUCs are not
On Fri, Dec 20, 2019 at 6:04 AM Andrey Borodin wrote:
> I think proper solution here would be to add GUC to disallow cancellation of
> synchronous replication. Retry step 3 will wait on locks after hanging 1 and
> data will be consistent.
> Three is still a problem when backend is not canceled,
On Wed, Dec 25, 2019, 11:28 Maksim Milyutin wrote:
> But in this case locally committed data becomes visible to new incoming
> transactions that is bad side-effect of this issue.
>
Your application should be prepared for that in any case.
At the point where synchronous replication waits, the
On Thu, Mar 12, 2020 at 11:31 AM Julien Rouhaud wrote:
> There's at least the current version of IVM patchset that lacks the
> querytext. Looking at various extensions, I see that pg_background
> and pglogical call pg_plan_query internally but shouldn't have any
> issue providing the query text.
I've been running into a similar issue and am a little puzzled by it,
especially since it survives restarts.
On Fri, Dec 20, 2019 at 2:39 AM Tomas Vondra
wrote:
> Yeah, I don't see this error message anywhere in our sources on 11 or
> 12, so perhaps debezium does something funny? It's not clear
On Mon, Jul 18, 2022 at 8:29 AM Amit Kapila wrote:
> IIUC, this proposal is to optimize cases where users can't have a
> unique/primary key for a relation on the subscriber and those
> relations receive lots of updates or deletes?
I think this patch optimizes for all non-trivial cases of
On Wed, Aug 11, 2021 at 1:37 PM Amit Kapila wrote:
> I think it is and the context is generated via
> output_plugin_error_callback. Is this reproducible for you and if so,
> can you share a test case or some steps to reproduce this? Does this
> work and suddenly start giving errors or it happens
On Fri, Dec 23, 2022 at 11:43 AM Will Mortensen wrote:
> We'd like to be able to call the lock manager's WaitForLockers() and
> WaitForLockersMultiple() from SQL. Below I describe our use case, but
> basically I'm wondering if this:
>
> 1. Seems like a reasonable thing to do
>
> 2. Would
On Mon, Jan 9, 2023 at 11:37 PM Tom Lane wrote:
> Anyway, to get back to the point at hand: if we do have a REPLICA IDENTITY
> FULL situation then we can make use of any unique index over a subset of
> the transmitted columns, and if there's more than one candidate index
> it's unlikely to matter
11 matches
Mail list logo
