On 5/31/24 14:18, Timo Schwaak wrote:
Dear PostgreSQL community,
I hope this is the right place for my concern.
Today I discovered a strange behaviour of the Windows Installer of
PostgreSQL.
While migrating an application database from MSSQL, the Postgres setup
did not seem to complete correct
Dear PostgreSQL community, I hope this is the right place for my concern. Today
I discovered a strange behaviour of the Windows Installer of PostgreSQL. While
migrating an application database from MSSQL, the Postgres setup did not seem
to complete correctly and had problems starting the Postgr
Thanks, Thom.
I understand from your response that there is really no way to repair the
current damage.
Yes, we do take daily backups and we have, in fact, restored the database
cluster to a point in time before the corruption, suffering some loss of data
in the process. I'm now working with th
On 5/30/24 15:34, johnlu...@hotmail.com wrote:
On 5/30/24 4:56 PM, David G. Johnston wrote:
Very little interest exists in working on user-specified rules. They
are practically deprecated.
Ah - pity - see my last comment to Adrian's
Any interest in perhaps providing a choice
On Fri, May 31, 2024, 09:29 Laurenz Albe wrote:
> On Thu, 2024-05-30 at 14:58 +, Alanoly Andrews wrote:
> > We have a postgres 10.7 database which reports a number of issues on
> user-created
> > tables as well as system tables. Most errors are one of the following:
> > -- ERROR: found xmin
On Thu, 2024-05-30 at 14:58 +, Alanoly Andrews wrote:
> We have a postgres 10.7 database which reports a number of issues on
> user-created
> tables as well as system tables. Most errors are one of the following:
> -- ERROR: found xmin 1888159934 from before relfrozenxid 1998177448
> -- ERROR
> On 31 May 2024, at 00:34, johnlu...@hotmail.com wrote:
>
> On 5/30/24 4:56 PM, David G. Johnston wrote:
(…)
>> If anything is done it would have to be new syntax.
>>
>>
> A much bigger task surely.
>
> On 5/30/24 5:19 PM, Adrian Klaver wrote:
>>
>> 2) Use INSTEAD OF triggers:
>>
>>
