Re: Broken NewbieDoc Docbook Guide link

2025-08-14 Thread Álvaro Herrera
t's already visible in the development docs for pg19: https://www.postgresql.org/docs/devel/docguide-docbook.html -- Álvaro HerreraBreisgau, Deutschland — https://www.EnterpriseDB.com/ "Doing what he did amounts to sticking his fingers under the hood of the implementation; if he gets his fingers burnt, it's his problem." (Tom Lane)

Re: further clarification: alter table alter column set not null - table scan is skipped

2025-08-04 Thread Álvaro Herrera
27;s suggested wording. Thank you all! -- Álvaro HerreraBreisgau, Deutschland — https://www.EnterpriseDB.com/

Re: Lets prohibit predicting the future in the documentation.

2025-08-04 Thread Álvaro Herrera
developers who may choose to try and remove such limitations. You could add a bullet point to the TODO page in the wiki to complement it, but I don't think you would remove the doc paragraph while it at; instead it'd probably remain redundant until we actually implemented extended stats on joins, and then we'd remove both. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/

Re: further clarification: alter table alter column set not null - table scan is skipped

2025-07-31 Thread Álvaro Herrera
VALID instead of using a separate CHECK constraint. Not sure if this reads better: if a valid CHECK constraint is found (and is not dropped in the same command) which proves no NULL can exist, then -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.c

Re: Missing word

2025-05-15 Thread Álvaro Herrera
ned table but retain access to it as a table in its own > > right. > > AFAICS, it's correct as written. Yeah, but maybe it would be clearer if the word "remove" were "detach". I don't find the phrase "remove the partition from the partitioned tab

Re: Regarding experiencing

2025-02-11 Thread Álvaro Herrera
e exclusive lock in another psql session and you should see it block. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/

Re: Regarding experiencing

2025-02-11 Thread Álvaro Herrera
ts. However, I would instead suggest to copy and paste text from terminal window(s), rather than screenshots. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/

Re: timestamp with time zone ~> GMT

2025-02-03 Thread Álvaro Herrera
n storing a 2-byte zone identifier as the timestampandtz extension does. -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/ Voy a acabar con todos los humanos / con los humanos yo acabaré voy a acabar con todos (bis) / con todos los humanos acabaré ¡acabaré! (Bender)

Re: ALTER INDEX documentation is incomplete

2024-10-19 Thread Álvaro Herrera
on test.datadog1_a_idx; -- ALTER INDEX How about the attached patch? Regards -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/ "I dream about dreams about dreams", sang the nightingale under the pale moon (Sandman) diff --git a/doc/src/sgml/ref/

Re: initdb username doc bug

2024-01-10 Thread Álvaro Herrera
d. Thank you! It looks good to me too. Sorry I got a bit too late to this thread. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ “Cuando no hay humildad las personas se degradan” (A. Christie)