Re: ERROR: found xmin from before relfrozenxid; MultiXactid does no longer exist -- apparent wraparound

2024-05-31 Thread Alanoly Andrews
But I was still interested in what the postgres gurus/programmers/hackers had to say about this event. Regards. Alanoly. From: Thom Brown Sent: May 31, 2024 6:14 AM To: Laurenz Albe Cc: Alanoly Andrews ; pgsql-general@lists.postgresql.org Subject: Re: ERROR:

ERROR: found xmin from before relfrozenxid; MultiXactid does no longer exist -- apparent wraparound

2024-05-30 Thread Alanoly Andrews
me errors. The database is up and running and most of the tables are accessible. But any kind of SQL on the 4 or 5 affected tables throws the error. Is there a way to repairing the corruption in this database? Postgres Version 10.7 on Linux(Ubuntu). Thanks. Alanoly Andrews (alano...@in

RE: Using a different column name in a foreign table

2022-01-21 Thread Alanoly Andrews
: Friday, January 21, 2022 1:14 PM To: Alanoly Andrews ; Tom Lane ; Guillaume Lelarge Cc: pgsql-general@lists.postgresql.org Subject: Re: Using a different column name in a foreign table [Email External/Externe] Caution opening links or attachments/attention lors de l'ouverture de liens ou de

RE: Using a different column name in a foreign table

2022-01-21 Thread Alanoly Andrews
s not exist". But a double quote around a lower-case column name does not produce the error. Is this a bug that needs to be fixed? I always thought that table names and column names were case-insensitive with regard to SQL's. A.A. -Original Message- From: Alanoly A

RE: Using a different column name in a foreign table

2022-01-21 Thread Alanoly Andrews
ain later, if needed. Thanks. A.A. -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Friday, January 21, 2022 11:52 AM To: Alanoly Andrews Cc: pgsql-general@lists.postgresql.org Subject: Re: Using a different column name in a foreign table [Email External/Extern

Using a different column name in a foreign table

2022-01-21 Thread Alanoly Andrews
does not take effect. Is there a resolution to this issue? Awaiting some input. Alanoly Andrews. This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it conta

RE: Streaming replication versus Logical replication

2021-11-04 Thread Alanoly Andrews
disk space (either on the publisher or on the subscriber)? Regards. Alanoly Andrews. From: Ninad Shah [mailto:nshah.postg...@gmail.com] Sent: Thursday, November 4, 2021 2:20 PM To: Alanoly Andrews Cc: pgsql-general@lists.postgresql.org Subject: Re: Streaming replication versus Logical replication

Streaming replication versus Logical replication

2021-11-04 Thread Alanoly Andrews
will there be table bloat on the primary database? What is the mechanism by which data changes on the "publisher" are propagated to the "subscriber"? What happens when the subscriber database has an long-running query? Thanks. Alanoly Andrews. This e-mail may be privil