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

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 > >>

Re: [HACKERS] Run pgindent now?

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 a way to

Re: [HACKERS] additional json functionality

On Wed, Nov 13, 2013 at 04:50:49PM -0800, David E. Wheeler wrote: On Nov 13, 2013, at 4:45 PM, Andrew Dunstan and...@dunslane.net 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

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

On Thu, Oct 31, 2013 at 09:54:14PM +0900, MauMau wrote: From: Robert Haas robertmh...@gmail.com 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

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

On Thu, Oct 31, 2013 at 01:59:04PM -0400, Robert Haas wrote: On Thu, Oct 31, 2013 at 1:02 PM, Garick Hamlin gham...@isc.upenn.edu wrote: On Thu, Oct 31, 2013 at 09:54:14PM +0900, MauMau wrote: From: Robert Haas robertmh...@gmail.com ISTM that the biggest problem is that we don't have

Re: [HACKERS] Enabling Checksums

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 Davispg...@j-davis.com wrote: Fletcher is probably significantly faster than CRC-16, because I'm just doing int32 addition in a tight loop. Simon

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

On Tue, Jan 15, 2013 at 01:35:57PM +, Greg Stark wrote: On Tue, Jan 15, 2013 at 2:33 AM, Stephen Frost sfr...@snowman.net 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

Re: [HACKERS] proposal - urlencode, urldecode support

On Wed, Apr 25, 2012 at 02:41:19PM -0400, Tom Lane wrote: Pavel Stehule pavel.steh...@gmail.com writes: 2012/4/25 Michael Glaesemann g...@seespotcode.net: 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

Re: [HACKERS] JSON for PG 9.2

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 that he

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

On Wed, Oct 12, 2011 at 03:16:54PM +0100, Greg Stark wrote: On Wed, Oct 12, 2011 at 2:52 PM, Tom Lane t...@sss.pgh.pa.us 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

[HACKERS] 9.1beta2 / UNLOGGED + CHECK + INHERITS

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

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.

Re: [HACKERS] Streaming base backups

On Mon, Jan 10, 2011 at 09:09:28AM -0500, Magnus Hagander wrote: On Sun, Jan 9, 2011 at 23:33, Cédric Villemain cedric.villemain.deb...@gmail.com wrote: 2011/1/7 Magnus Hagander mag...@hagander.net: On Fri, Jan 7, 2011 at 01:47, Cédric Villemain cedric.villemain.deb...@gmail.com wrote:

Re: [HACKERS] Streaming base backups

On Tue, Jan 11, 2011 at 11:39:20AM -0500, Cédric Villemain wrote: 2011/1/11 Garick Hamlin gham...@isc.upenn.edu: On Mon, Jan 10, 2011 at 09:09:28AM -0500, Magnus Hagander wrote: On Sun, Jan 9, 2011 at 23:33, Cédric Villemain cedric.villemain.deb...@gmail.com wrote: 2011/1/7 Magnus

Re: [HACKERS] Streaming base backups

On Tue, Jan 11, 2011 at 12:45:02PM -0500, Tom Lane wrote: Florian Pflug f...@phlo.org 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 recently that O_DIRECT fails for ext4

Re: [HACKERS] Streaming base backups

On Thu, Jan 06, 2011 at 07:47:39PM -0500, Cédric Villemain wrote: 2011/1/5 Magnus Hagander mag...@hagander.net: On Wed, Jan 5, 2011 at 22:58, Dimitri Fontaine dimi...@2ndquadrant.fr wrote: Magnus Hagander mag...@hagander.net writes: * Stefan mentiond it might be useful to put some

Re: [HACKERS] Streaming base backups

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 mag...@hagander.net: On Wed, Jan 5, 2011 at 22:58, Dimitri Fontaine dimi...@2ndquadrant.fr wrote: Magnus Hagander mag

Re: [HACKERS] plperl arginfo

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. Passing the

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

On Wed, Oct 13, 2010 at 12:56:15PM -0400, Tom Lane wrote: Robert Haas robertmh...@gmail.com 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

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

On Wed, Sep 15, 2010 at 10:05:00PM -0400, Tom Lane wrote: Mark Kirkwood mark.kirkw...@catalyst.net.nz 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

Re: [HACKERS] libpq should not be using SSL_CTX_set_client_cert_cb

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 side

Re: [HACKERS] libpq should not be using SSL_CTX_set_client_cert_cb

On Wed, May 26, 2010 at 10:54:42AM -0400, Tom Lane wrote: Garick Hamlin gham...@isc.upenn.edu 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

[HACKERS] pgbouncer + psql 9.0a4

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

Re: [HACKERS] pgbouncer + psql 9.0a4

On Fri, Feb 26, 2010 at 11:38:20AM -0500, Jaime Casanova wrote: On Fri, Feb 26, 2010 at 11:26 AM, Garick Hamlin gham...@isc.upenn.edu wrote: I imagine this is really mostly pgbouncer's problem yes it is, but you can workaround it using ignore_startup_parameters parameter in pgbouncer.ini

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

On Thu, Feb 11, 2010 at 01:22:44PM -0500, Kevin Grittner wrote: Heikki Linnakangas heikki.linnakan...@enterprisedb.com 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

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

On Wed, Jan 06, 2010 at 11:14:38AM -0500, Tom Lane wrote: Andrew Dunstan and...@dunslane.net writes: Tom Lane wrote: spi_rv = SPI_execute(query, current_call_data-prodesc-fn_readonly, ^^^ OK, but won't that automatically

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

On Tue, Jan 05, 2010 at 02:02:51PM -0500, Tom Lane wrote: Stefan Kaltenbrunner ste...@kaltenbrunner.cc 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

[HACKERS] Solaris ident authentication using unix domain sockets

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

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

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 patch basically just adds support for using