Re: Index (primary key) corrupt?

2025-09-19 Thread Adrian Klaver
On 9/19/25 06:23, Wim Rouquart wrote: What is the result for the query?: select * from pg_index where indexrelid = 'idx_376814_primary'::regclass; Name |Value | ---+---+ indexrelid |2006873| indrelid |1998823| indnatts |1

Re: Index (primary key) corrupt?

2025-09-19 Thread Adrian Klaver
On 9/19/25 02:40, Wim Rouquart wrote: Internal Internal Hello, When doing a pg_dump of one of our databases one of the tables primary keys doesn’t get exported. Pg_dump just skips this index, without any warning whatsoever (verbose mode was used to doublecheck). What is the complete table

Re: MVCC and all that...

2025-09-19 Thread Ellen Allhatatlan
> > In part 1. Differences in MVCC implementation - he's saying that "It’s > > not that the PostgreSQL implementation of MVCC is bad — it’s just > > fundamentally different" > It is written by someone @firebirdsql.org so one assumes a few grains of salt > necessary. I know - but the guy does st

Re: Client/server certificates verification support on Android platform

2025-09-19 Thread Daniel Gustafsson
> On 19 Sep 2025, at 12:18, Mathieu Pellerin wrote: > Would it make sense for other operating systems beyond Windows to also have > relaxed permissions within specific application-specific folders? On Android, > the application’s data directory would certainly match a similar set of > secure a

Client/server certificates verification support on Android platform

2025-09-19 Thread Mathieu Pellerin
Greetings, I’m writing with regards to client/server certificates verification support on Android platform, where storage access is increasingly limited and often happens through a dedicated system user that differs from the user that runs applications. A bit of background: we develop QField, an

Re: PostgreSQL Account and Object Timestamp Logging

2025-09-19 Thread Dominique Devienne
On Fri, Sep 19, 2025 at 4:56 AM 張宸瑋 wrote: > *log* the creation time of user accounts and database objects. Yes, indirectly, via event triggers: https://www.postgresql.org/docs/current/event-trigger-matrix.html But that's specific to a DB, does [NOT fire for CREATE USER/ROLE][1], only some objec