Re: porting horde to Postgresql 12, dropped pg_attrdef

2019-11-18 Thread Laurenz Albe
On Mon, 2019-11-18 at 01:29 +0100, Ivan Sergio Borgonovo wrote: > On 11/15/19 4:16 PM, Tom Lane wrote: > > Ivan Sergio Borgonovo writes: > > > Horde (webmail and more) is not anymore compatible with postgresql 12 > > > after pg_attrdef was dropped. > > > > We didn't drop the whole catalog, just t

Re: porting horde to Postgresql 12, dropped pg_attrdef

2019-11-17 Thread Ivan Sergio Borgonovo
On 11/15/19 4:16 PM, Tom Lane wrote: Ivan Sergio Borgonovo writes: Horde (webmail and more) is not anymore compatible with postgresql 12 after pg_attrdef was dropped. We didn't drop the whole catalog, just the adsrc column, which has been deprecated for ages (because it didn't update to track

Re: porting horde to Postgresql 12, dropped pg_attrdef

2019-11-15 Thread Tom Lane
Ivan Sergio Borgonovo writes: > Horde (webmail and more) is not anymore compatible with postgresql 12 > after pg_attrdef was dropped. We didn't drop the whole catalog, just the adsrc column, which has been deprecated for ages (because it didn't update to track, eg, column renamings). The correc

porting horde to Postgresql 12, dropped pg_attrdef

2019-11-15 Thread Ivan Sergio Borgonovo
Horde (webmail and more) is not anymore compatible with postgresql 12 after pg_attrdef was dropped. Since I'm a Horde user and I've always liked PostgreSQL I'm trying to update these queries 1) SELECT attr.attname, CASE WHEN split_part(def.adsrc, , 2) ~ '.' THEN substr(spl