Re: [HACKERS] Database owner installable modules patch

2008-04-06 Thread Tom Dunstan
On Mon, Apr 7, 2008 at 3:59 AM, Gregory Stark <[EMAIL PROTECTED]> wrote: > I wonder if there's much of a use case for any statements aside from CREATE > statements. If we restrict it to CREATE statements we could hack things to > create pg_depend entries automatically. In which case we wouldn't

Re: [HACKERS] [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)

2008-04-06 Thread Gurjeet Singh
On Sun, Sep 9, 2007 at 4:16 AM, apoc9009 <[EMAIL PROTECTED]> wrote: > > No! Actually I'm wearing my tin hat right now and I Never say Anything > > about My Suspicions about 9/11 on Internet in fear of Echelon catching > > and filing me. > > > > --- > > Hannu > > > hmm, a little bit Pa

Re: [HACKERS] Kludge in pg_standby.c

2008-04-06 Thread Magnus Hagander
no. I have been without a working win32 build environment for a while. Working on fixing that right now.. /Magnus > --- Original Message --- > From: Bruce Momjian <[EMAIL PROTECTED]> > To: Gregory Stark <[EMAIL PROTECTED]>, Magnus Hagander <[EMAIL PROTECTED]> > Sent: 08-04-07, 1:54:37 >

Re: [HACKERS] [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)

2008-04-06 Thread Tom Lane
"Kevin Grittner" <[EMAIL PROTECTED]> writes: > Attached is a version as good as I know how to get it. > It works for us, so barring any problems as we use it, I'm done. I finally got around to looking at this. Neither nor err() are portable (they're not in the Single Unix Spec, and they don't wo

Re: [HACKERS] Ordered Append Node

2008-04-06 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > I've been hacking on the idea of an Append node which maintains the ordering > of its subtables merging their records in order. I finally got round to looking at this ... > 1) I still haven't completely figured out what to do with equivalence classes. >

Re: [HACKERS] Kludge in pg_standby.c

2008-04-06 Thread Bruce Momjian
Magnus, have you looked at this yet? --- Gregory Stark wrote: > > There's a suspicious ifdef in pg_standby for WIN32 which smells like a kludge > added to work around a Windows problem which makes it work but at great > exp

Re: [HACKERS] New style of hash join proposal

2008-04-06 Thread Bruce Momjian
Gregory Stark wrote: > We currently execute a lot of joins as Nested Loops which would be more > efficient if we could batch together all the outer keys and execute a single > inner bitmap index scan for all of them together. > > Essentially what I'm saying is that we're missing a trick with Hash

Re: [HACKERS] Oracle FOR-over-cursor vs WHERE CURRENT OF?

2008-04-06 Thread Tom Lane
I wrote: > I wonder whether anyone knows > if Oracle users expect this combination to work at all? Nevermind that ... I found an example of this in Oracle's own docs, so clearly it had better work. Patch applied with appropriate fixes. regards, tom lane -- Sent via pgsq

Re: [HACKERS] Database owner installable modules patch

2008-04-06 Thread Gregory Stark
"Tom Dunstan" <[EMAIL PROTECTED]> writes: > - I'd like to add pg_depend entries for stuff installed by the module > on the pd_module entry, so that you can't drop stuff required by the > module without uninstalling the module itself. There would have to be > either a function or more syntax to al

[HACKERS] Oracle FOR-over-cursor vs WHERE CURRENT OF?

2008-04-06 Thread Tom Lane
I'm working over Pavel's FOR-over-cursor patch: http://archives.postgresql.org/pgsql-patches/2007-12/msg1.php (Although I previously complained that this was a bit pointless, the argument that it's important for porting Oracle code won me over.) I noticed that because the patch uses the same

Re: [HACKERS] Adding pipelining support to set returning functions

2008-04-06 Thread Joe Conway
Hannu Krosing wrote: A question to all pg hackers Is anybody working on adding pipelining to set returning functions. Not as far as I know. How much effort would it take ? Where should I start digging ? I don't remember all the details, but I think the original SRF patch that I did was p

Re: [HACKERS] Adding pipelining support to set returning functions

2008-04-06 Thread David Fetter
On Sun, Apr 06, 2008 at 10:01:20AM +0300, Hannu Krosing wrote: > A question to all pg hackers > > Is anybody working on adding pipelining to set returning functions. > > How much effort would it take ? > > Where should I start digging ? > > BACKGROUND: > > AFAICS , currently set returning func

Re: [HACKERS] modules

2008-04-06 Thread Tino Wildenhain
Hi, D'Arcy J.M. Cain wrote: ... Yes but what I am suggesting goes beyond that. My idea is that there is a modules directory that contains a file for each installable module. This file would contain all the information about the module such as name, version, where to get the actual package, an

Re: [HACKERS] machine-dependent hash_any vs the regression tests

2008-04-06 Thread Gregory Stark
"Tom Lane" <[EMAIL PROTECTED]> writes: > SELECT dblink_get_connections(); >dblink_get_connections > > ! {dtest1,dtest3,dtest2} > (1 row) > > SELECT dblink_is_busy('dtest1'); > > and right offhand I can't think of a simple way to force those array > element

Re: [HACKERS] machine-dependent hash_any vs the regression tests

2008-04-06 Thread Kenneth Marshall
On Sat, Apr 05, 2008 at 05:57:35PM -0400, Tom Lane wrote: > So the proposed changes in hash_any make its hash values different > between big-endian and little-endian machines (at least for string keys; > for keys that are really arrays of int, I think the changes will > unify the behavior). This m

[HACKERS] Adding pipelining support to set returning functions

2008-04-06 Thread Hannu Krosing
A question to all pg hackers Is anybody working on adding pipelining to set returning functions. How much effort would it take ? Where should I start digging ? BACKGROUND: AFAICS , currently set returning functions materialise their results before returning, as seen by this simple test: hannu