Re: [HACKERS] Next CFM?

2013-09-10 Thread David Fetter
On Tue, Sep 10, 2013 at 01:27:37PM -0400, Peter Eisentraut wrote: > On 9/9/13 5:56 PM, David Fetter wrote: > > On Mon, Sep 02, 2013 at 12:13:56PM -0700, David Fetter wrote: > >> On Mon, Sep 02, 2013 at 12:00:02PM -0500, Josh Berkus wrote: > >>> Hackers, > >&g

Re: [HACKERS] Next CFM?

2013-09-09 Thread David Fetter
On Mon, Sep 02, 2013 at 12:13:56PM -0700, David Fetter wrote: > On Mon, Sep 02, 2013 at 12:00:02PM -0500, Josh Berkus wrote: > > Hackers, > > > > We need a Commit Fest manager for the September CF. I'm not going > > to do it; this month is a heavy travel month

Re: [HACKERS] Custom Plan node

2013-09-07 Thread David Fetter
On Sat, Sep 07, 2013 at 05:21:31PM +0200, Kohei KaiGai wrote: > 2013/9/7 David Fetter : > > The broad outlines look great. > > > > Do we have any way, at least conceptually, to consider the graph > > of the cluster with edges weighted by network bandwidth and > >

Re: [HACKERS] Custom Plan node

2013-09-07 Thread David Fetter
> > * API to add an alternative join path, in addition to built-in join logic. > * API to add an alternative scan path, in addition to built-in scan logic. > * API to construct "CustomJoin" according to the related path. > * API to construct "CustomScan" acc

Re: [HACKERS] Extension Templates S03E11

2013-09-02 Thread David Fetter
think this actually just means the header does not include all it needs by > itself. Is there some standard set of checks you run on new patches, and are the results showing up on, say, the buildfarm or some other CI dashboard? Cheers, David. -- David Fetter http://fetter.org/ Phone: +1

Re: [HACKERS] Next CFM?

2013-09-02 Thread David Fetter
Checklist Mike and I assembled: > > https://wiki.postgresql.org/wiki/CommitFest_Checklist > > Mind you, Peter E. seems to be getting patches organized ... are you > CFM for this one, Peter? If Peter won't, I will. Cheers, David. -- David Fetter http://fetter.org/ Phone

Re: [HACKERS] [v9.4] row level security

2013-08-29 Thread David Fetter
need to clear at least as far as documenting what we do (do the access constraint before anything else, e.g.) or why we don't do things (disabling EXPLAIN, e.g.). Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XM

Re: [HACKERS] pg_restore multiple --function options

2013-08-27 Thread David Fetter
at really is orthogonal to whether > or not you can give multiple --function arguments. Come to think of it, some kind of recognition that functions can come in several flavors would be awesome, e.g. --function=myfunc\* which would capture all variants of myfunc. Let the bikesh

Re: [HACKERS] pg_restore multiple --function options

2013-08-27 Thread David Fetter
On Tue, Aug 27, 2013 at 08:14:32PM +0300, Heikki Linnakangas wrote: > On 27.08.2013 03:26, Michael Paquier wrote: > >On Tue, Aug 27, 2013 at 5:17 AM, David Fetter wrote: > >>On Mon, Aug 26, 2013 at 10:29:06PM +0300, Heikki Linnakangas wrote: > >>>While looking at

Re: [HACKERS] pg_restore multiple --function options

2013-08-26 Thread David Fetter
> it just an oversight or lack of interest? No doubt that --table is > the most interesting one, but IMHO the other options should behave > the same, for the sake of consistency. +1 for making them consistent. There will also be an improvement in usability. Cheers, David. -- David Fe

Re: [HACKERS] UNNEST with multiple args, and TABLE with multiple funcs

2013-08-19 Thread David Fetter
it. > More, I would to see 9.4 release:). Same here! :) > x.4 are happy PostgreSQL releases :) Each one has been at least baseline happy for me since 7.1. Some have made me overjoyed, though. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter66

Re: [HACKERS] How to create read-only view on 9.3

2013-08-13 Thread David Fetter
$ DECLARE v TEXT; BEGIN FOR v IN SELECT pg_catalog.quote_ident(schemaname) || '.' || pg_catalog.quote_ident(viewname) FROM pg_catalog.pg_views WHERE schemaname NOT IN ('pg_catalog', 'information_schema') LOOP EXECUTE 'REVOKE INSERT, UPDATE, DELETE, T

Re: [HACKERS] Modyfication Sort Merge Join Alghoritm

2013-08-12 Thread David Fetter
There's a paper that includes the phrase "g-join" from 2011 here: http://wwwlgis.informatik.uni-kl.de/cms/fileadmin/users/haerder/2011/JoinAndGrouping.pdf Is that it? Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: d

Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: [HACKERS] Proposal for Allow postgresql.conf values to be changed via SQL [review])

2013-08-09 Thread David Fetter
ach. The only drawback is that it requires > having PLproxy in core first, or something like Foreign Functions or > something. SQL/MED does define such an API. Whether we find it useful enough to make it the default way of doing things is a separate matter. I'll do some research. Che

Re: [HACKERS] Review: UNNEST (and other functions) WITH ORDINALITY

2013-08-06 Thread David Fetter
es where this can occur though. If you don't find one considerably simpler, I'm inclined to say we should let it lie, possibly with docs--even user-visible ones if you think it's appropriate. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter

Re: [HACKERS] pass-through queries to foreign servers

2013-07-31 Thread David Fetter
On Wed, Jul 31, 2013 at 01:22:56AM -0400, Tom Lane wrote: > David Fetter writes: > > On Tue, Jul 30, 2013 at 04:40:38PM -0700, David Gudeman wrote: > >> When you write an application involving foreign tables, you frequently > >> end up with queries that are just too ine

Re: [HACKERS] pass-through queries to foreign servers

2013-07-30 Thread David Fetter
W API, but I think it's common enough that we do need to solve it as above. Cheers, David. -- David Fetter 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/p

Re: [HACKERS] Review: UNNEST (and other functions) WITH ORDINALITY

2013-07-27 Thread David Fetter
On Thu, Jul 25, 2013 at 10:33:54AM -0700, David Fetter wrote: > On Wed, Jul 24, 2013 at 09:38:15PM +, Andrew Gierth wrote: > > Tom Lane said: > > > If we did it with a WithOrdinality expression node, the result would > > > always be of type RECORD, and we&

Re: [HACKERS] Review: UNNEST (and other functions) WITH ORDINALITY

2013-07-23 Thread David Fetter
On Tue, Jul 23, 2013 at 06:09:20PM -0400, Stephen Frost wrote: > David > > On Tuesday, July 23, 2013, David Fetter wrote: > > > > There are a lot of ways foreign tables don't yet act like local > > ones. Much as I'm a booster for fixing that problem,

Re: [HACKERS] Review: UNNEST (and other functions) WITH ORDINALITY

2013-07-23 Thread David Fetter
7;t yet act like local ones. Much as I'm a booster for fixing that problem, I'm thinking improvements in this direction are for a separate patch. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fe

Re: [HACKERS] GSOC13 proposal - extend RETURNING syntax

2013-07-22 Thread David Fetter
On Mon, Jul 22, 2013 at 09:52:14PM +0200, Karol Trzcionka wrote: > I've noticed problem with "UPDATE ... FROM" statement. Fix in new version. > Regards, > Karol What problem or problems did you notice, and what did you change to fix them? Cheers, David. -- David Fetter

Re: [HACKERS] proposal - psql - show longest tables

2013-07-22 Thread David Fetter
On Mon, Jul 22, 2013 at 03:55:33PM -0700, David Fetter wrote: > On Mon, Jul 22, 2013 at 02:44:59PM -0700, Dimitri Fontaine wrote: > > Pavel Stehule writes: > > >> SELECT * from top5(); > > > > $ TABLE top5; -- add a view on top of the SRF > > > >

Re: [HACKERS] proposal - psql - show longest tables

2013-07-22 Thread David Fetter
p20, ... what is not too friendly > > The SRF could be using custom GUCs so that you can parametrize it, or > just even classic parameters… > > $ TABLE top(5); -- needs a patch to accept SRF here… Andrew Gierth will probably be posting a design & patch for something si

Re: [HACKERS] [PATCH] pgbench --throttle (submission 7 - with lag measurement)

2013-07-22 Thread David Fetter
t; that is lag values that are large compared to the actual transaction > latency, indicate that something is amiss in the throttling process. > High schedule lag can highlight a subtle problem there even if the > target rate limit is met in the end. Cheers, David. -- David Fetter http://

Re: [HACKERS] Foreign Tables as Partitions

2013-07-19 Thread David Fetter
On Fri, Jul 19, 2013 at 11:41:14AM -0400, Robert Haas wrote: > On Thu, Jul 18, 2013 at 8:56 PM, David Fetter wrote: > > Please find attached a PoC patch to implement $subject. > > > > So far, with a lot of help from Andrew Gierth, I've roughed out an > > implemen

[HACKERS] Foreign Tables as Partitions

2013-07-18 Thread David Fetter
, etc. Cheers, David. -- David Fetter 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 to vote! Consider donating to Postgres:

[HACKERS] Re: Proposal/design feedback needed: WITHIN GROUP (sql standard ordered set aggregate functions)

2013-07-17 Thread David Fetter
entile_cont(float8[]) returning > arrays; e.g. percentile_cont(array[0, 0.25, 0.5, 0.75, 1]) to return > an array containing the bounds, median and quartiles in one go. This > is an extension to the spec but it seems sufficiently obviously > useful to be worth supporting. > &g

Re: [HACKERS] SSL renegotiation

2013-07-16 Thread David Fetter
gt; > Agreed. The OpenSSL Project last applied a security fix to 0.9.6 > over eight years ago. Compatibility with 0.9.6 has zero or negative > value. You've made a persuasive case that we should actively break backward compatibility here. Would that be complicated to do? Cheers,

Re: [HACKERS] Re: FILTER for aggregates [was Re: Department of Redundancy Department: makeNode(FuncCall) division]

2013-07-15 Thread David Fetter
On Sun, Jul 14, 2013 at 10:15:12PM -0400, Noah Misch wrote: > On Sun, Jul 07, 2013 at 06:37:26PM -0700, David Fetter wrote: > > On Sat, Jul 06, 2013 at 11:49:21AM +0100, Dean Rasheed wrote: > > > Overall I think this patch offers useful additional functionality, in > > &

[HACKERS] Re: FILTER for aggregates [was Re: Department of Redundancy Department: makeNode(FuncCall) division]

2013-07-14 Thread David Fetter
On Sun, Jul 14, 2013 at 10:15:12PM -0400, Noah Misch wrote: > On Sun, Jul 07, 2013 at 06:37:26PM -0700, David Fetter wrote: > > On Sat, Jul 06, 2013 at 11:49:21AM +0100, Dean Rasheed wrote: > > > Overall I think this patch offers useful additional functionality, in > > &

Re: [HACKERS] GSOC13 proposal - extend RETURNING syntax

2013-07-13 Thread David Fetter
d if the pointer > doesn't point to "unreserved" memory (I mean - memory which may be > overwritten by something meanwhile). Thanks for the updated patch! Anybody care to look this over for vulnerabilities as described above? Cheers, David. -- David Fetter http://fetter.org/ Phone:

Re: FILTER for aggregates [was Re: [HACKERS] Department of Redundancy Department: makeNode(FuncCall) division]

2013-07-07 Thread David Fetter
On Sat, Jul 06, 2013 at 11:49:21AM +0100, Dean Rasheed wrote: > On 5 July 2013 18:23, David Fetter wrote: > > Please find attached changes based on the above. > > > > This looks good. The grammar changes are smaller and neater now on top > of the makeFuncCall() patch. &

Re: [HACKERS] GSOC13 proposal - extend RETURNING syntax

2013-07-05 Thread David Fetter
re what may fail so you use it on your risk ;) > Regards, > Karol Karol, Per discussion in IRC, please follow up with your patch that includes such documentation, new regression tests, etc., you've written for the feature. Thanks! :) Cheers, David. -- David Fetter http://fetter.org/

Re: FILTER for aggregates [was Re: [HACKERS] Department of Redundancy Department: makeNode(FuncCall) division]

2013-07-05 Thread David Fetter
On Mon, Jul 01, 2013 at 05:30:38PM +0100, Dean Rasheed wrote: > On 1 July 2013 01:44, David Fetter wrote: > > On Fri, Jun 28, 2013 at 09:22:52PM +0100, Dean Rasheed wrote: > >> On 21 June 2013 06:16, David Fetter wrote: > >> > Please find attached a patch which a

Re: [HACKERS] Review: UNNEST (and other functions) WITH ORDINALITY

2013-07-05 Thread David Fetter
orry for the noise. If I had a nickel for every apparent failure of this nature, I'd never need to work again. Thanks for checking :) Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gma

Re: [HACKERS] Custom gucs visibility

2013-07-02 Thread David Fetter
GUC to be > printed would be more misleading than helpful. How about printing them with something along the lines of, "Please load extension foobar for details" or (less informative, but possibly easier to code) "libfoobar.so not loaded." ? Cheers, David. -- David Fetter http

Re: [HACKERS] Randomisation for ensuring nlogn complexity in quicksort

2013-07-01 Thread David Fetter
r people can see what you're talking about and actually help. Cheers, David. -- David Fetter 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] Documentation/help for materialized and recursive views

2013-07-01 Thread David Fetter
On Mon, Jul 01, 2013 at 10:52:55AM -0400, Peter Eisentraut wrote: > On 7/1/13 10:20 AM, David Fetter wrote: > > On Mon, Jul 01, 2013 at 10:05:24AM -0400, Peter Eisentraut wrote: > >> On 6/28/13 2:27 PM, David Fetter wrote: > >>>> You can run \! man from within psq

Re: [HACKERS] Documentation/help for materialized and recursive views

2013-07-01 Thread David Fetter
On Mon, Jul 01, 2013 at 10:05:24AM -0400, Peter Eisentraut wrote: > On 6/28/13 2:27 PM, David Fetter wrote: > >> You can run \! man from within psql, > > And if you're on Windows, you're Sadly Out of Luck with that. Is > > there an equivalent we could #ifdef in

Re: [HACKERS] New regression test time

2013-07-01 Thread David Fetter
hat tests only routinely get run by our CI system--currently the buildfarm--and which ones developers could reasonably be expected to wait until post-push to run in day-to-day development. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Sk

Re: [HACKERS] Department of Redundancy Department: makeNode(FuncCall) division

2013-06-30 Thread David Fetter
On Fri, Jun 28, 2013 at 01:28:35PM -0400, Peter Eisentraut wrote: > On 6/28/13 11:30 AM, Robert Haas wrote: > > On Fri, Jun 28, 2013 at 10:31 AM, Tom Lane wrote: > >> David Fetter writes: > >>> Please find attached the latest patch. > >> > >> I

Re: FILTER for aggregates [was Re: [HACKERS] Department of Redundancy Department: makeNode(FuncCall) division]

2013-06-30 Thread David Fetter
On Fri, Jun 28, 2013 at 09:22:52PM +0100, Dean Rasheed wrote: > On 21 June 2013 06:16, David Fetter wrote: > > Please find attached a patch which allows subqueries in the FILTER > > clause and adds regression testing for same. > > > > This needs re-basing/merging follo

Re: [HACKERS] Documentation/help for materialized and recursive views

2013-06-28 Thread David Fetter
quot;\h CREATE VIEW" in psql, which was the > >> case where it was brought to my attention. > > > > Maybe \h should somehow display the "see also" section? > > You can run \! man from within psql, And if you're on Windows, you're Sadly Out of Luck

Re: [HACKERS] Department of Redundancy Department: makeNode(FuncCall) division

2013-06-28 Thread David Fetter
On Fri, Jun 28, 2013 at 10:31:16AM -0400, Tom Lane wrote: > David Fetter writes: > > Please find attached the latest patch. > > I remain of the opinion that this is simply a bad idea. It is unlike > our habits for constructing other types of nodes, and makes it harder > n

Re: [HACKERS] Department of Redundancy Department: makeNode(FuncCall) division

2013-06-28 Thread David Fetter
makeSimpleA_Expr(AEXPR_OP, "~~", $1, > (Node *) n, @2); > ! > > Changes required from author: > === > It will be good if you remove unrelated changes from the patch and possibly > all > white-space errors. > > Thanks Thanks for the review! Please fin

[HACKERS] Re: FILTER for aggregates [was Re: Department of Redundancy Department: makeNode(FuncCall) division]

2013-06-27 Thread David Fetter
in. Is there some code I can look at? I still submit that having our reserved word ducks in a row in advance is a saner way to go about this, and will work up a patch for that as I have time. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfette

Re: [HACKERS] Kudos for Reviewers -- straw poll

2013-06-25 Thread David Fetter
tions are high, especially when it's not stuff like covering their expenses. http://www.iew.uzh.ch/wp/iewwp007.pdf Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal

Re: FILTER for aggregates [was Re: [HACKERS] Department of Redundancy Department: makeNode(FuncCall) division]

2013-06-23 Thread David Fetter
n if by some magic we manage to unreserve the words? > This also helps keep down the size of the generated parse tables, > doesn't it? Could well. I suspect we may need to rethink the whole way we do grammar at some point, but that's for a later discussion when I (or someone el

Re: Review [was Re: [HACKERS] MD5 aggregate]

2013-06-21 Thread David Fetter
On Fri, Jun 21, 2013 at 10:48:35AM -0700, David Fetter wrote: > On Mon, Jun 17, 2013 at 11:34:52AM +0100, Dean Rasheed wrote: > > On 15 June 2013 10:22, Dean Rasheed wrote: > > > There seem to be 2 separate directions that this could go, which > > > really

Review [was Re: [HACKERS] MD5 aggregate]

2013-06-21 Thread David Fetter
ing review: Does it follow the project coding guidelines? Yes. Are there portability issues? Not that I can see. Will it work on Windows/BSD etc? Not yet tested. Are the comments sufficient and accurate? Yes. Does it do what it says, corre

Re: FILTER for aggregates [was Re: [HACKERS] Department of Redundancy Department: makeNode(FuncCall) division]

2013-06-20 Thread David Fetter
On Fri, Jun 21, 2013 at 12:10:25AM -0400, Alvaro Herrera wrote: > David Fetter escribió: > > On Thu, Jun 20, 2013 at 08:59:27PM +0100, Dean Rasheed wrote: > > > > In my testing of sub-queries in the FILTER clause (an extension to the > > > spec), I was able

Re: FILTER for aggregates [was Re: [HACKERS] Department of Redundancy Department: makeNode(FuncCall) division]

2013-06-20 Thread David Fetter
On Fri, Jun 21, 2013 at 12:10:25AM -0400, Alvaro Herrera wrote: > David Fetter escribió: > > On Thu, Jun 20, 2013 at 08:59:27PM +0100, Dean Rasheed wrote: > > > > In my testing of sub-queries in the FILTER clause (an extension > > > to the spec), I was able

Re: FILTER for aggregates [was Re: [HACKERS] Department of Redundancy Department: makeNode(FuncCall) division]

2013-06-20 Thread David Fetter
On Thu, Jun 20, 2013 at 08:59:27PM +0100, Dean Rasheed wrote: > On 17 June 2013 06:36, David Fetter wrote: > >> > > Please find attached two versions of a patch which provides optional > >> > > FILTER clause for aggregates (T612, "Advanced OLAP operat

Re: [HACKERS] Department of Redundancy Department: makeNode(FuncCall) division

2013-06-16 Thread David Fetter
On Mon, Feb 11, 2013 at 10:48:38AM -0800, David Fetter wrote: > On Sun, Feb 10, 2013 at 10:09:19AM -0500, Tom Lane wrote: > > David Fetter writes: > > > Per suggestions and lots of help from Andrew Gierth, please find > > > attached a patch to clean up the call site

Re: FILTER for aggregates [was Re: [HACKERS] Department of Redundancy Department: makeNode(FuncCall) division]

2013-06-16 Thread David Fetter
On Sun, Apr 28, 2013 at 01:29:41PM -0700, David Fetter wrote: > On Tue, Feb 26, 2013 at 01:09:30PM -0800, David Fetter wrote: > > On Wed, Feb 13, 2013 at 06:45:31AM -0800, David Fetter wrote: > > > On Sat, Feb 09, 2013 at 11:59:22PM -0800, David Fetter wrote: > > > &g

Re: [HACKERS] request a new feature in fuzzystrmatch

2013-06-14 Thread David Fetter
On Fri, Jun 14, 2013 at 10:14:14AM -0700, Joshua D. Drake wrote: > On 06/14/2013 10:11 AM, David Fetter wrote: > > >>>ok, thanks, I will wait. > >>Hi Joe, > >> > >>Do you have some time in the weekend to help me submit the patch? > >>Thanks, &

Re: [HACKERS] request a new feature in fuzzystrmatch

2013-06-14 Thread David Fetter
least a couple of days > >> before I have the time to look at this, > >> > >> Joe > >> > >> > > ok, thanks, I will wait. > Hi Joe, > > Do you have some time in the weekend to help me submit the patch? > Thanks, > > Liming L

Re: [HACKERS] DO ... RETURNING

2013-06-11 Thread David Fetter
et do is in the realm of access control, e.g. allowing people to use DO rather than giving them DDL permission to create temporary functions. Is this what you have in mind? What other things? Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfett

Re: [HACKERS] DO ... RETURNING

2013-06-10 Thread David Fetter
proc; > ... > $$ LANGUAGE SQL; > > and you don't need to define output structure - what is much more user > friendly. If I understand the proposal correctly, the idea is only to try to return something when DO is invoked with RETURNING. 1. Did I understand correctly, Hannu? 2.

Re: [HACKERS] Logging of PAM Authentication Failure

2013-05-28 Thread David Fetter
thought though, as no fixed ordering could cover all cases. Maybe lines like local all postgres peer,md5 in pg_hba.conf would be the way to do this, where the list gets evaluated in the order it's read. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778

Re: [HACKERS] Planning incompatibilities for Postgres 10.0

2013-05-27 Thread David Fetter
not be necessary > when identifying a given major release, so I just didn't get the meaning of > what Craig said. As you say, you would still need the 2nd digit for minor > releases. What's been proposed before that wouldn't break previous applications is a numbering system like

Re: [HACKERS] request a new feature in fuzzystrmatch

2013-05-18 Thread David Fetter
i.postgresql.org/wiki/Working_with_Git Cheers, David (wondering whether we should provide specific instructions for github, bitbucket, etc.). -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://

Re: [HACKERS] PostgreSQL 9.3 beta breaks some extensions "make install"

2013-05-15 Thread David Fetter
problems. Would you be so kind as to point out same, or better still, to write up what you think of as a better example intended for the same audience? I'm sure the PGXN people would be delighted to put something better up there. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 4

Re: [HACKERS] fallocate / posix_fallocate for new WAL file creation (etc...)

2013-05-13 Thread David Fetter
new features like this go there. Please also to send along the tests you're doing so others can riff. Tests that find any weak points are also good. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: da

Re: [HACKERS] Proposal to add --single-row to psql

2013-05-11 Thread David Fetter
ad idea.) sketch of an idea: create an API to pass expression trees in and out. This could have other benefits as to clustering space, shortening the planning cycle, etc., but let's not go there for now. My knowledge is very, very sketchy, but when I squint, the expression trees we use look

Re: [HACKERS] Proposal to add --single-row to psql

2013-05-08 Thread David Fetter
ey'll just face a very large hurdle when it comes > to pulling that code back into their proprietary product. > > I don't know of any good way to solve that problem. Maybe it's not > worth solving... but I do suspect there's some useful stuff that the > comm

Re: [HACKERS] RETURNING syntax for COPY

2013-05-08 Thread David Fetter
re ones would depend on. Yes, it's possible (kinda) to do this with the FDW machinery, but the burden is much higher as it requires DDL permission in general each time. > so weighing it down with processing options seems like a pretty > dubious idea even if the implementation were eas

Re: [HACKERS] Documentation epub format

2013-05-02 Thread David Fetter
e, j’y crois) — je ne vous connais plus, vous n’êtes plus mon ami, vous n’êtes plus мой верный раб, comme vous dites. Ну, здравствуйте, здравствуйте. Je vois que je vous fais peur, садитесь и рассказывайте. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [HACKERS] GSOC13 proposal - extend RETURNING syntax

2013-05-02 Thread David Fetter
On Thu, May 02, 2013 at 01:40:59PM -0400, Tom Lane wrote: > David Fetter writes: > > On Thu, May 02, 2013 at 06:28:53PM +0200, Andres Freund wrote: > >> prior/after? Both are unreserved keywords atm and it seems far less > >> likely to have conflicts than new/old. >

Re: [HACKERS] GSOC13 proposal - extend RETURNING syntax

2013-05-02 Thread David Fetter
words both have meaning in, for example, a trigger definition, but they're clearly separable by context. Yay, bike-shedding! Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: web

Re: [HACKERS] GSOC13 proposal - extend RETURNING syntax

2013-05-02 Thread David Fetter
e characteristics as above, namely that it refers only to constants and columns in the updated table and not to everything available from the USING clause if included. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: dav

Re: [HACKERS] Re: [BUGS] BUG #8128: pg_dump (>= 9.1) failed while dumping a scheme named "old" from PostgreSQL 8.4

2013-05-01 Thread David Fetter
On Wed, May 01, 2013 at 11:12:28AM -0400, Tom Lane wrote: > David Fetter writes: > > According to SQL:2003 and SQL:2008 (and the draft standard, if > > that matters) in section 5.2 of Foundation, both NEW and OLD are > > reserved words, so we're going to need to re-

[HACKERS] Re: [BUGS] BUG #8128: pg_dump (>= 9.1) failed while dumping a scheme named "old" from PostgreSQL 8.4

2013-05-01 Thread David Fetter
n this. When we do re-reserve, we'll need to come up with a migration path. Cheers, David. -- David Fetter 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/peopl

Re: FILTER for aggregates [was Re: [HACKERS] Department of Redundancy Department: makeNode(FuncCall) division]

2013-04-28 Thread David Fetter
On Tue, Feb 26, 2013 at 01:09:30PM -0800, David Fetter wrote: > On Wed, Feb 13, 2013 at 06:45:31AM -0800, David Fetter wrote: > > On Sat, Feb 09, 2013 at 11:59:22PM -0800, David Fetter wrote: > > > Folks, > > > > > > Per suggestions and lots of help from Andre

Re: [HACKERS] Re: [COMMITTERS] pgsql: Fix collation assignment for aggregates with ORDER BY.

2013-04-26 Thread David Fetter
On Fri, Apr 26, 2013 at 05:52:03PM -0700, Jeff Davis wrote: > On Fri, 2013-04-26 at 16:46 -0700, David Fetter wrote: > > On Fri, Apr 26, 2013 at 07:49:47PM +, Tom Lane wrote: > > > Given this risk and the lack of field complaints about the issue, it > > > doesn&#

[HACKERS] Re: [COMMITTERS] pgsql: Fix collation assignment for aggregates with ORDER BY.

2013-04-26 Thread David Fetter
t seem prudent to back-patch. > > In passing, rearrange code in assign_collations_walker so that we don't > need multiple copies of the standard logic for computing collation of a > node with children. (Previously, CaseExpr duplicated the standard logic, > and we would have neede

Re: [HACKERS] Bug Fix: COLLATE with multiple ORDER BYs in aggregates

2013-04-25 Thread David Fetter
DER BY expression(s) ought to be considered independently > rather than as part of the agg's argument list. > > It looks like the proposed patch gets this right, but the proposed > test cases really fail to illuminate the problem IMO. > > regards, tom

Examples Re: [HACKERS] Bug Fix: COLLATE with multiple ORDER BYs in aggregates

2013-04-24 Thread David Fetter
On Tue, Apr 23, 2013 at 09:57:27AM -0700, David Fetter wrote: > Folks, > > While testing the upcoming FILTER clause for aggregates, Erik Rijkers > uncovered a long-standing bug in $subject, namely that this case > wasn't handled. Please find attached a patch by Andrew Giert

Re: [HACKERS] minimizing the target list for foreign data wrappers

2013-04-23 Thread David Fetter
t VAR has been > >> reduced by one because the 2 column is no longer there. > >> > >> I did something very much like this in my roll-your-own version of FDW so > >> I know basically how to do it, but I did it at the pre-planning stage and > >> I'm

[HACKERS] Bug Fix: COLLATE with multiple ORDER BYs in aggregates

2013-04-23 Thread David Fetter
fixed. Cheers, David. -- David Fetter 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 to vote! Consider donating to Postgres:

Re: [HACKERS] COPY and Volatile default expressions

2013-04-15 Thread David Fetter
On Mon, Apr 15, 2013 at 07:04:55PM +0100, Simon Riggs wrote: > On 15 April 2013 18:41, David Fetter wrote: > > > The difference between HEAD and patch in the "COPY, with sequence" > > case is pretty remarkable. What's the patch? > > Attached. Thanks!

Re: [HACKERS] COPY and Volatile default expressions

2013-04-15 Thread David Fetter
known > performance issues that I hope to cover later. Zero indexes is not > real, but we're trying to measure the effect and benefit of an > isolated change, so in this case it is appropriate. The difference between HEAD and patch in the "COPY, with sequence" case is p

Re: [HACKERS] COPY and Volatile default expressions

2013-04-15 Thread David Fetter
On Mon, Apr 15, 2013 at 05:04:16PM +0100, Simon Riggs wrote: > On 15 April 2013 16:55, Tom Lane wrote: > > Simon Riggs writes: > >> On 15 April 2013 16:24, David Fetter wrote: > >>> Do you have numbers on this, or ways to gather same? In other > >>>

Re: [HACKERS] COPY and Volatile default expressions

2013-04-15 Thread David Fetter
I'd like to do is to invent a new form of labelling that > > allows us to understand that COPY can still be optimised. > > And I don't want to invent impossible-to-verify function attributes > with such a tiny use-case as this. Are you referring to the Halting Problem? Cheer

Re: [HACKERS] WIP: index support for regexp search

2013-04-15 Thread David Fetter
ample in order to demonstrate it: > > Before the patch: > Buffers: shared hit=*857* > After the patch: > Buffers: shared hit=*497* Neato! Inside the patch, s/monotonous/monotone/, I think. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778

Re: [HACKERS] COPY and Volatile default expressions

2013-04-15 Thread David Fetter
ld mean we > don't have to invent new keywords every time we have a new function > label. > > Suggestions please. JSON's in core. How about using that? Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: da

Re: [HACKERS] [COMMITTERS] pgsql: Add parallel pg_dump option.

2013-03-29 Thread David Fetter
ome default like ./pg_dump when -j is specified. It could of course be overridden by -Fd. What say? Cheers, David. -- David Fetter 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/i

Re: FILTER for aggregates [was Re: [HACKERS] Department of Redundancy Department: makeNode(FuncCall) division]

2013-02-26 Thread David Fetter
On Wed, Feb 13, 2013 at 06:45:31AM -0800, David Fetter wrote: > On Sat, Feb 09, 2013 at 11:59:22PM -0800, David Fetter wrote: > > Folks, > > > > Per suggestions and lots of help from Andrew Gierth, please find > > attached a patch to clean up the call sites for FuncCal

Re: [HACKERS] Show type in psql SELECT

2013-02-23 Thread David Fetter
On Sat, Feb 23, 2013 at 12:07:35PM -0800, Jeff Janes wrote: > On Sat, Feb 23, 2013 at 9:55 AM, David Fetter wrote: > > On Sat, Feb 23, 2013 at 12:09:51PM +1300, Mike Toews wrote: > > > Hi hackers, > > > > > > Type info can be viewed with "\d mytable"

Re: [HACKERS] Show type in psql SELECT

2013-02-23 Thread David Fetter
we should add it as a SET parameter and expose it to all SQL. The next client program(s) shouldn't have to re-invent this separately. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmai

Re: [HACKERS] Materialized views WIP patch

2013-02-19 Thread David Fetter
ables. Have you considered this? I'm guessing it'd be .views if anything. Haven't been able to decipher from section 11 of the standard (Schemata) whether the standard has anything to say on the matter. Cheers, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 37

Re: FILTER for aggregates [was Re: [HACKERS] Department of Redundancy Department: makeNode(FuncCall) division]

2013-02-13 Thread David Fetter
On Wed, Feb 13, 2013 at 06:45:31AM -0800, David Fetter wrote: > On Sat, Feb 09, 2013 at 11:59:22PM -0800, David Fetter wrote: > > Folks, > > > > Per suggestions and lots of help from Andrew Gierth, please find > > attached a patch to clean up the call sites for FuncCal

Re: [HACKERS] Department of Redundancy Department: makeNode(FuncCall) division

2013-02-11 Thread David Fetter
On Sun, Feb 10, 2013 at 10:09:19AM -0500, Tom Lane wrote: > David Fetter writes: > > Per suggestions and lots of help from Andrew Gierth, please find > > attached a patch to clean up the call sites for FuncCall nodes, which > > I'd like to expand centrally rather tha

Re: [HACKERS] Department of Redundancy Department: makeNode(FuncCall) division

2013-02-10 Thread David Fetter
On Sun, Feb 10, 2013 at 10:09:19AM -0500, Tom Lane wrote: > David Fetter writes: > > Per suggestions and lots of help from Andrew Gierth, please find > > attached a patch to clean up the call sites for FuncCall nodes, which > > I'd like to expand centrally rather tha

[HACKERS] Department of Redundancy Department: makeNode(FuncCall) division

2013-02-09 Thread David Fetter
e part of the spec. Cheers, David. -- David Fetter 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 to vote! Consider donating to Post

Re: [HACKERS] LATERAL, UNNEST and spec compliance

2013-01-25 Thread David Fetter
On Thu, Jan 24, 2013 at 09:12:41PM -0800, David Fetter wrote: > On Thu, Jan 24, 2013 at 09:51:46AM -0800, David Fetter wrote: > > Folks, > > > > Andrew Gierth asked me to send this out as his email is in a parlous > > state at the moment. My comments will follow in re

Re: [HACKERS] .gitignore additions

2013-01-24 Thread David Fetter
t; > everything we list is a byproduct of a standard build, not some other tool. > > "man gitignore" says > > You can use .git/info/exclude for a personal per project setup, too. Added to http://wiki.postgresql.org/wiki/Working_with_Git Cheers, David. -- David Fetter h

[HACKERS] LATERAL, UNNEST and spec compliance

2013-01-24 Thread David Fetter
g code should be affected.) Since LATERAL is new in 9.3, I think the pros and cons of these choices should be considered now, rather than being allowed to slide by unexamined. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: dav

Re: [HACKERS] Patch: UNNEST (and other functions) WITH ORDINALITY

2013-01-23 Thread David Fetter
On Wed, Jan 23, 2013 at 02:40:45PM -0500, Bruce Momjian wrote: > On Wed, Jan 23, 2013 at 10:15:27AM -0800, David Fetter wrote: > > On Wed, Jan 23, 2013 at 03:12:37PM -0300, Alvaro Herrera wrote: > > > David Fetter wrote: > > > > On Tue, Jan 22, 2013 at 10:29:

Re: [HACKERS] Patch: UNNEST (and other functions) WITH ORDINALITY

2013-01-23 Thread David Fetter
On Wed, Jan 23, 2013 at 03:12:37PM -0300, Alvaro Herrera wrote: > David Fetter wrote: > > On Tue, Jan 22, 2013 at 10:29:43PM -0800, David Fetter wrote: > > > Folks, > > > > > > Please find attached a patch which implements the SQL standard > > > UN

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