Re: Relaxing NaN/Infinity restriction in JSON fields

Hi! On Mon, May 6, 2019 at 1:21 PM Tom Lane wrote: > Getting us to deviate from the RFC so blatantly would be a very hard sell. > A large part of the point of the JSON datatype is to be interoperable; > once you give that up you may as well use some not-standard-at-all > representation. Python s

Re: Amazon Linux Support?

> On Apr 30, 2019, at 07:16, Adrian Klaver wrote: > >> 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 be

Re: PG version recommendation

On Wed, 8 May 2019 at 07:19, Tim Cross wrote: > > I would find out if the IT team who will maintain the system are running > a specific Linux distribution, such as RHEL and just go with the PG > version that is on that distribution. > Bear in mind, depending on the OS, the default version availa

Re: PG version recommendation

No, I'm asking about the application. On 5/7/19 3:51 PM, David Gauthier wrote: >>Home-rolled application, or third party? Are you asking about how they do VMs ? They already provide PG v9.6.7 , so I gather they're not averse to supporting PG DBs. On Tue, May 7, 2019 at 4:05 PM Ron

Re: PG version recommendation

I would find out if the IT team who will maintain the system are running a specific Linux distribution, such as RHEL and just go with the PG version that is on that distribution. Large corp rarely have sufficient IT resources. Unless you specifically need a particular PG version (which does not

Re: PG version recommendation

>>Home-rolled application, or third party? Are you asking about how they do VMs ? They already provide PG v9.6.7 , so I gather they're not averse to supporting PG DBs. On Tue, May 7, 2019 at 4:05 PM Ron wrote: > On 5/7/19 1:52 PM, David Gauthier wrote: > > Hi: > > I'm going to be requesting a P

Re: PG version recommendation

On 5/7/19 1:52 PM, David Gauthier wrote: Hi: I'm going to be requesting a PG instance supported by an IT team in a large corp.  They will be creating the server as a VM.  We will be loading the DB using scripts (perl/dbi) on linux, possibly using bulk loading techniques if that's required.  Q

Re: Postgres for SQL Server users

I have not used SS for spatial data, but I don't have a Postgres database without Postgis installed. The OSGEO ecosystem and synergies with other FOSS GIS tools is fantastic. And it does not stop with the Postgis extension. For time series data (anything from fleet management to sensor data) Po

Re: PG version recommendation

David Gauthier schrieb am 07.05.2019 um 20:52: I need to pick a PG version in my request. I want something that will be stable and reliable while, of course, being able to perform well. What would be a good choice for PG version? There is no reason to not choose the latest version. So I would

Re: PG version recommendation

On 5/7/19 11:52 AM, David Gauthier wrote: Hi: I'm going to be requesting a PG instance supported by an IT team in a large corp.  They will be creating the server as a VM.  We will be loading the DB using scripts (perl/dbi) on linux, possibly using bulk loading techniques if that's required. 

PG version recommendation

Hi: I'm going to be requesting a PG instance supported by an IT team in a large corp. They will be creating the server as a VM. We will be loading the DB using scripts (perl/dbi) on linux, possibly using bulk loading techniques if that's required. Queries will come from both linux and the web,

Re: duplicate key value violates unique constraint "chinese_price_infos_pkey"

You can fix the problem with this query: SELECT setval('chinese_price_infos_id_seq', sq.val) from ( SELECT MAX(id) as val FROM chinese_price_infos ) sq; But you have to search in your application because in some point the app are inserting the id column instead of leave this task to the DB. If y

Re: random generated string matching index in inexplicable ways

On Tue, May 7, 2019 at 3:12 PM Myles Miller wrote: > No, the function is returning just one letter, either 'A' or 'B', not > multiple values. Your random function is being evaluated ONCE FOR EACH ROW. i.e, it's doing something like: select y from ( SELECT y, chr(round(random())::int + 65) as

Re: Postgres for SQL Server users

> Next month I'll be making a presentation about Postgres to a SQL > Server crowd in L.A. at their SQL Saturday event. > > I was wondering if anyone has any tips that are specific for SQL > Server users? Best features? Known issues? Common rebuttals? PosgreSQL is more than a "database", it's

Re: random generated string matching index in inexplicable ways

> > # SELECT y FROM x WHERE y = chr(round(random())::int + 65); > > y > > --- > > A > > B > > (2 rows) > Here you got a random value in the lower range of 0..1 for the record with > value ‘A’, so that’s a match, and one in the higher range for value ‘B’, a > match again, so you get 2 rows. No,

Re: random generated string matching index in inexplicable ways [EXT]

On Tue, May 07, 2019 at 12:17:12PM +, Daniel Perrett wrote: > The WHERE expression (and therefore the random function) is being evaluated > once per row, not once per query. > If you run this query a few times, you will see the problem: > SELECT y, chr(round(random())::int + 65) FROM (SELECT '

Re: random generated string matching index in inexplicable ways

> On 7 May 2019, at 13:53, Myles Miller wrote: > > PROBLEM: > Strings or characters generated by any random function (including pg_crypto > gen_random_bytes) are matching a string/char index in surprising ways. I fail to see anything surprising in your examples. > Reduced down to its simplest

RE: Question on binding VIP to Postgresql instance

I think getting postgres to work with VIP (assuming virtual IP) is not a postgres issue, but rather a server/network issue. Redhat seems to have some documentation on enabling nonlocal binding, which may be useful for you: https://access.redhat.com/documentation/en-us/red_hat_enterprise

RE: Question on binding VIP to Postgresql instance

Thanks Chris! Our Network Admin have the instruction to bind a VIP, but regarding Postgresql what is needed to be done? We don't have to change any parameter? How about "listen_addresses = ', ' # what IP address(es) to listen on;" or we simply use "*"? -Original Message- F

Question on binding VIP to Postgresql instance

Good day, Would you be able to help direct me to instruction or implementation step to bind a VIP to a Postgresql instance? I did research and understand that Postgresql does support binding of VIP, but I can't find documentation to implement the solution. Any feedback is greatly appreciated.

random generated string matching index in inexplicable ways

PROBLEM: Strings or characters generated by any random function (including pg_crypto gen_random_bytes) are matching a string/char index in surprising ways. Reduced down to its simplest example: -- use random 0 or 1, plus 65, to get 'A' or 'B' # SELECT chr(round(random())::int + 65); chr - B

Re: PostgreSQL on Amazon RDS

On 5/7/19 9:25 AM, Rashmi V Bharadwaj wrote: Hi, That query will only give the PostgreSQL database server's IP address right? That is true while we do a remote access to the non-cloud database from another machine also. I want to know if there is anything specific that can be used to determin