Re: Foreign Keys being able to reference same table not spelled out in documentation

2021-05-05 Thread David G. Johnston
On Thu, Apr 29, 2021 at 10:33 AM Tom Lane wrote: > I'm inclined to propose adding an example a little further down, as > per the attached draft patch. This wouldn't help people who stop > reading after the section's first sentence, but we can't cover > everything in the first sentence. > > Given

Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error

2021-05-05 Thread Federico
Thanks for the quick resolution. Best, Federico Ps: sorry for the previous messages in html, I had not realized that the client I was using were sending the replies like that. On Wed, 5 May 2021 at 17:28, Tom Lane wrote: > Laurenz Albe writes: > > On Tue, 2021-05-04 at 19:18 -0400, Tom Lane w

Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error

2021-05-05 Thread Tom Lane
Laurenz Albe writes: > On Tue, 2021-05-04 at 19:18 -0400, Tom Lane wrote: >> So what I was remembering was some text in the section about sequence >> functions. That probably seemed appropriate when they were the only >> real use of regclass; but these days we have regclass-accepting functions >>

Re: Update maintenance_work_mem/autovacuum_work_mem to reflect the 1GB limitation with VACUUM

2021-05-05 Thread Laurenz Albe
On Mon, 2021-05-03 at 13:48 -0300, Martín Marqués wrote: > We should add a line that indicates that there is a limitation (that > should be IMO, backported to documentation of earlier versions as it > affects all supported versions), at least until such limitation is > lifted. Here is a patch for

Re: Clarify how triggers relate to transactions

2021-05-05 Thread Laurenz Albe
On Wed, 2021-04-28 at 13:24 +0200, Laurenz Albe wrote: > On Tue, 2021-04-27 at 14:26 +, PG Doc comments form wrote: > > https://www.postgresql.org/docs/current/sql-createtrigger.html mentions the > > word "transaction" only once, in reference specifically to constraint > > triggers: "They can b

RE: BUG #16991: regclass is not case sensitive causing "relation does not exist" error

2021-05-05 Thread Federico Caselli
The patch is also clear for me, thanks for working on it. Best,Federico From: Laurenz AlbeSent: mercoledì 5 maggio 2021 09:32To: Tom Lane; FedericoCc: pgsql-docs@lists.postgresql.orgSubject: Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error On Tue, 2021-05-04 at

Re: BUG #16991: regclass is not case sensitive causing "relation does not exist" error

2021-05-05 Thread Laurenz Albe
On Tue, 2021-05-04 at 19:18 -0400, Tom Lane wrote: > [ redirecting to pgsql-docs list ] > > I wrote: > > Federico writes: > > > I did not come across that documented behavior while searching for > > > regclass > > > in the pg docs. The most relevant page I was able to find was the Object > > > I