case insensitive collation of Greek's sigma

Hello, during our tests of Postgres with ICU we found an issue with ILIKE of upper and lowercase sigma (Σ). The letter has two lowercase variants σ and ς (at the end of a word). I'm working with en_US and en-US-x-icu collations and results are a bit unexpected - they are inverted: postgres=# SELE

Re: Best examples of cardinality check and associated functions

On Thu, Nov 25, 2021, 16:17 Shaozhong SHI wrote: > Hi, Rob, > > I am reviewing robust automation to do so and promote the best practice. > > Maybe show what you've come up with so far, regardless of whether it's best practice or not, so to help overcome the apparent communication barrier. David

Re: Best examples of cardinality check and associated functions

> On Nov 25, 2021, at 4:17 PM, Shaozhong SHI wrote: > >  > Hi, Rob, > > I am reviewing robust automation to do so and promote the best practice. Sorry I still don’t know what you’re after. Relationship cardinality, schema diagrams? > > Regards, > David > D > >> On Thu, 25 Nov 2021 at 22:

Re: Best examples of cardinality check and associated functions

Hi, Rob, I am reviewing robust automation to do so and promote the best practice. Regards, David D On Thu, 25 Nov 2021 at 22:24, Rob Sargent wrote: > > > > On Nov 25, 2021, at 3:16 PM, Shaozhong SHI > wrote: > > > >  > > I wonder whether the Postgres community has got the best examples of >

Re: Best examples of cardinality check and associated functions

> On Nov 25, 2021, at 3:16 PM, Shaozhong SHI wrote: > >  > I wonder whether the Postgres community has got the best examples of > cardinality check and associated functions. > Are you looking for examples or opinions on the examples? > Regards, > > David

Best examples of cardinality check and associated functions

I wonder whether the Postgres community has got the best examples of cardinality check and associated functions. Regards, David

Re: As a Linux distro, how to package multiple postgres major versions?

Hello, Which distribution are you speaking about ? I'm using Gentoo and postgresql is versioned : you install the versions you're looking for and switch form one to another using eselect laurent@torchwood ~ $ eselect postgresql list Available PostgreSQL Slots   11    11.7   12

Re: As a Linux distro, how to package multiple postgres major versions?

On 11/25/21 10:43 AM, Chocimier wrote: Hi, How to provide Postgres for a binary rolling release Linux distribution? Currently 9.6, 12 and 13 major versions are packaged in Void by me in way described below. No one reported practical problems with that, but some concerns arised, mainly around sha

Re: function difference not found

2021-11-25 13:12 GMT-03:00, Shaozhong SHI : > Function difference not found. > > Should an extension created for finding it? > Perhaps you are talking about EXCEPT set operator? https://www.postgresql.org/docs/current/queries-union.html

Re: function difference not found

On Thu, Nov 25, 2021 at 9:13 AM Shaozhong SHI wrote: > Function difference not found. > > Should an extension created for finding it? > > It's an operator (there may be a backing function that isn't documented)... SELECT 5 - 2; -- yields 3, the difference of 5 and 2. David J.

As a Linux distro, how to package multiple postgres major versions?

Hi, How to provide Postgres for a binary rolling release Linux distribution? Currently 9.6, 12 and 13 major versions are packaged in Void by me in way described below. No one reported practical problems with that, but some concerns arised, mainly around shared libraries. Constraints: - Want to a

Re: function difference not found

On 25/11/21 6:12 μ.μ., Shaozhong SHI wrote: Function difference not found. Should an extension created for finding it? fuzzystrmatch Regards, David -- Achilleas Mantzios DBA, Analyst, IT Lead IT DEPT Dynacom Tankers Mgmt

Re: function difference not found

On 11/25/21 08:12, Shaozhong SHI wrote: Function difference not found. This means what? Should an extension created for finding it? Finding what? Questions without substance will not get answers. Regards, David -- Adrian Klaver adrian.kla...@aklaver.com

function difference not found

Function difference not found. Should an extension created for finding it? Regards, David

Re: ANALYZE, pg_class.xmin && pg_class.reltuples

Luca Ferrari writes: > I've a doubt about running ANALYZE and inspecting pg_class.xmin and > pg_class.reltuples. > ... > So the pg_class record has changed its content, and in fact we are now > 2 transaction away the table creation, but the pg_class.xmin is the > same. ANALYZE (and VACUUM) update

Re: Error message while trying to connect from PGAdmin 4

Corrupt windows user was the reason that we found.    When tried from other windows users, it's working.  So switched to a new windows user and everything seems perfect.Thanks. On Thursday, 25 November, 2021, 11:11:56 am IST, sivapostg...@yahoo.com wrote: Hello PostgreSQL 11.11,  PGA

ANALYZE, pg_class.xmin && pg_class.reltuples

Hi all, I've a doubt about running ANALYZE and inspecting pg_class.xmin and pg_class.reltuples. Let's create a simple table (note, I'm the only user on this instance): testdb=> CREATE TABLE fizz AS SELECT v FROM generate_series( 1, 100 ) v; SELECT 100 testdb=> SELECT relpages, reltuples, xmin, age