Re: I get ERROR: column "table_name" does not exist

On 2024-06-04 21:50 +0200, PG Doc comments form wrote: > When using GET STACKED DIAGNOSTICS in PL/pgSQL accessing TABLE_NAME, > COLUMN_NAME, CONSTRAINT_NAME or SCHEMA_NAME throws an error. > > The function "shared.test_raise_exception": > https://github.com/rin-nas/postgresql-patterns-library/issu

Re: Need clarification on "field"

On Wed, Jun 5, 2024 at 12:15:45PM +0200, Laurenz Albe wrote: > On Tue, 2024-06-04 at 19:54 +, PG Doc comments form wrote: > > Under page "https://www.postgresql.org/docs/current/limits.html";, below > > limitations are mentioned: > > > > field size - 1 GB > > identifier length - 63 bytes > >

Re: Need clarification on "field"

On Tue, 2024-06-04 at 19:54 +, PG Doc comments form wrote: > Under page "https://www.postgresql.org/docs/current/limits.html";, below > limitations are mentioned: > > field size - 1 GB > identifier length - 63 bytes > > I understand "identifier" as the name we provide for tables, columns etc.

Re: Minor accuracy issue

On Wed, 5 Jun 2024 at 20:23, PG Doc comments form wrote: > Under page "https://www.postgresql.org/docs/current/limits.html";, it is > mentioned: > > relation size - 32TB > rows per table - limited by the number of tuples that can fit onto > 4,294,967,295 pages > > > 32 TB is 35,184,372,088,832 byt

Need clarification on "field"

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/limits.html Description: Under page "https://www.postgresql.org/docs/current/limits.html";, below limitations are mentioned: field size - 1 GB identifier length - 63 bytes I understand "

I get ERROR: column "table_name" does not exist

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/plpgsql-control-structures.html Description: When using GET STACKED DIAGNOSTICS in PL/pgSQL accessing TABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME or SCHEMA_NAME throws an error. The function

Minor accuracy issue

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/limits.html Description: Under page "https://www.postgresql.org/docs/current/limits.html";, it is mentioned: relation size - 32TB rows per table - limited by the number of tuples that can