Re: query, probably needs window functions

2020-05-23 Thread Scott Ribe
> On May 22, 2020, at 1:37 PM, Michael Lewis wrote: > > I believe something like this is what you want. You might be able to do it > without a sub-query by comparing the current name value to the lag value and > null it out if it's the same. > ... Thanks, that's what I needed! (And better than

Re: libgeotiff missing

2020-05-23 Thread Richard Suematsu
On 5/23/20 1:08 AM, Richard Suematsu wrote: > Hi, Trying to update postgis24_10 on centos6 but it fails on a > libgeotiff dependency. On another machine, it looks like libgeotiff > comes from @pgdg11, but I don't see it there anymore. I suspect this: https://yum.postgresql.org/news-newreporpms

Re: libgeotiff missing

2020-05-23 Thread Adrian Klaver
On 5/23/20 1:08 AM, Richard Suematsu wrote: Hi,  Trying to update postgis24_10 on centos6 but it fails on a libgeotiff dependency.  On another machine, it looks like libgeotiff comes from @pgdg11, but I don't see it there anymore. I suspect this: https://yum.postgresql.org/news-newreporpmsrel

Re: Table partitioning for cloud service?

2020-05-23 Thread Edson Richter
-- Mensagem original-- De: Ravi Krishna Data: qui, 21 de mai de 2020 18:50 Para: Cc:PostgreSQL Mailing Lists; Assunto:Re: Table partitioning for cloud service? > > The database/schema per tenant solution can be tedious when you want to > modify something on the structure and you have n

Re: Regarding creation of gin index on column that has varchar datatype

2020-05-23 Thread Durgamahesh Manne
On Sat, May 23, 2020 at 6:50 PM Andreas Kretschmer wrote: > > > Am 23.05.20 um 12:37 schrieb Durgamahesh Manne: > > Hi > > > > Respected to PGDG GLOBAL TEAM > > > > I am getting this error( ERROR: data type character varying has no > > default operator class for access method "gin" > > HINT: Yo

Re: Regarding creation of gin index on column that has varchar datatype

2020-05-23 Thread Andreas Kretschmer
Am 23.05.20 um 12:37 schrieb Durgamahesh Manne: Hi Respected to PGDG GLOBAL TEAM I am getting this error( ERROR:  data type character varying has no default operator class for access method "gin" HINT:  You must specify an operator class for the index or define a default operator class for

Regarding creation of gin index on column that has varchar datatype

2020-05-23 Thread Durgamahesh Manne
Hi Respected to PGDG GLOBAL TEAM I am getting this error( ERROR: data type character varying has no default operator class for access method "gin" HINT: You must specify an operator class for the index or define a default operator class for the data type ) while i try to create gin index on vch

libgeotiff missing

2020-05-23 Thread Richard Suematsu
Hi, Trying to update postgis24_10 on centos6 but it fails on a libgeotiff dependency. On another machine, it looks like libgeotiff comes from @pgdg11, but I don't see it there anymore. sudo yum install postgis24_10 Loaded plugins: amazon-id, search-disabled-repos, security Setting up Install P