Re: generated constraint name

2025-04-29 Thread Peter Eisentraut
On 24.04.25 17:13, Robert Treat wrote: On Fri, Apr 11, 2025 at 8:45 AM Euler Taveira wrote: On Fri, Apr 11, 2025, at 5:32 AM, Yaroslav Saburov wrote: On the tutorial-agg page in the code example SELECT city FROM weather WHERE temp_lo = max(temp_lo); WRONG you need to add a comment before WRON

Re: generated constraint name

2025-04-24 Thread Robert Treat
On Fri, Apr 11, 2025 at 8:45 AM Euler Taveira wrote: > On Fri, Apr 11, 2025, at 5:32 AM, Yaroslav Saburov wrote: > On the tutorial-agg page in the code example > > SELECT city FROM weather WHERE temp_lo = max(temp_lo); WRONG > > you need to add a comment before WRONG > > If you consider that that

Re: generated constraint name

2025-04-11 Thread Euler Taveira
On Fri, Apr 11, 2025, at 5:32 AM, Yaroslav Saburov wrote: > > Thank you all. > > > > In order not to open a new thread, (small clarification) > Don't be afraid to open a new thread. Indeed, a new topic (even if it is minimal) deserves a new thread. > On the tutorial-agg page in the code exam

Re: generated constraint name

2025-04-11 Thread Yaroslav Saburov
Thank you all. In order not to open a new thread, (small clarification) On the tutorial-agg page in the code example SELECT city FROM weather WHERE temp_lo = max(temp_lo); WRONG you need to add a comment before WRONG > 10 квіт. 2025 р. о 18:13 Tom Lane пише: > > Peter Eisentraut writes: >>

Re: generated constraint name

2025-04-10 Thread Tom Lane
Peter Eisentraut writes: > On 07.04.25 15:34, David G. Johnston wrote: >> I feel like that whole parenthetical should just go away. The point of >> the comment is to remind the user of how identifier values work with >> respect to mandatory double quoting. The name itself, other than having >

Re: generated constraint name

2025-04-10 Thread Peter Eisentraut
On 07.04.25 15:34, David G. Johnston wrote: On Sunday, April 6, 2025, PG Doc comments form > wrote: The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/ddl-alter.html Description: url:

Re: generated constraint name

2025-04-08 Thread Yaroslav Saburov
You do not provide the output of the table description, but write that the system generated the name $2 > 7 квіт. 2025 р. о 16:34 David G. Johnston пише: > > On Sunday, April 6, 2025, PG Doc comments form > wrote: >> The following documentation comment has been logged on the website: >> >>

Re: generated constraint name

2025-04-07 Thread David G. Johnston
On Sunday, April 6, 2025, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/17/ddl-alter.html > Description: > > url: > https://www.postgresql.org/docs/current/ddl-alter.html# > DDL-ALTER-REMOVING-A-CONSTRAI