Re: Even if I have a lot of free space PgSQL returns "ERROR: could not extend file - No space left on device"

2023-09-09 Thread Alban Hertroys
> On 8 Sep 2023, at 13:25, Nature Conservation Geovista Space > wrote: > > Dear Pg-users, > I am coming back to Postgres/PostGIS after a few years. I am dealing with a > big database with a lot of geometries and too many vertices. So a lot of geometry going on then… That seems important in

Re: postgreSQL UPPER Method is converting the character "µ" into "M"

2023-09-09 Thread Peter J. Holzer
On 2023-09-06 22:39:42 +0530, Sai Teja wrote: > This column has many sentences for each row in which some of the > characters are in Greek language. > Like µ, ë, ä, Ä etc.. Except for the µ[1], those ̣aren't Greek letters. hp [1] and even that's debatable, since it's a micro sign, not a

Re: postgreSQL UPPER Method is converting the character "µ" into "M"

2023-09-09 Thread Peter J. Holzer
On 2023-09-06 17:29:21 +0200, Francisco Olarte wrote: > On Wed, 6 Sept 2023 at 16:40, Sai Teja > wrote: > > Actually we are migrating the data from DB2 to postgreSQL. So in DB2 > > the upper method is converting µ as µ only but not as M. > > So, while validating the data we have encountered this