Re: [HACKERS] Proposal: Implement failover on libpq connect level.

it. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers

Re: [HACKERS] how to write/setup a C trigger function in a background worker

for trigger context, but it might be better to write two functions, one with the trigger stuff in it, the other, which it calls, for whatever action you actually want to trigger, and call that second in your background worker. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org

Re: [HACKERS] Test code is worth the space

that this tight coupling is necessary for performance. Are you saying that it could be unwound, or that testing strategies mostly need to take it into account, or...? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] Test code is worth the space

On Tue, Aug 18, 2015 at 04:54:07PM +0100, Greg Stark wrote: On Tue, Aug 18, 2015 at 2:16 PM, David Fetter da...@fetter.org wrote: I'm given to understand that this tight coupling is necessary for performance. Are you saying that it could be unwound, or that testing strategies mostly need

Re: [HACKERS] Declarative partitioning

. pg_class.relispartition is set to false for the table, so it behaves like a normal table. Could this take anything short of an access exclusive lock on the parent? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] More WITH

useful, easy to work around (pg_settings). This particular one is just about being consistent, or the way I look at it, about avoiding surprising users with inconsistencies. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter

[HACKERS] More WITH

the row-returning commands in WITH? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate

Re: [HACKERS] [RFC] allow 'semester' in functions EXTRACT, DATE_PART, TO_CHAR and so on.

is always 30 days, a quarter, always three months, i.e. 90 days, and a half is six months, or 180 days. Yes, date math is crazy, and yes, we have to deal with it as it exists. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] [patch] A \pivot command for psql

be handy as a broad, general part of reporting in psql, and would mesh quite nicely with a back-end PIVOT (SERIALIZATION FOO) or whatever syntax we land on. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] [patch] A \pivot command for psql

On Tue, Aug 11, 2015 at 05:13:03PM +0200, Daniel Verite wrote: David Fetter wrote: That depends on what you mean by dynamic columns. The approach taken in the tablefunc extension is to use functions which return SETOF RECORD, which in turn need to be cast at runtime. For me

Re: [HACKERS] [patch] A \pivot command for psql

On Mon, Aug 10, 2015 at 07:10:41PM +0200, Daniel Verite wrote: David Fetter wrote: I'm working up a proposal to add (UN)PIVOT support to the back-end. I was under the impression that a server-side PIVOT *with dynamic columns* was just unworkable as an SQL query, because it couldn't

Re: [HACKERS] [patch] A \pivot command for psql

, in this case the psql client. I'm working up a proposal to add (UN)PIVOT support to the back-end. Would you like to join in on that? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet

Re: [HACKERS] creating extension including dependencies

if it was available, and complain if it wasn’t. This is this baseline sane behavior. Getting the full dependency tree, although it would be very handy, would require more infrastructure than we have now. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] Serialization errors in Postgres 9.4.0

of the small table size it performs sequential scan and locks the entire table? Sorry if any of these questions are plain stupid. Thanks for asking. These questions are quite reasonable. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666

Re: [HACKERS] RFC: Remove contrib entirely

feature links to their source code repositories. Should this just be made a hard requirement for PGXN? Lack of a source code repo is a pretty good sign of abandonment. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] RFC: Remove contrib entirely

to get installed. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via

[HACKERS] GENERATED: the new generation

when it comes to temporal databases, which modern storage systems has made a good bit less crazy than they were when we got rid of time travel. What say? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter

Re: [HACKERS] GROUPING

On Thu, May 21, 2015 at 12:24:03PM -0400, Robert Haas wrote: On Thu, May 21, 2015 at 12:21 PM, Andrew Gierth and...@tao11.riddles.org.uk wrote: David == David Fetter da...@fetter.org writes: David How about a more sensible data structure as a PG-specific addon. David GROUPING_JSON

Re: [HACKERS] GROUPING

cheap and reasonable. Making sure people know that GROUPING can be called multiple times seems like another cheap and reasonable measure. *) any other ideas? How about a more sensible data structure as a PG-specific addon. GROUPING_JSON() seems like just the thing. Cheers, David. -- David Fetter

[HACKERS] GROUPING

something like GROUPING_JSON(). Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate

[HACKERS] tzdata and 9.4.2, etc.

Folks, We are now three tzdata changes behind. There are bugs in pg_dump which create real restore errors for people using PostGIS, one of our most popular extensions. Can we please wrap and ship 9.4.2, etc., and do it soon? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org

Re: [HACKERS] Implementing SQL ASSERTION

to include the lock strength needed. Just about anything can be done with a database-wide lock :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider

Re: [HACKERS] inherit support for foreign tables

foo_jp, foo_us, etc., in one level, foo_us_ca, foo_us_pa, etc. in the next level, and on down, each in general in a separate data center. Is there something essential about having non-leaf nodes as foreign tables that's a problem here? Cheers, David. -- David Fetter da...@fetter.org http

Re: [HACKERS] Assert there is no duplicated exit callbacks

with this, then the duplication check shall also bump to runtime checks. I don't think any of this is needed. - Heikki -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider

Re: [HACKERS] Make more portable TAP tests of initdb

up to bugs in the version-checking software. http://search.cpan.org/~rjbs/Test-MinimumVersion-0.101081/lib/Test/MinimumVersion.pm What say? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [HACKERS] PATCH: Spinlock Documentation

goes and changes the S_LOCK implementation for one of the platforms below, or adds a new platform, etc., without changing this comment too, this comment becomes confusingly obsolete. How do you plan to address this issue? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone

Re: [HACKERS] Bug fix for missing years in make_date()

On Tue, Mar 31, 2015 at 12:22:39PM -0700, David Fetter wrote: On Tue, Mar 31, 2015 at 12:58:27PM -0400, Tom Lane wrote: David Fetter da...@fetter.org writes: On Tue, Mar 31, 2015 at 10:34:45AM -0400, Adam Brightwell wrote: Previously, zero was rejected, what does it do now? I'm sure

Re: [HACKERS] POLA violation with \c service=

On Thu, Apr 02, 2015 at 11:46:53AM +0900, Michael Paquier wrote: On Thu, Apr 2, 2015 at 9:38 AM, Alvaro Herrera alvhe...@2ndquadrant.com wrote: David Fetter wrote: On Wed, Apr 01, 2015 at 08:13:02PM -0300, Alvaro Herrera wrote: I have pushed this after some rework. For instance

Re: [HACKERS] POLA violation with \c service=

see what I can do. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent

Re: [HACKERS] Bug fix for missing years in make_date()

was popularized a very long time after the beginning of the Common Era. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http

Re: [HACKERS] Bug fix for missing years in make_date()

On Tue, Mar 31, 2015 at 12:58:27PM -0400, Tom Lane wrote: David Fetter da...@fetter.org writes: On Tue, Mar 31, 2015 at 10:34:45AM -0400, Adam Brightwell wrote: Previously, zero was rejected, what does it do now? I'm sure it represents 0 AD/CE, however, is that important enough to note

Re: [HACKERS] Bug fix for missing years in make_date()

On Mon, Mar 30, 2015 at 05:35:29PM -0500, Jim Nasby wrote: On 3/26/15 5:26 PM, David Fetter wrote: + * Note: Non-positive years are take to be BCE. s/take/taken/ Good point. Next patch attached. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778

[HACKERS] Bug fix for missing years in make_date()

Folks, For reasons unclear, dates before the Common Era are disallowed in make_date(), even though about 2/3 of the underlying data type's range up until the present time fits that description. Please find attached a patch fixing same. Cheers, David. -- David Fetter da...@fetter.org http

Re: [HACKERS] Exposing PG_VERSION_NUM in pg_config

PG_VERSION_NUM in the Makefile actually help writers of extensions to do numeric comparisons on the version of PostgreSQL in a way that doesn't win a Rube Goldberg award? If not, that's good and sufficient reason to make it a pg_config output option. Cheers, David. -- David Fetter da...@fetter.org http

Re: [HACKERS] Remove fsync ON/OFF as a visible option?

should be reflected into the description strings in guc.c. I don't suppose there's a way to have a single point of truth... Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet

Re: [HACKERS] POLA violation with \c service=

On Fri, Feb 27, 2015 at 08:42:29AM -0800, David Fetter wrote: On Mon, Feb 23, 2015 at 05:56:12PM -0300, Alvaro Herrera wrote: David Fetter wrote: My thinking behind this was that the patch is a bug fix and intended to be back-patched, so I wanted to mess with as little

Re: [HACKERS] OOM-killer issue when updating a inheritance table which has large number of child tables

is not supported. If you can reproduce the problem in PostgreSQL 9.3.6, or whichever happens to be the most recent minor version by the time you do the test, that will help. Just generally, it helps to provide a complete test case which reproduces the problem if at all possible. Cheers, David. -- David

Re: [HACKERS] Using 128-bit integers for sum, avg and statistics aggregates

patch to add an int16 SQL type so that this implication is correct? The worst part of writing this patch has always been naming functions and types. :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter

Re: [HACKERS] POLA violation with \c service=

On Tue, Mar 03, 2015 at 09:52:55PM -0500, Robert Haas wrote: On Mon, Mar 2, 2015 at 5:05 PM, David Fetter da...@fetter.org wrote: So just to clarify, are you against back-patching the behavior change, or the addition to src/common? Mostly the latter. So you're saying the former isn't

Re: [HACKERS] Idea: GSoC - Query Rewrite with Materialized Views

://www.postgresql.org/message-id/1402790204.65037.YahooMailNeo%40web122301.mail.ne1.yahoo.com Yes, very much like that. Kevin, might you be able to give some guidance on this? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] POLA violation with \c service=

On Mon, Mar 02, 2015 at 04:52:37PM -0500, Robert Haas wrote: On Mon, Feb 23, 2015 at 3:56 PM, Alvaro Herrera alvhe...@2ndquadrant.com wrote: David Fetter wrote: My thinking behind this was that the patch is a bug fix and intended to be back-patched, so I wanted to mess with as little

Re: [HACKERS] Bug in pg_dump

footprint is pretty low so we may be able to backport this patch easily. +1 for backporting. It's a real bug, and real people get hit by it if they're using PostGIS, one of our most popular add-ons. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] POLA violation with \c service=

On Mon, Feb 23, 2015 at 05:56:12PM -0300, Alvaro Herrera wrote: David Fetter wrote: My thinking behind this was that the patch is a bug fix and intended to be back-patched, so I wanted to mess with as little infrastructure as possible. A new version of libpq seems like a very big ask

Re: [HACKERS] POLA violation with \c service=

On Fri, Feb 27, 2015 at 02:51:18PM -0300, Alvaro Herrera wrote: I don't understand. Why don't these patches move anything to src/common? Because I misunderstood the scope. Hope to get to those this evening. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235

Re: [HACKERS] PostgreSQL on z/OS UNIX?

to port PostgreSQL to z/OS UNIX? I tried this several years back, but failed hard right out of the gate due to being unable to get access to such a machine. Is there any chance you can put one or more animals of this type on the buildfarm? http://buildfarm.postgresql.org/ Cheers, David. -- David

Re: [HACKERS] Add min and max execute statement time in pg_stat_statement

On Wed, Feb 18, 2015 at 08:31:09PM -0700, David G. Johnston wrote: On Wed, Feb 18, 2015 at 6:50 PM, Andrew Dunstan and...@dunslane.net wrote: On 02/18/2015 08:34 PM, David Fetter wrote: On Tue, Feb 17, 2015 at 08:21:32PM -0500, Peter Eisentraut wrote: On 1/20/15 6:32 PM, David G

Re: [HACKERS] POLA violation with \c service=

. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src

Re: [HACKERS] POLA violation with \c service=

On Thu, Feb 19, 2015 at 09:32:29PM +0100, Pavel Stehule wrote: 2015-02-19 19:51 GMT+01:00 David Fetter da...@fetter.org: On Sun, Feb 01, 2015 at 08:38:24AM +0100, Pavel Stehule wrote: I'm not sure how best to illustrate those. Are you thinking of one example each for the URI

Re: [HACKERS] POLA violation with \c service=

for commit. Thanks for fixing the bug. Let's go with this. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http

Re: [HACKERS] Add min and max execute statement time in pg_stat_statement

variance? In distributions where the second moment about the mean exists, it's an unbiased estimator of the variance. In this, it's different from the population variance. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] RangeType internal use

On Fri, Feb 13, 2015 at 03:13:11PM -0600, Jim Nasby wrote: On 2/10/15 2:04 PM, David Fetter wrote: Yeah, but people expect to be able to partition on ranges that are not all of equal width. I think any proposal that we shouldn't support that is the kiss of death for a feature like

Re: [HACKERS] 9.6 Feature help requested: Inclusion Constraints

is based on another other tuple's presence with some generalized equality criterion. In the exclusion case, it's prevented. In the inclusion case, it's required. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] ibm system z in the buildfarm

=nudibranchbr=HEAD That's super awesome! Do you have access to put a z/OS animal there, too? The compilers available for that OS, as well as the OS itself, should make for some very interesting results. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] RangeType internal use

. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] Release note bloat is getting out of hand

, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Release note bloat is getting out of hand

searching. That would be awesome. Truly awesome. When supporting older versions, being able to find precisely when a feature was introduced in a single search through a file, or find in page, for those using web browsers, would really smooth off some burrs. Cheers, David. -- David Fetter da

Re: [HACKERS] Exposing the stats snapshot timestamp to SQL

in 9.5. That the interested parties haven't bothered to put buildfarm members in that use the option tells me that they're not all that interested. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter

Re: [HACKERS] Proposal: knowing detail of config files via SQL

This looks great! Is there a reason not to have the sourcefile as a column in pg_settings? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider

Re: [HACKERS] Proposal: knowing detail of config files via SQL

On Sat, Jan 31, 2015 at 12:50:20AM +0900, Sawada Masahiko wrote: On Sat, Jan 31, 2015 at 12:24 AM, David Fetter da...@fetter.org wrote: On Fri, Jan 30, 2015 at 09:38:10PM +0900, Sawada Masahiko wrote: On Tue, Jan 27, 2015 at 3:34 AM, Robert Haas robertmh...@gmail.com wrote: On Thu, Jan 22

[HACKERS] Make hba available to client code

to copypasta, so unless there are big objections, I'd like to export those functions to make hba available to other code. Objections? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet

Re: [HACKERS] Make hba available to client code

On Wed, Jan 28, 2015 at 04:10:42PM -0500, Tom Lane wrote: David Fetter da...@fetter.org writes: While investigating another project, namely adding pg_hba.conf support to pgbouncer, I ran into a stumbling block others probably will, too: the hba code is backend-only, which means that if I

Re: [HACKERS] Parallel Seq Scan

-Ahead + Cold Page Cache / Small RAM) Would you be so kind as to pass along any patches (ideally applicable to git master), tests, and specific measurements you made? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] [REVIEW] Re: Fix xpath() to return namespace definitions

-fix patches like this, should the patch creator (me) also create patches for back branches? As I understand it, back-patches are the committer's responsibility. The submitter might make suggestions as to how this might be approached if it doesn't appear trivial. Cheers, David. -- David Fetter

Re: [HACKERS] POLA violation with \c service=

On Sat, Jan 10, 2015 at 04:41:16PM -0800, David Fetter wrote: On Sat, Jan 10, 2015 at 09:30:57AM +0100, Erik Rijkers wrote: On Fri, January 9, 2015 20:15, David Fetter wrote: [psql_fix_uri_service_003.patch] Applies on master; the feature (switching services) works well but a \c

Re: [HACKERS] To do for psql to show installable extensions

associated with the extensions. (Althought it seems like it would more in keeping with other usage if \dx+ only listed the objects if it was given a pattern, and did what I propose if given no pattern) For what it's worth, of the proposals so far, I like \dxa most. Cheers, David. -- David Fetter

Re: [HACKERS] POLA violation with \c service=

On Sat, Jan 10, 2015 at 09:30:57AM +0100, Erik Rijkers wrote: On Fri, January 9, 2015 20:15, David Fetter wrote: [psql_fix_uri_service_003.patch] Applies on master; the feature (switching services) works well but a \c without any parameters produces a segfault: (centos 6.6, 4.9.2, 64

Re: [HACKERS] libpq 9.4 requires /etc/passwd?

PQconnectdbParams? +1 for this. Having a single point of truth here would be a big win. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating

Re: [HACKERS] POLA violation with \c service=

On Thu, Jan 08, 2015 at 08:04:47PM -0800, David Fetter wrote: On Mon, Jan 05, 2015 at 02:26:59PM -0800, David Fetter wrote: On Tue, Dec 30, 2014 at 04:48:11PM -0800, David Fetter wrote: On Wed, Dec 17, 2014 at 08:14:04AM -0500, Andrew Dunstan wrote: Yeah, that's the correct solution

Re: [HACKERS] POLA violation with \c service=

On Mon, Jan 05, 2015 at 02:26:59PM -0800, David Fetter wrote: On Tue, Dec 30, 2014 at 04:48:11PM -0800, David Fetter wrote: On Wed, Dec 17, 2014 at 08:14:04AM -0500, Andrew Dunstan wrote: Yeah, that's the correct solution. It should not be terribly difficult to create a test

Re: [HACKERS] POLA violation with \c service=

On Tue, Dec 30, 2014 at 04:48:11PM -0800, David Fetter wrote: On Wed, Dec 17, 2014 at 08:14:04AM -0500, Andrew Dunstan wrote: Yeah, that's the correct solution. It should not be terribly difficult to create a test for a conninfo string in the dbname parameter. That's what libpq does

Re: [HACKERS] event trigger test exception message

reason, the Sir does seem a bit sexist - we have no idea of the gender of the reader. Probably just 'sorry, no rewrite allowed' would suffice. We should change it to, I'm sorry. I can't do that. http://en.wikipedia.org/wiki/2001:_A_Space_Odyssey_%28film%29 Cheers, David. -- David Fetter da

Re: [HACKERS] Small doc patch about pg_service.conf

On Sat, Jan 03, 2015 at 03:03:45PM -0500, Tom Lane wrote: David Fetter da...@fetter.org writes: On Sat, Jan 03, 2015 at 02:36:50PM -0500, Noah Misch wrote: The old and the new documentation are both wrong. The directory libpq consults is `pg_config --sysconfdir`, which is packager-selected

Re: [HACKERS] Small doc patch about pg_service.conf

On Sat, Jan 03, 2015 at 02:36:50PM -0500, Noah Misch wrote: On Sat, Jan 03, 2015 at 01:22:02PM +0100, Magnus Hagander wrote: On Wed, Dec 31, 2014 at 3:24 PM, David Fetter da...@fetter.org wrote: There was a slash missing, which I've added. Where is the default directory on Windows

Re: [HACKERS] Small doc patch about pg_service.conf

On Sat, Jan 03, 2015 at 01:22:02PM +0100, Magnus Hagander wrote: On Wed, Dec 31, 2014 at 3:24 PM, David Fetter da...@fetter.org wrote: Folks, There was a slash missing, which I've added. Where is the default directory on Windows, or is there one? Applied, thanks. Thank you

[HACKERS] Small doc patch about pg_service.conf

Folks, There was a slash missing, which I've added. Where is the default directory on Windows, or is there one? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com

Re: [HACKERS] POLA violation with \c service=

On Wed, Dec 17, 2014 at 08:14:04AM -0500, Andrew Dunstan wrote: On 12/17/2014 04:11 AM, Heikki Linnakangas wrote: On 12/17/2014 10:03 AM, Albe Laurenz wrote: David Fetter wrote: I've noticed that psql's \c function handles service= requests in a way that I can only characterize as broken

Re: [HACKERS] POLA violation with \c service=

On Fri, Dec 19, 2014 at 07:03:36PM -0700, David Johnston wrote: On Wed, Dec 17, 2014 at 8:25 AM, David Fetter [via PostgreSQL] ml-node+s1045698n5831124...@n5.nabble.com wrote: On Wed, Dec 17, 2014 at 08:14:04AM -0500, Andrew Dunstan wrote: On 12/17/2014 04:11 AM, Heikki Linnakangas

Re: [HACKERS] NUMERIC private methods?

that they are subject to heavy breakage if we ever feel a need to change the internal API. While nothing can prevent negligence and pilot error, making it clear by the name of the included header that breakable stuff is being used seems like an excellent way to proceed. Cheers, David. -- David Fetter da

Re: [HACKERS] POLA violation with \c service=

On Wed, Dec 17, 2014 at 08:14:04AM -0500, Andrew Dunstan wrote: On 12/17/2014 04:11 AM, Heikki Linnakangas wrote: On 12/17/2014 10:03 AM, Albe Laurenz wrote: David Fetter wrote: I've noticed that psql's \c function handles service= requests in a way that I can only characterize as broken

Re: [HACKERS] NUMERIC private methods?

with a promotion/demotion scheme for larger representations. Until then, those of us writing extensions are stuck with heaps of extra instructions in it that could easily be trimmed away to good effect. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] Commitfest problems

more to do with other demands on my time. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org

[HACKERS] POLA violation with \c service=

? If not, which of the approaches seems reasonable? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org

[HACKERS] NUMERIC private methods?

blob? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql

Re: [HACKERS] moving Orafce from pgFoundry - pgFoundry management

the IRC documentation bot and replaced them with references to github. Marc, Could you please remove the Orafce project from pgFoundry? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet

Re: [HACKERS] pg_rewind in contrib

into src/bin/. If it should be there it'd be less code churn if it went into there in the first place. +1 for putting it directly in src/bin. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [HACKERS] On partitioning

not :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql

Re: [HACKERS] Commitfest problems

, you seem to carve off an enormous amount of time to follow -bugs and -general. What say you unsubscribe to those lists for the duration of your tenure as CFM? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [HACKERS] Commitfest problems

On Fri, Dec 12, 2014 at 04:21:43PM +0100, Andres Freund wrote: On 2014-12-12 07:10:40 -0800, David Fetter wrote: On Thu, Dec 11, 2014 at 05:55:56PM -0500, Tom Lane wrote: Josh Berkus j...@agliodbs.com writes: How about *you* run the next one, Tom? I think the limited amount

Re: [HACKERS] inherit support for foreign tables

^^ It occurs to me that the command generated by the FDW might well not be SQL at all, as is the case with file_fdw and anything else that talks to a NoSQL engine. Would it be reasonable to call this Remote command or something similarly generic? Cheers, David. -- David Fetter da...@fetter.org http

Re: [HACKERS] SSL regression test suite

? Not from me :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via

[HACKERS] postgres_fdw does not see enums

. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] postgres_fdw does not see enums

On Wed, Dec 03, 2014 at 05:38:47PM -0500, Tom Lane wrote: David Fetter da...@fetter.org writes: I've been trying out 9.5-to-be's PostgreSQL FDW, and I noticed that it doesn't seem to handle enum types. Would this be a trivial fix? No. How would you know whether the remote side even has

Re: [HACKERS] postgres_fdw does not see enums

On Wed, Dec 03, 2014 at 05:52:03PM -0500, Tom Lane wrote: David Fetter da...@fetter.org writes: On Wed, Dec 03, 2014 at 05:38:47PM -0500, Tom Lane wrote: No. How would you know whether the remote side even has the enum, let alone whether it has an identical set of members? I don't see

Re: [HACKERS] postgres_fdw does not see enums

On Wed, Dec 03, 2014 at 06:17:51PM -0500, Tom Lane wrote: David Fetter da...@fetter.org writes: On Wed, Dec 03, 2014 at 05:52:03PM -0500, Tom Lane wrote: What do you mean reconstruct the enum? Capture its state at the time when IMPORT FOREIGN SCHEMA is executed. Right now, if you try

Re: [HACKERS] [PROTOCOL TODO] Permit streaming of unknown-length lob/clob (bytea,text,etc)

and unknown? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via

Re: [HACKERS] Final Patch for GROUPING SETS

(the contrib patch is not necessary if the -u patch is used; the contrib/pg_stat_statements fixes are in the phase1 patch) -- Andrew (irc:RhodiumToad) Tom, any word on this? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666

Re: [HACKERS] Let's drop two obsolete features which are bear-traps for novices

On Tue, Nov 04, 2014 at 08:30:21AM +, Laurenz Albe wrote: David Fetter wrote: On Tue, Nov 04, 2014 at 07:51:06AM +0900, Tatsuo Ishii wrote: Just out of curiosity, why is Oracle's NUMBER (I assume you are talking about this) so fast? I suspect that what happens is that NUMBER

Re: [HACKERS] Let's drop two obsolete features which are bear-traps for novices

-state comparison, we beat them handily, we're somewhere near them or we're not even close would be enough to work from. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com

Re: [HACKERS] Let's drop two obsolete features which are bear-traps for novices

when you get past what 128 bits can represent. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Re: [HACKERS] pgaudit - an auditing extension for PostgreSQL

space for PostgreSQL-specific settings. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember

<    1   2   3   4   5   6   7   8   9   10   >