Re: [HACKERS] PATCH: Batch/pipelining support for libpq

On 22 November 2016 at 18:32, Craig Ringer wrote: > On 22 November 2016 at 15:14, Haribabu Kommi > wrote: > > > > On Fri, Nov 18, 2016 at 7:18 PM, Craig Ringer > wrote: > >> > >> The latest is what's attached upthread and what's in the git repo > >> also referenced upthread. > >> > >> I haven't b

[HACKERS] Proposal/design feedback needed: "Providing catalog view to pg_hba.conf file"

Hi All, I would like to propose an implementation of creating new catalog view for pg_hba.conf file contents. Aim of this proposal is to present a new view "pg_settings_hba" to database administrator, for viewing pg_hba.conf file contents. Currently, to view the pg_hba.conf file contents,

[HACKERS] Proposal - Support for 'OR REPLACE' in 'CREATE TRIGGER' command

Hi, This is a proposal to implement support for 'OR REPLACE' in 'CREATE TRIGGER' command as an optional clause. The aim of this proposal is to present a way to support replace trigger functionality. Adding the optional clause 'OR REPLACE' in CREATE TRIGGER syntax gives users the option o

[HACKERS] Differences in WHERE clause of SELECT

Hi, I am a newbie to PostgreSQL and was wondering about the following behaviour. SELECT true WHERE 1 = '1'; <-- Returns true SELECT true WHERE 1 BETWEEN '0' and '2';<-- Returns true SELECT true WHERE 1 IS DISTINCT FROM '2';<-- Returns true SELECT true WHERE 1 LIK

Re: [HACKERS] Differences in WHERE clause of SELECT

Hi Berkus, Thanks for your time and response. I do understand that there is no LIKE operator support for integers and it would be great if you could help me understand the reason why is it not supported. My intention is to know whether this is not supported because of any technical limitation

Re: [HACKERS] Differences in WHERE clause of SELECT

On Wed, Jul 10, 2013 at 8:42 PM, Prabakaran, Vaishnavi wrote: > Hi Berkus, > > Thanks for your time and response. > > I do understand that there is no LIKE operator support for integers and it > would be great if you could help me understand the reason why is it not &

Re: [HACKERS] Differences in WHERE clause of SELECT

Hi, Thanks for your responses. The specific use case which I am interested in is " Numeric LIKE Pattern_string ". I'm willing to attempt a patch to support the specific use case above by adding implicit casts, without modifying the entire casting rules. Is this something that is likely to be

[HACKERS] Providing catalog view to pg_hba.conf file - Patch submission

Hi, In connection to my previous proposal about "providing catalog view to pg_hba.conf file contents" , I have developed the attached patch . [Current situation] Currently, to view the pg_hba.conf file contents, DB admin has to access the file from database server to read the settings. I

Re: [HACKERS] Providing catalog view to pg_hba.conf file - Patch submission

From: Magnus Hagander [mailto:mag...@hagander.net] Sent: Friday, 14 March 2014 9:33 PM To: Prabakaran, Vaishnavi Cc: PostgreSQL-development Subject: Re: [HACKERS] Providing catalog view to pg_hba.conf file - Patch submission On Fri, Mar 14, 2014 at 6:30 AM, Prabakaran, Vaishnavi mailto:vaishna

Re: [HACKERS] Providing catalog view to pg_hba.conf file - Patch submission

On Friday, Mar 14, 2014 at 9:33 PM, Maganus Hagander mailto:mag...@hagander.net> > wrote: >>Hi, >>In connection to my previous proposal about "providing catalog view to >>pg_hba.conf file contents" , I have developed the attached patch . >> [Current situation] >>Currently, to view the pg_hba.

[HACKERS] New option in pg_basebackup to exclude pg_log files during base backup

Hi all, Following the discussion in message id - cahgqgwffmor4ecugwhzpaapyqbsekdg66vmj1rvej6z-ega...@mail.gmail.com , I have developed the patch which gives option to user to exclude pg_log directory contents in pg_base

Re: [HACKERS] New option in pg_basebackup to exclude pg_log files during base backup

On Thursday, Apr 10,2014 at 1:15Am, Álvaro Herrera wrote: >Magnus Hagander wrote: >>On Wed, Apr 9, 2014 at 4:55 PM, Alvaro Herrera >>wrote: >> > So it'd be an array, and by default you'd have something like: >> > basebackup_skip_path = $log_directory ? >> > >> > Maybe use it to skip backup l