RE: [DOC] pg_stat_prefetch_recovery representation style inconsisitant

2021-04-29 Thread tanghy.f...@fujitsu.com
Sorry, wrong title name. I fixed the view representation of "pg_stat_prefetch_recovery". Fix it. Regards, Tang

RE: [DOC] pg_stat_replication_slots representation style inconsisitant

2021-04-29 Thread tanghy.f...@fujitsu.com
On Friday, April 30, 2021 12:38 PM, Hou, Zhijie/侯 志杰 wrote >I noticed one more thing. >It seems the column " stats_reset | timestamp with time zone " is not >listed in the pg_stat_prefetch_recovery view. >Should we add this column too ? Indeed, column added. Thanks. Regards, Tang 0001-p

RE: [DOC] pg_stat_replication_slots representation style inconsisitant

2021-04-29 Thread houzj.f...@fujitsu.com
> When reading the manual doc, I found an inconsistent representation style for > the newly added pg_stat_prefetch_recovery view in PG14 at [1]. > Same problem seems to be reported by Noriyoshi Shinoda who also proposed > a patch to fix the problem at[2]. > I tried to fix the problem in a way diffe

[DOC] pg_stat_replication_slots representation style inconsisitant

2021-04-29 Thread tanghy.f...@fujitsu.com
Hi When reading the manual doc, I found an inconsistent representation style for the newly added pg_stat_prefetch_recovery view in PG14 at [1]. Same problem seems to be reported by Noriyoshi Shinoda who also proposed a patch to fix the problem at[2]. I tried to fix the problem in a way differen

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

2021-04-29 Thread Tom Lane
PG Doc comments form writes: > In Section 5.4.5 of the documentation regarding Foreign Key Constraints it > is stated > "A foreign key constraint specifies that the values [...] must match the > values appearing in some row of another table." > But referencing the same table is allowed and necessa

Re: pl/pgsql errors when multi-dimensional arrays are used

2021-04-29 Thread Tom Lane
PG Doc comments form writes: > I have PostgreSQL 13. Let's declare the type below, then use it in > pl/pgsql: > create type typ1 as ( > fld1 int[][] > ); I think you have a fundamental misunderstanding of how multidimensional arrays work in Postgres. There's no separate type for 2-D vs 1-

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

2021-04-29 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/ddl-constraints.html Description: Hello, In Section 5.4.5 of the documentation regarding Foreign Key Constraints it is stated "A foreign key constraint specifies that the values [...] must

Re: pl/pgsql errors when multi-dimensional arrays are used

2021-04-29 Thread Pavel Stehule
Hi čt 29. 4. 2021 v 12:33 odesílatel Rafal Dabrowa napsal: > This also returns ERROR: invalid input syntax for type integer: > "[221,222,223,224]" > > On 4/29/2021 9:48 AM, KraSer wrote: > > try: > > a.fld1[1] = '[221,222,223,224]'; > > > > чт, 29 апр. 2021 г. в 10:35, PG Doc comments form > >

Re: pl/pgsql errors when multi-dimensional arrays are used

2021-04-29 Thread Rafal Dabrowa
This also returns ERROR:  invalid input syntax for type integer: "[221,222,223,224]" On 4/29/2021 9:48 AM, KraSer wrote: try: a.fld1[1] = '[221,222,223,224]'; чт, 29 апр. 2021 г. в 10:35, PG Doc comments form mailto:nore...@postgresql.org>>: The following documentation comment has been

Re: pl/pgsql errors when multi-dimensional arrays are used

2021-04-29 Thread KraSer
try: a.fld1[1] = '[221,222,223,224]'; чт, 29 апр. 2021 г. в 10:35, PG Doc comments form : > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/arrays.html > Description: > > I have PostgreSQL 13. Let's declare the type below, then use

pl/pgsql errors when multi-dimensional arrays are used

2021-04-29 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/arrays.html Description: I have PostgreSQL 13. Let's declare the type below, then use it in pl/pgsql: create type typ1 as ( fld1 int[][] ); do $$ declare a typ