PostgreSQL Asian language support for full text search using ICU (and also updating pg_trgm)

2019-04-30 Thread Chanon Sajjamanochai
Hello, Currently PostgreSQL doesn't support full text search natively for many Asian languages such as Chinese, Japanese and others. These languages are used by a large portion of the population of the world. The two key modules that could be modified to support Asian languages are the full text

Re: ERROR: operator does not exist: timestamp without time zone + integer

2019-04-30 Thread Adrian Klaver
On 4/30/19 12:11 PM, Andrew Gierth wrote: "Adrian" == Adrian Klaver writes: >> yeesh. that's a very long-winded way to write current_date + 7 Adrian> Yeah, I was just working of the OP's original DEFAULT: Adrian> site_mode_date timestamp NOT NULL DEFAULT date_trunc('day', Adrian> LOC

Re: ERROR: operator does not exist: timestamp without time zone + integer

2019-04-30 Thread Andrew Gierth
> "Adrian" == Adrian Klaver writes: >> yeesh. that's a very long-winded way to write current_date + 7 Adrian> Yeah, I was just working of the OP's original DEFAULT: Adrian> site_mode_date timestamp NOT NULL DEFAULT date_trunc('day', Adrian> LOCALTIMESTAMP)+7, Right, but since all these

Re: ERROR: operator does not exist: timestamp without time zone + integer

2019-04-30 Thread Adrian Klaver
On 4/30/19 8:00 AM, Andrew Gierth wrote: "Adrian" == Adrian Klaver writes: Adrian> Or cast to a date: Adrian> test=> select date_trunc('day', localtimestamp)::date + 7; yeesh. that's a very long-winded way to write current_date + 7 Yeah, I was just working of the OP's original DEFAULT

Re: Amazon Linux Support?

2019-04-30 Thread Adrian Klaver
On 4/30/19 8:40 AM, Michael Nolan wrote: Updated by Devrim Gündüz 4 days ago " Hi, We dropped Amazon Linux support years ago, there were lots of compatibility issues. The new repo RPMs just reflect that. Please switch to a supported distro, or rebuild RPMs from SRPMS.

Re: ERROR: operator does not exist: timestamp without time zone + integer

2019-04-30 Thread Ray O'Donnell
On 30/04/2019 16:00, Andrew Gierth wrote: "Adrian" == Adrian Klaver writes: Adrian> Or cast to a date: Adrian> test=> select date_trunc('day', localtimestamp)::date + 7; yeesh. that's a very long-winded way to write current_date + 7 Well, current_date is different: current_date returns

Re: ERROR: operator does not exist: timestamp without time zone + integer

2019-04-30 Thread Andrew Gierth
> "Adrian" == Adrian Klaver writes: Adrian> Or cast to a date: Adrian> test=> select date_trunc('day', localtimestamp)::date + 7; yeesh. that's a very long-winded way to write current_date + 7 -- Andrew (irc:RhodiumToad)

Re: Amazon Linux Support?

2019-04-30 Thread Adrian Klaver
On 4/30/19 2:02 AM, Lewis Shobbrook wrote: Hi Guys, With the repo changes associated with the April 17 changes, https://pgstef.github.io/2019/04/17/one_rpm_to_rule_them_all.html It is evident that support for amazon linux has been dropped. While you can try to use redhat pgdp packages, they are

Re: ERROR: operator does not exist: timestamp without time zone + integer

2019-04-30 Thread Adrian Klaver
On 4/30/19 2:24 AM, Thomas Kellerer wrote: Daulat Ram schrieb am 30.04.2019 um 05:46: We are getting an ERROR: “operator does not exist: timestamp without time zone + integer “ while creating table in postgres. The same script is working fine in Oracle, I know there are some changes in postgres

Re: ERROR: operator does not exist: timestamp without time zone + integer

2019-04-30 Thread Thomas Kellerer
Daulat Ram schrieb am 30.04.2019 um 05:46: > We are getting an ERROR: “operator does not exist: timestamp without > time zone + integer “ while creating table in postgres. The same > script is working fine in Oracle, I know there are some changes in > postgres but I am unable to identify . Please

Amazon Linux Support?

2019-04-30 Thread Lewis Shobbrook
Hi Guys, With the repo changes associated with the April 17 changes, https://pgstef.github.io/2019/04/17/one_rpm_to_rule_them_all.html It is evident that support for amazon linux has been dropped. While you can try to use redhat pgdp packages, they are not installable on Amazon Linux, giving the f

ERROR: operator does not exist: timestamp without time zone + integer

2019-04-30 Thread Daulat Ram
Hi team, We are getting an ERROR: "operator does not exist: timestamp without time zone + integer " while creating table in postgres. The same script is working fine in Oracle, I know there are some changes in postgres but I am unable to identify . Please suggest how we can create it successfu