Wrong note in the information schema section?

Hi %. we have this note in the information schema section, e.g. in https://www.postgresql.org/docs/current/information-schema.html ..."This is because the SQL standard requires constraint names to be unique within a schema, but PostgreSQL does not enforce this restriction." ... PostgreSQL does

Re: Wrong note in the information schema section?

On Mon, Aug 30, 2021 at 5:51 AM Daniel Westermann (DWE) < daniel.westerm...@dbi-services.com> wrote: > > we have this note in the information schema section, e.g. in > https://www.postgresql.org/docs/current/information-schema.html > > ..."This is because the SQL standard requires constraint names

Re: I came here to determine how much storage a boolean variable uses

On Sun, Aug 29, 2021 at 11:59 PM PG Doc comments form < nore...@postgresql.org> wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/datatype.html > Description: > > I'd like to see a fourth column added to Table 8-1 that contain

Re: I came here to determine how much storage a boolean variable uses

On 8/30/21 11:31 AM, David G. Johnston wrote: > On Sun, Aug 29, 2021 at 11:59 PM PG Doc comments form > mailto:nore...@postgresql.org>> wrote: > > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/datatype.html >

Re: Wrong note in the information schema section?

>>..."This is because the SQL standard requires constraint names to be unique >>within a schema, but PostgreSQL does not enforce this >>restriction." >>.. >>PostgreSQL does enforce unique constraint names in a schema: >>[...] >>... but I guess this is not what the notes is supposed to tell me, c

Wrong note in the information schema section?

On Monday, August 30, 2021, Daniel Westermann (DWE) wrote: > > >Practically speaking there must be some level of scope where a duplicate > name error can occur. All the docs say is that the schema >scope is not > it. You've demonstrated that it is the table scope where duplication of > names is

Re: Wrong note in the information schema section?

On Monday, August 30, 2021, David G. Johnston wrote: > On Monday, August 30, 2021, Daniel Westermann (DWE) < > daniel.westerm...@dbi-services.com> wrote: > >> >> >Practically speaking there must be some level of scope where a duplicate >> name error can occur. All the docs say is that the schema

Re: Wrong note in the information schema section?

On Tue, Aug 31, 2021 at 6:53 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Monday, August 30, 2021, David G. Johnston > wrote: > >> On Monday, August 30, 2021, Daniel Westermann (DWE) < >> daniel.westerm...@dbi-services.com> wrote: >> >>> >>> >Practically speaking there must be s

Re: Wrong note in the information schema section?

  On Monday, August 30, 2021, David G. Johnston wrote: On Monday, August 30, 2021, Daniel Westermann (DWE) wrote: >>>Practically speaking there must be some level of scope where a duplicate >>>name error can occur.  All the docs say is that the schema >>>scope is not >>>it.  You've demonstr

Re: Wrong note in the information schema section?

On Tue, Aug 31, 2021 at 7:43 AM Pantelis Theodosiou wrote: > > > On Tue, Aug 31, 2021 at 6:53 AM David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Monday, August 30, 2021, David G. Johnston >> wrote: >> >>> On Monday, August 30, 2021, Daniel Westermann (DWE) < >>> daniel.westerm..