Re: [HACKERS] [COMMITTERS] pgsql: Use gender-neutral language in documentation

2015-09-22 Thread Garick Hamlin
On Tue, Sep 22, 2015 at 11:59:21AM -0400, Robert Haas wrote: > On Tue, Sep 22, 2015 at 11:00 AM, Andrew Dunstan wrote: > >> Happily for me, I can continue to write documents in a grammatically > >> correct way, and no-one will read them and think I'm a grammar-nazi (or > >> obstinate, or old-fashi

Re: [HACKERS] Run pgindent now?

2015-05-27 Thread Garick Hamlin
On Tue, May 26, 2015 at 04:32:42PM -0300, Alvaro Herrera wrote: > Robert Haas wrote: > > > But every time we pgindent, especially with slightly different > > settings, we cause tools like 'git blame' to return less useful > > answers. And that sucks. > > I've wondered a few times whether there's

Re: [HACKERS] additional json functionality

2013-11-14 Thread Garick Hamlin
On Wed, Nov 13, 2013 at 04:50:49PM -0800, David E. Wheeler wrote: > On Nov 13, 2013, at 4:45 PM, Andrew Dunstan wrote: > > >> It should be a pretty-printing function option, perhaps, but not core to > >> the type itself, IMO. > > > > I don't in the least understand how it could be a pretty prin

Re: [HACKERS] How can I build OSSP UUID support on Windows to avoid duplicate UUIDs?

2013-10-31 Thread Garick Hamlin
On Thu, Oct 31, 2013 at 01:59:04PM -0400, Robert Haas wrote: > On Thu, Oct 31, 2013 at 1:02 PM, Garick Hamlin wrote: > > On Thu, Oct 31, 2013 at 09:54:14PM +0900, MauMau wrote: > >> From: "Robert Haas" > >>> ISTM that the biggest problem is that we do

Re: [HACKERS] How can I build OSSP UUID support on Windows to avoid duplicate UUIDs?

2013-10-31 Thread Garick Hamlin
On Thu, Oct 31, 2013 at 09:54:14PM +0900, MauMau wrote: > From: "Robert Haas" >> ISTM that the biggest problem is that we don't have a random number >> generator which generates enough bits of randomness to implement >> uuid_generate_v3. I think relatively few people would cry if we >> didn't sup

Re: [HACKERS] Enabling Checksums

2013-03-06 Thread Garick Hamlin
On Wed, Mar 06, 2013 at 01:34:21PM +0200, Heikki Linnakangas wrote: > On 06.03.2013 10:41, Simon Riggs wrote: >> On 5 March 2013 18:02, Jeff Davis wrote: >> >>> Fletcher is probably significantly faster than CRC-16, because I'm just >>> doing int32 addition in a tight loop. >>> >>> Simon originall

Re: [HACKERS] [PATCH] COPY .. COMPRESSED

2013-01-15 Thread Garick Hamlin
On Tue, Jan 15, 2013 at 01:35:57PM +, Greg Stark wrote: > On Tue, Jan 15, 2013 at 2:33 AM, Stephen Frost wrote: > > * Peter Eisentraut (pete...@gmx.net) wrote: > >> On 1/14/13 11:28 AM, Stephen Frost wrote: > >> > While there is no option currently for having the server do the > >> > compressi

Re: [HACKERS] proposal - urlencode, urldecode support

2012-04-25 Thread Garick Hamlin
On Wed, Apr 25, 2012 at 02:41:19PM -0400, Tom Lane wrote: > Pavel Stehule writes: > > 2012/4/25 Michael Glaesemann : > >> Sounds like a great idea for a PGXN module. > > > it is one variant - but with support some web technologies - XML, > > JSON, I prefer this in core. Urlcode is one the most us

Re: [HACKERS] JSON for PG 9.2

2012-01-20 Thread Garick Hamlin
On Fri, Jan 20, 2012 at 09:12:13AM -0800, David E. Wheeler wrote: > On Jan 19, 2012, at 9:07 PM, Tom Lane wrote: > > > If his client encoding is UTF8, the value will be letter-perfect JSON > > when it gets to him; and if his client encoding is not UTF8, then he's > > already pretty much decided th

Re: [HACKERS] COUNT(*) and index-only scans

2011-10-12 Thread Garick Hamlin
On Wed, Oct 12, 2011 at 03:16:54PM +0100, Greg Stark wrote: > On Wed, Oct 12, 2011 at 2:52 PM, Tom Lane wrote: > > I think it's overkill, and possibly unpleasantly unstable as well. > > For the initial attack on this we should just have VACUUM and ANALYZE > > count the number of all-visible blocks

[HACKERS] 9.1beta2 / UNLOGGED + CHECK + INHERITS

2011-06-17 Thread Garick Hamlin
I wanted to see how much faster unlogged tables might be for an app I have, so as a quick test I did: s/CREATE TABLE/CREATE UNLOGGED TABLE/ to get some numbers. Which lead to a crash. Here is a trimmed down test case: $ cat > unlog-test.sql CREATE UNLOGGED TABLE leases ( mac macaddr NOT NULL,

Re: [HACKERS] One Role, Two Passwords

2011-01-21 Thread Garick Hamlin
On Thu, Jan 20, 2011 at 08:55:42PM -0500, Daniel Farina wrote: > The problem is that running a reliable, > centralized LDAP service is not justifiable as compared to role > mangling on a per-node level, and the role mangling seems has some > shortcomings that are negotiable with gritted teeth. Wan

Re: [HACKERS] Streaming base backups

2011-01-11 Thread Garick Hamlin
On Tue, Jan 11, 2011 at 12:45:02PM -0500, Tom Lane wrote: > Florian Pflug writes: > > On Jan11, 2011, at 18:09 , Garick Hamlin wrote: > >> My gut was that direct io would likely work right on Linux > >> and Solaris, at least. > > > Didn't we discover

Re: [HACKERS] Streaming base backups

2011-01-11 Thread Garick Hamlin
On Tue, Jan 11, 2011 at 11:39:20AM -0500, Cédric Villemain wrote: > 2011/1/11 Garick Hamlin : > > On Mon, Jan 10, 2011 at 09:09:28AM -0500, Magnus Hagander wrote: > >> On Sun, Jan 9, 2011 at 23:33, Cédric Villemain > >> wrote: > >> > 2011/1/7 Magnus Hagander

Re: [HACKERS] Streaming base backups

2011-01-11 Thread Garick Hamlin
On Mon, Jan 10, 2011 at 09:09:28AM -0500, Magnus Hagander wrote: > On Sun, Jan 9, 2011 at 23:33, Cédric Villemain > wrote: > > 2011/1/7 Magnus Hagander : > >> On Fri, Jan 7, 2011 at 01:47, Cédric Villemain > >> wrote: > >>> 2011/1/5 Magnus Hagander : > On Wed, Jan 5, 2011 at 22:58, Dimitri F

Re: [HACKERS] Streaming base backups

2011-01-07 Thread Garick Hamlin
On Fri, Jan 07, 2011 at 10:26:29AM -0500, Garick Hamlin wrote: > On Thu, Jan 06, 2011 at 07:47:39PM -0500, Cédric Villemain wrote: > > 2011/1/5 Magnus Hagander : > > > On Wed, Jan 5, 2011 at 22:58, Dimitri Fontaine > > > wrote: > > >> Magnus Hagander wri

Re: [HACKERS] Streaming base backups

2011-01-07 Thread Garick Hamlin
On Thu, Jan 06, 2011 at 07:47:39PM -0500, Cédric Villemain wrote: > 2011/1/5 Magnus Hagander : > > On Wed, Jan 5, 2011 at 22:58, Dimitri Fontaine > > wrote: > >> Magnus Hagander writes: > >>> * Stefan mentiond it might be useful to put some > >>> posix_fadvise(POSIX_FADV_DONTNEED) > >>>   in the

Re: [HACKERS] plperl arginfo

2010-10-28 Thread Garick Hamlin
On Thu, Oct 28, 2010 at 01:03:24PM -0400, Andrew Dunstan wrote: > > > On 10/28/2010 12:34 PM, Tom Lane wrote: > > > > BTW, maybe we could have the best of both worlds? Dunno about Perl, > > but in some languages it would be possible to instantiate the hash > > only if it's actually touched. Pas

Re: [HACKERS] SQL command to edit postgresql.conf, with comments

2010-10-13 Thread Garick Hamlin
On Wed, Oct 13, 2010 at 12:56:15PM -0400, Tom Lane wrote: > Robert Haas writes: > > But creating a separate file doesn't fix that problem. It just moves > > it around. If people will expect comments in postgresql.conf to get > > preserved, then why won't they also expect comments in > > postgre

Re: [HACKERS] patch: SQL/MED(FDW) DDL

2010-09-16 Thread Garick Hamlin
On Wed, Sep 15, 2010 at 10:05:00PM -0400, Tom Lane wrote: > Mark Kirkwood writes: > > On 16/09/10 13:22, Tom Lane wrote: > >> What exactly do those get you that an ordinary index, or at worst an > >> index-organized table, doesn't get you? > > > It is pretty rare to see key value stores vs relati

Re: [HACKERS] libpq should not be using SSL_CTX_set_client_cert_cb

2010-05-26 Thread Garick Hamlin
On Wed, May 26, 2010 at 10:54:42AM -0400, Tom Lane wrote: > Garick Hamlin writes: > > I am guessing the problem is that validating the presented chain is hard? > > No, the problem is that the current libpq code fails to present the > chain at all. It will only load and send

Re: [HACKERS] libpq should not be using SSL_CTX_set_client_cert_cb

2010-05-26 Thread Garick Hamlin
On Tue, May 25, 2010 at 10:29:07PM -0400, Tom Lane wrote: > I've been experimenting with SSL setups involving chains of CA > certificates, ie, where the server or client cert itself is signed by > an intermediate CA rather than a trusted root CA. This appears to work > well enough on the server si

Re: [HACKERS] pgbouncer + psql 9.0a4

2010-02-26 Thread Garick Hamlin
On Fri, Feb 26, 2010 at 11:38:20AM -0500, Jaime Casanova wrote: > On Fri, Feb 26, 2010 at 11:26 AM, Garick Hamlin wrote: > > > > I imagine this is really mostly pgbouncer's problem > > yes it is, but you can workaround it using "ignore_startup_parameters"

[HACKERS] pgbouncer + psql 9.0a4

2010-02-26 Thread Garick Hamlin
I was just trying out 9.0a4 and I noticed. That I can't connect to pgbouncer with psql from 9.0a4 as a result of the set application_name changes to psql. I imagine this is really mostly pgbouncer's problem, but I couldn't figure out how if it was possible to make psql not set application_name

Re: [HACKERS] Re: [COMMITTERS] pgsql: Make standby server continuously retry restoring the next WAL

2010-02-11 Thread Garick Hamlin
On Thu, Feb 11, 2010 at 01:22:44PM -0500, Kevin Grittner wrote: > Heikki Linnakangas wrote: > > > I think 'rsync' has the same problem. > > There is a switch you can use to create the problem under rsync, but > by default rsync copies to a temporary file name and moves the > completed file to

Re: [HACKERS] Status of plperl inter-sp calling

2010-01-06 Thread Garick Hamlin
On Wed, Jan 06, 2010 at 11:14:38AM -0500, Tom Lane wrote: > Andrew Dunstan writes: > > Tom Lane wrote: > >> spi_rv = SPI_execute(query, current_call_data->prodesc->fn_readonly, > >> ^^^ > > > OK, but won't that automatically supply t

Re: [HACKERS] Re: [COMMITTERS] pgsql: Get rid of the need for manual maintenance of the initial

2010-01-05 Thread Garick Hamlin
On Tue, Jan 05, 2010 at 02:02:51PM -0500, Tom Lane wrote: > Stefan Kaltenbrunner writes: > > did that and it seems the problem is in the loop that does: > > > foreach my $row (@$data) > > { > > > # To construct fmgroids.h and fmgrtab.c, we need to inspect some > > # of the individual d

Re: [HACKERS] Solaris ident authentication using unix domain sockets

2008-07-03 Thread Garick Hamlin
On Thu, Jul 03, 2008 at 02:01:22PM -0400, Tom Lane wrote: > Garick Hamlin <[EMAIL PROTECTED]> writes: > > I have a patch that I have been using to support postgresql's > > notion of ident authentication when using unix domain sockets on > > Solaris. This p

[HACKERS] Solaris ident authentication using unix domain sockets

2008-07-03 Thread Garick Hamlin
Hi, I have a patch that I have been using to support postgresql's notion of ident authentication when using unix domain sockets on Solaris. This patch basically just adds support for using getupeercred() on Solaris so unix sockets and ident auth works just like it does on Linux and elsewh