Re: Possible bug: SQL function parameter in window frame definition

> "Tom" == Tom Lane writes: Tom> However, we need to fix this in all active branches, and I Tom> definitely agree with minimizing the amount of change to back Tom> branches. The fact that the minimal change breaks (or exposes an Tom> oversight in) assign_collations_walker makes it very pl

Re: Phone number type extension

On 28.09.19 11:11, stan wrote: Is there any currently supported version of this? I found one using google, but it looks like it was last updated around version 8 of Postgres. Found this: https://github.com/blm768/pg-libphonenumber Might be used in a CHECK constraint to validate phone numbers

Re: Possible bug: SQL function parameter in window frame definition

Andrew Gierth writes: > "Tom" == Tom Lane writes: > Tom> Now probably this is never called on utility statements, and maybe > Tom> there is never a reason for anyone to examine or mutate > Tom> SortGroupClauses, GroupingSets, or RowMarkClauses, but I'm not > Tom> sure it's any business of thi

Re: "Failed to connect to Postgres database"

On 9/28/19 12:07 AM, Marco Ippolito wrote: Hi Adrian, Il giorno ven 27 set 2019 alle ore 21:39 Adrian Klaver mailto:adrian.kla...@aklaver.com>> ha scritto: On 9/27/19 11:02 AM, Marco Ippolito wrote: > Thank you very much Adrian. > Two things: > > 1) >   Why if I j

Re: Possible bug: SQL function parameter in window frame definition

> "Tom" == Tom Lane writes: Tom> It looks to me that the reason is that query_tree_mutator Tom> (likewise query_tree_walker) fails to visit query->windowClause, I noticed this too. I spent some time looking at what might break if that was changed (found two places so far, see attached draf

Re: Possible bug: SQL function parameter in window frame definition

Andrew Gierth writes: > "Alastair" == Alastair McKinley writes: > Alastair> This appears to be a bug to me. > Yes, it's a bug, related to function inlining (the select f(3); is not > inlined and therefore works, but the select * from f(3); is being > inlined, but the original Param is somehow m

Re: JSONB maximal length ?

so 28. 9. 2019 v 18:35 odesílatel ROS Didier napsal: > Hi Pavel > > > >I don’t know what is the value 255MB ? > > all I know is that I want to insert large pdf documents. I am prevented > because of this limit. > It's pretty long pdf :) Maybe you are hit some bug. Postgres JSON, JSONB, XM

RE: JSONB maximal length ?

Hi Pavel I don’t know what is the value 255MB ? all I know is that I want to insert large pdf documents. I am prevented because of this limit. Best Regards Didier ROS EDF De : pavel.steh...@gmail.com [mailto:pavel.steh...@gmail.com] Envoyé : samedi 28 septembre 2019 18:26 À : ROS Didier Cc

Re: JSONB maximal length ?

so 28. 9. 2019 v 18:12 odesílatel ROS Didier napsal: > Hi > >By inserting data in a JSONB type column I got the following error > message: > > *>> * > > *ERROR: string too long to represent as jsonb string* > > *DETAIL: Due to an implementation restriction, jsonb strings cannot > exceed 268

JSONB maximal length ?

Hi By inserting data in a JSONB type column I got the following error message: >> ERROR: string too long to represent as jsonb string DETAIL: Due to an implementation restriction, jsonb strings cannot exceed 268435455 bytes. << could anyone confirm that there is a size limit for JSONB type fi

Re: Possible bug: SQL function parameter in window frame definition

> "Alastair" == Alastair McKinley writes: Alastair> Hi all, Alastair> I noticed this strange behaviour whilst trying to write a Alastair> function for Postgres 11.5 (PostgreSQL 11.5 on Alastair> x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 Alastair> (Red Hat 4.8.5-36), 64-b

Possible bug: SQL function parameter in window frame definition

Hi all, I noticed this strange behaviour whilst trying to write a function for Postgres 11.5 (PostgreSQL 11.5 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit) and reduced it to this minimal example. Using a function parameter in the window frame definiti

Re: Pg_auto_failover

Thanks Paul, I am able to set up. Does pg_auto_failover only works on v10 and v11. I am having 9.5 on production. On Wed, Sep 25, 2019, 11:40 PM Paul Jungwirth wrote: > On 9/25/19 8:55 AM, Sonam Sharma wrote: > > My user has permission to touch inside the Fs. > > I am not getting why it is check

Re: Phone number type extension

On 28/09/2019 11:13, Morris de Oryx wrote: For clarification, what do you mean by "phone number"? I'm not being dense, I'm wondering if you're looking for a type that handles only numbers from one country, or that can deal with the rules for a variety of countries. That was my first thought a

Re: Phone number type extension

For clarification, what do you mean by "phone number"? I'm not being dense, I'm wondering if you're looking for a type that handles only numbers from one country, or that can deal with the rules for a variety of countries.

Phone number type extension

Is there any currently supported version of this? I found one using google, but it looks like it was last updated around version 8 of Postgres. -- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety."

Re: "Failed to connect to Postgres database"

Hi Adrian, Il giorno ven 27 set 2019 alle ore 21:39 Adrian Klaver < adrian.kla...@aklaver.com> ha scritto: > On 9/27/19 11:02 AM, Marco Ippolito wrote: > > Thank you very much Adrian. > > Two things: > > > > 1) > > Why if I just specify through port the cluster and the host connection > > I con