Re: [GENERAL] pgAdmin4 needs information of v10 SCRAM authentication

On Mon, Apr 24, 2017 at 3:04 PM, Akshay Joshi wrote: >I have gone through this, but still facing issue to encrypt/change the > database server password. In pgAdmin4 we have "Change Password" feature where > user will enter the old and new password for the database server, now we will > have

Re: [GENERAL] pgAdmin4 needs information of v10 SCRAM authentication

Hi Michael On Fri, Apr 21, 2017 at 12:07 PM, Michael Paquier wrote: > On Fri, Apr 21, 2017 at 3:27 PM, Akshay Joshi > wrote: > > from passlib.hash import scram > > hash = scram.encrypt(data['newPassword']) -- This function provide > password for all the supported digest like [md5, sha-1, sha-25

Re: [GENERAL] Strange Issue between PSQL 9.3 and Label Zebra Printer?

On 04/23/2017 05:48 PM, Periko Support wrote: Yes, with our datamax no issue. Once u setup the label in LabelView u chose which printer to use. That indicates to me it is a printer driver/setup issue and not anything the database is causing. You might want to verify the e.g. media settings a

Re: [GENERAL] [pgadmin-hackers] file permission on ssl key

Hi Jeroen, This is pgAdmin hackers list. Please send mail to pgsql-general@postgresql.org mailing list for your postgresql related queries. -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company *http://www.linkedin.com/in/asheshvashi

Re: [GENERAL] Protocol 2 and query parameters support

> Andres Freund writes: >> On 2017-04-23 12:08:51 -0700, Konstantin Izmailov wrote: >>> Some systems (Presto) are still using protocol 2, and I need to understand >>> the scope of changes in the middleware to support protocol 2. > >> Could you provide a reference about presto using v2 protocol?

Re: [GENERAL] Protocol 2 and query parameters support

Andres Freund writes: > On 2017-04-23 12:08:51 -0700, Konstantin Izmailov wrote: >> Some systems (Presto) are still using protocol 2, and I need to understand >> the scope of changes in the middleware to support protocol 2. > Could you provide a reference about presto using v2 protocol? A quick

Re: [GENERAL] Protocol 2 and query parameters support

On 2017-04-23 12:08:51 -0700, Konstantin Izmailov wrote: > Does Postgres protocol 2 support query parameters? e.g.: > SELECT colA FROM tbl WHERE colB=$1 > > Some systems (Presto) are still using protocol 2, and I need to understand > the scope of changes in the middleware to support protocol 2.

Re: [GENERAL] Strange Issue between PSQL 9.3 and Label Zebra Printer?

Yes, with our datamax no issue. Once u setup the label in LabelView u chose which printer to use. On Sun, Apr 23, 2017 at 1:27 PM, Adrian Klaver wrote: > On 04/23/2017 01:12 PM, Periko Support wrote: >> >> We use a label program called LabelView to create our labels, we read >> the record using

Re: [GENERAL] Protocol 2 and query parameters support

On Sunday, April 23, 2017, Adrian Klaver wrote: > On 04/23/2017 12:08 PM, Konstantin Izmailov wrote: > >> Does Postgres protocol 2 support query parameters? e.g.: >> SELECT colA FROM tbl WHERE colB=$1 >> >> Some systems (Presto) are still using protocol 2, and I need to >> understand the scope

Re: [GENERAL] Does a view not define a composite type?

On Sunday, April 23, 2017, Guyren Howe wrote: > > > CREATE OR REPLACE FUNCTION reporting.formatted_cust_by_state_bold(c > "reporting_helpers.customers_by_state_ranked") > RETURNS "reporting_helpers.customers_by_state_ranked" > > I am told “ERROR: type reporting_helpers.customers_by_state_ranke

Re: [GENERAL] pg_basebackup issue

On Sunday, April 23, 2017, chiru r wrote: > Thank you for your reply. > > I agree, However we are planning, users not to have any direct privileges > on database objects or default roles(like SUPERUSER,CREATEDB,REPLICATION..etc) > in postgres. > > looking to create users(LOGIN) only and Grant all

Re: [GENERAL] Strange Issue between PSQL 9.3 and Label Zebra Printer?

On 04/23/2017 01:12 PM, Periko Support wrote: We use a label program called LabelView to create our labels, we read the record using ODBC. The label has 8 fields which UPC is what it changes on each one. You use the same program and setup to print to the DataMax printer and you do not have the

Re: [GENERAL] Strange Issue between PSQL 9.3 and Label Zebra Printer?

We use a label program called LabelView to create our labels, we read the record using ODBC. The label has 8 fields which UPC is what it changes on each one. Thanks. On Sat, Apr 22, 2017 at 11:28 AM, Adrian Klaver wrote: > On 04/21/2017 05:14 PM, Periko Support wrote: >> >> Hi guys. >> >> I would

Re: [GENERAL] Failed dependencies for Pgadmin4 Web in Centos 7

On 04/23/2017 12:07 PM, Clodoaldo Neto wrote: Trying to install Pgadmin4 Web in Centos7: # yum list installed pgadmin4\* Loaded plugins: fastestmirror, priorities Loading mirror speeds from cached hostfile * base: mirror.linuxfix.com * epel: mirror.sjc02.svwh.net <

Re: [GENERAL] Protocol 2 and query parameters support

On 04/23/2017 12:08 PM, Konstantin Izmailov wrote: Does Postgres protocol 2 support query parameters? e.g.: SELECT colA FROM tbl WHERE colB=$1 Some systems (Presto) are still using protocol 2, and I need to understand the scope of changes in the middleware to support protocol 2. ? https://www

[GENERAL] Protocol 2 and query parameters support

Does Postgres protocol 2 support query parameters? e.g.: SELECT colA FROM tbl WHERE colB=$1 Some systems (Presto) are still using protocol 2, and I need to understand the scope of changes in the middleware to support protocol 2.

[GENERAL] Failed dependencies for Pgadmin4 Web in Centos 7

Trying to install Pgadmin4 Web in Centos7: # yum list installed pgadmin4\* Loaded plugins: fastestmirror, priorities Loading mirror speeds from cached hostfile * base: mirror.linuxfix.com * epel: mirror.sjc02.svwh.net * extras: centos.mirror.ndchost.com * updates: centos.mirror.ndchost.com 34

[GENERAL] Re: Use function to manipulate rows — how to get separate columns, rather than single row value

> On Apr 23, 2017, at 11:34 , Guyren Howe wrote: > > I’m trying to write a function that manipulates whole rows. It returns the > same type as the table it is being applied to, but when I select the function > on the rows, I get a single column of row type, rather than separate columns. > > M

[GENERAL] Use function to manipulate rows — how to get separate columns, rather than single row value

I’m trying to write a function that manipulates whole rows. It returns the same type as the table it is being applied to, but when I select the function on the rows, I get a single column of row type, rather than separate columns. My function looks like: CREATE OR REPLACE FUNCTION reporting.for

Re: [GENERAL] Does a view not define a composite type?

> On Apr 23, 2017, at 10:12 , Guyren Howe wrote: > > I have a view: “reporting_helpers.customers_by_state_ranked" > > I try to define a function with this signature: > > CREATE OR REPLACE FUNCTION reporting.formatted_cust_by_state_bold(c > "reporting_helpers.customers_by_state_ranked") >

Re: [GENERAL] Limiting the amount of data in a variable when logging slow queries

On 21 April 2017 at 12:13, Brett Delle Grazie wrote: > Hi, > > We've enabled the slow query log and have a particular query that is > executing an insert against a table containing a binary array column. > > Given the content being stored is upwards of 100MB+ this leads to very > long log message

[GENERAL] Does a view not define a composite type?

I have a view: “reporting_helpers.customers_by_state_ranked" I try to define a function with this signature: CREATE OR REPLACE FUNCTION reporting.formatted_cust_by_state_bold(c "reporting_helpers.customers_by_state_ranked") RETURNS "reporting_helpers.customers_by_state_ranked" I am told “ER

Re: [GENERAL] pg_basebackup issue

On 04/23/2017 04:52 AM, chiru r wrote: Thank you for your reply. I agree, However we are planning, users not to have any direct privileges on database objects or default roles(like SUPERUSER,CREATEDB,REPLICATION..etc) in postgres. looking to create users(LOGIN) only and Grant all the privileges

Re: [GENERAL] pg_basebackup issue

On 04/23/2017 04:52 AM, chiru r wrote: Thank you for your reply. I agree, However we are planning, users not to have any direct privileges on database objects or default roles(like SUPERUSER,CREATEDB,REPLICATION..etc) in postgres. looking to create users(LOGIN) only and Grant all the privileges

Re: [GENERAL] Not sure this should be asked here but...

On 04/23/2017 03:31 AM, Ron Ben wrote: A simple open source forum system can be enough simetng like php-bb example: warez-bb.org the installation of such system is like 1 hour of work. In my point of view something like stack overflow is the best but i'm not sure if it's open source. See thi

Re: [GENERAL] pg_basebackup issue

On Sat, Apr 22, 2017 at 8:03 PM, David G. Johnston wrote: > On Saturday, April 22, 2017, chiru r wrote: >> >> Thank you Adrian. >> >> It seems the code is allowing only who has Superuser/Replication role >> directly. >> >> Is there any possibility in future releases they allow both case A & B >>

Re: [GENERAL] Not sure this should be asked here but...

Well no one is stopping you from starting a forum. But then you've got the herculean task of getting people to move to it from the comfort of the mailing list. I'm guessing that's a non-starter. On Sun, Apr 23, 2017 at 4:31 AM, Ron Ben wrote: > > A simple open source forum system can be enough si

Re: [GENERAL] pg_basebackup issue

Thank you for your reply. I agree, However we are planning, users not to have any direct privileges on database objects or default roles(like SUPERUSER,CREATEDB,REPLICATION..etc) in postgres. looking to create users(LOGIN) only and Grant all the privileges through roles like below. *Steps: * Cre

Re: [GENERAL] Database structure advise

Le 23 avril 2017 à 12:48, Ertan Küçükoğlu écrivait : > Hello All, > > Using PostgreSQL 9.6.2 on a Windows 64bit platform. > > I am about to start a new software development dealing with warehouse > operations. Software should handle multi-company structure. There will be > single company startin

[GENERAL] Database structure advise

Hello All, Using PostgreSQL 9.6.2 on a Windows 64bit platform. I am about to start a new software development dealing with warehouse operations. Software should handle multi-company structure. There will be single company starting to use the software at the beginning. I need to decide between be

Re: [GENERAL] Not sure this should be asked here but...

A simple open source forum system can be enough simetng like php-bb example: warez-bb.org   the installation of such system is like 1 hour of work.   In my point of view something like stack overflow is the best but i'm not sure if it's open source.ב אפר׳ 22, 2017 22:15, David G. Johnston כתב:On Sa