Re: Counting the number of repeated phrases in a column

2022-02-01 Thread Karsten Hilbert
Am Tue, Feb 01, 2022 at 11:29:50PM + schrieb Shaozhong SHI: > How about knock unique words into discrete joint up strings? Then check > whether there is any repeated words? Does it work when you try ? Karsten -- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B

Re: Two academic questions

2022-02-01 Thread Дмитрий Иванов
Thank you, I learned everything I needed to know. -- Regards, Dmitry! ср, 2 февр. 2022 г. в 11:36, David G. Johnston : > > > On Tuesday, February 1, 2022, Дмитрий Иванов > wrote: > >> DEFAULT VALUE <> GENERATED ALWAYS AS STORED the DEFAULT value is not recalculated when the refer

Re: Two academic questions

2022-02-01 Thread David G. Johnston
On Tuesday, February 1, 2022, Дмитрий Иванов wrote: > >>> >>> DEFAULT VALUE <> GENERATED ALWAYS AS STORED >>> the DEFAULT value is not recalculated when the reference column are >>> changed. is not an identical construction GENERATED ALWAYS AS STORED >>> >>> *reply:* >>> They are in a separate li

Re: Two academic questions

2022-02-01 Thread Дмитрий Иванов
> > >> >> DEFAULT VALUE <> GENERATED ALWAYS AS STORED >> the DEFAULT value is not recalculated when the reference column are >> changed. is not an identical construction GENERATED ALWAYS AS STORED >> >> *reply:* >> They are in a separate list “Methods”. >> This approach was used for other databases

Re: Two academic questions

2022-02-01 Thread David G. Johnston
On Tuesday, February 1, 2022, Дмитрий Иванов wrote: > ср, 2 февр. 2022 г. в 09:19, David G. Johnston >: > >> On Tue, Feb 1, 2022 at 8:15 PM Дмитрий Иванов >> wrote: >> >>> Why are COLUMN GENERATED ALWAYS AS called "methods" and singled out as a >>> separate field type? >>> >> >> This sounds lik

Re: Two academic questions

2022-02-01 Thread Дмитрий Иванов
ср, 2 февр. 2022 г. в 09:19, David G. Johnston : > On Tue, Feb 1, 2022 at 8:15 PM Дмитрий Иванов > wrote: > >> Why are COLUMN GENERATED ALWAYS AS called "methods" and singled out as a >> separate field type? >> > > This sounds like you are describing something written. Can you provide a > link t

Re: Subscription stuck at initialize state

2022-02-01 Thread Abhishek Bhola
The only statement I see on the target DB log is "logical replication apply worker for subscription ""sub_omx_archive_tci"" has started","" I don't see the logical replication table synchronization worker started for any of the tables in this subscription as I see in the other one. Is the

Re: Two academic questions

2022-02-01 Thread David G. Johnston
On Tue, Feb 1, 2022 at 8:15 PM Дмитрий Иванов wrote: > Why are COLUMN GENERATED ALWAYS AS called "methods" and singled out as a > separate field type? > This sounds like you are describing something written. Can you provide a link to where that is? Is there a common name in the community for t

Two academic questions

2022-02-01 Thread Дмитрий Иванов
Good afternoon. There are a couple of questions that I come back to from time to time: Why are COLUMN GENERATED ALWAYS AS called "methods" and singled out as a separate field type? Is there a common name in the community for the approach in which the data schema is presented as data? -- Regards, Dm

Re: Subscription stuck at initialize state

2022-02-01 Thread Steve Baldwin
Hi Abishek, Have you checked the subscriber and publisher database log files to see if there is a problem blocking the subscription? For example, a subscribed table missing a column that exists in the publisher. Cheers, Steve On Wed, Feb 2, 2022 at 1:26 PM Abhishek Bhola < abhishek.bh...@japann

Subscription stuck at initialize state

2022-02-01 Thread Abhishek Bhola
I have 2 sets of publication/subscription between my 2 DBs. One of them is working fine and the other one is stuck at initializing state for all the tables. sourcedb=# select * from pg_publication; oid |pubname | pubowner | puballtables | pubinsert | pubupdate | pubdelete | pubt

Re: Counting the number of repeated phrases in a column

2022-02-01 Thread Shaozhong SHI
On Tue, 25 Jan 2022 at 17:10, Shaozhong SHI wrote: > There is a short of a function in the standard Postgres to do the > following: > > It is easy to count the number of occurrence of words, but it is rather > difficult to count the number of occurrence of phrases. > > For instance: > > A cell of

Re: Counting the number of repeated phrases in a column

2022-02-01 Thread Shaozhong SHI
On Thursday, 27 January 2022, Merlin Moncure wrote: > On Wed, Jan 26, 2022 at 5:23 PM Merlin Moncure wrote: > > > > with s as (select 'Hello World Hello World' as sentence) > > select > > phrase, > > array_upper(string_to_array((select sentence from s), phrase), 1) - > > 1 as occurrances > >

Re: Extension has owner

2022-02-01 Thread Tom Lane
=?iso-8859-1?Q?F=E4rber=2C_Franz-Josef_=28StMUK=29?= writes: > I discovered that extensions have owners (pg_extension.extowner). Yup. > This seems to be badly supported: > · postgres does not seem to have support for something like ALTER > EXTERNSION OWNER TO ... > · pg_du

Extension has owner

2022-02-01 Thread StMUK
Hello, I discovered that extensions have owners (pg_extension.extowner). The pgadmin4 schema diff ... well er, kind of tried to report to me that the owners differ (https://redmine.postgresql.org/issues/7145). This seems to be badly supported: · postgres does not seem to have support f