bug regclass::oid

2019-06-13 Thread John Mikel
* hi , i am here to tell you that this test in query is not working when the table name in the database or schema name contain space a.table_name::regclass=b.attrelid a is information_schema.columns b is pg_attribute trying this in two different databases the first database contain table with

Re: bug regclass::oid

2019-06-13 Thread Adrian Klaver
On 6/13/19 8:14 AM, John Mikel wrote: * hi ,  i am here to tell you that this  test in query is not working when the  table name in the database or schema name   contain space  a.table_name::regclass=b.attrelid  a is information_schema.columns  b is pg_attribute  trying this in two differ

Re: Advice on setting cost for function

2019-06-13 Thread Tom Lane
guy...@relevantlogic.com writes: > The documentation in CREATE FUNCTION is fine as far is it goes regarding the > COST setting, but that isn’t very far, and I haven’t had any luck finding > good advice. Fair complaint. A quick data dump: procost = 1 is supposed to represent the cost of a simpl

RE: Drive Architecture for new PostgreSQL Environment

2019-06-13 Thread Kevin Brannen
From: Hilbert, Karin Hello, We're in the process of building a new PostgreSQL environment on Scientific Linux release 7.6. The new environment will have a Primary & 2 Standby servers & have asynchronous replication. It will use repmgr to manage failover/switchover events. In the past,

Re: Connection refused (0x0000274D/10061)

2019-06-13 Thread Adrian Klaver
On 6/13/19 9:56 AM, Sourav Majumdar wrote: Hi, I have tried many time for setup postgreSQL for my local host. Hence I have tried to reInstall the one click app from https://www.enterprisedb.com/downloads/postgres-postgresql-downloads -  Windows x86-64  -  PostgreSQL Version 11.3. When installi