Re: issue/bug management, project management, people management, product management all in one, preferably open source software ?

2025-05-27 Thread Achilleas Mantzios
On 5/22/25 19:50, Sam Gendler wrote: I think the closest you would get to a single product for all that is a single suite of products which are reasonably well-integrated. issue, project, and product management are almost always combined unless you are just using github issue tracking or the l

Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

2025-05-27 Thread Alvaro Herrera
Hello, Belatedly, I came back to this issue in the release notes. Here's a query for correctly reporting the problem and not reporting the cases where there isn't a problem: SELECT conrelid::pg_catalog.regclass AS "constrained table", conname AS constraint, confrelid::pg_catalog.re

Re: Changing a varchar(7) domain into text directly in pg_type

2025-05-27 Thread Adrian Klaver
On 5/27/25 7:27 AM, Richard Zetterberg wrote: Hello, I have a read-only table that contains a set of never changing categories. Each category has a unique alpha numerical ID and a description. The purpose of this table is so that other tables can reference the ID of this table, to make sur

Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

2025-05-27 Thread Tom Lane
Alvaro Herrera writes: > I'm going to fix the query in the release notes for all past branches > now, to avoid confusing people upgrading in the future ... hopefully not > many, but I don't think it's going to be zero people. OK, thanks. regards, tom lane

Changing a varchar(7) domain into text directly in pg_type

2025-05-27 Thread Richard Zetterberg
Hello, I have a read-only table that contains a set of never changing categories. Each category has a unique alpha numerical ID and a description. The purpose of this table is so that other tables can reference the ID of this table, to make sure that they don't contain invalid/unknown categories a

Streaming Replication Disconnection Behavior under recovery_min_apply_delay Configuration

2025-05-27 Thread Riku Kashiwaki (Fujitsu)
I would like to know the behavior when disconnecting streaming replication. An attempt was made to disconnect streaming replication from a standby server during streaming replication by using the ALTER SET command and setting primary _conninfo to an empty string. However, we have observed that if