Re: [pgsql-advocacy] [HACKERS] PostgreSQL Anniversary Proposals --Important Update

2006-03-20 Thread Dave Page
-Original Message- From: Devrim GUNDUZ [mailto:[EMAIL PROTECTED] Sent: 19 March 2006 23:08 To: Josh Berkus Cc: [EMAIL PROTECTED]; Dave Page; pgsql-hackers@postgresql.org Subject: Re: [pgsql-advocacy] [HACKERS] PostgreSQL Anniversary Proposals --Important Update Hi, On

Re: [pgsql-advocacy] [HACKERS] PostgreSQL Anniversary Proposals --Important Update

2006-03-20 Thread Magnus Hagander
Well, aside from anything else, we seem likely to have you, Devrim, Magnus and maybe even Robert Treat there (Robert?). Which would mean a good time for a meeting of the Web Team, yes? It seems that I'll be there, and yes, a PostgreSQL.org web development session will be

Re: [pgsql-advocacy] [HACKERS] PostgreSQL Anniversary Proposals --Important Update

2006-03-20 Thread Dave Page
-Original Message- From: Magnus Hagander [mailto:[EMAIL PROTECTED] Sent: 20 March 2006 08:31 To: Dave Page; Devrim GUNDUZ; Josh Berkus Cc: [EMAIL PROTECTED]; pgsql-hackers@postgresql.org Subject: RE: [pgsql-advocacy] [HACKERS] PostgreSQL Anniversary Proposals --Important Update

[HACKERS] Question about MemoryContexts and functions that returns sets.

2006-03-20 Thread Thomas Hallgren
Hi, A PL/Java user reports that his backend runs out of memory when he uses PL/Java to execute huge queries towards a remote database and return the result. PL/Java is designed not to collect data in memory when it returns result sets. Each call to the function handler will be dispatched to

Re: [HACKERS] Question about MemoryContexts and functions that returns sets.

2006-03-20 Thread Martijn van Oosterhout
On Mon, Mar 20, 2006 at 11:47:41AM +0100, Thomas Hallgren wrote: Hi, A PL/Java user reports that his backend runs out of memory when he uses PL/Java to execute huge queries towards a remote database and return the result. PL/Java is designed not to collect data in memory when it returns

Re: [HACKERS] Question about MemoryContexts and functions that returns

2006-03-20 Thread Thomas Hallgren
Martijn van Oosterhout wrote: On Mon, Mar 20, 2006 at 11:47:41AM +0100, Thomas Hallgren wrote: Hi, A PL/Java user reports that his backend runs out of memory when he uses PL/Java to execute huge queries towards a remote database and return the result. PL/Java is designed not to collect

Re: [pgsql-advocacy] [HACKERS] PostgreSQL Anniversary Proposals --Important Update

2006-03-20 Thread Robert Treat
On Monday 20 March 2006 03:31, Magnus Hagander wrote: Well, aside from anything else, we seem likely to have you, Devrim, Magnus and maybe even Robert Treat there (Robert?). Which would mean a good time for a meeting of the Web Team, yes? It seems that I'll be

Re: [HACKERS] Question about MemoryContexts and functions that returns sets.

2006-03-20 Thread Martijn van Oosterhout
On Mon, Mar 20, 2006 at 12:36:58PM +0100, Thomas Hallgren wrote: The function in question uses the SRF_ family of macros. I'm always returning datums allocated in the context that was current when the function was callled. But, hrrm. I see that I use the durable 'multi_call_memory_ctx'

Re: [HACKERS] PostgreSQL Anniversary Proposals -- Important Update

2006-03-20 Thread Jim C. Nasby
On Sat, Mar 18, 2006 at 12:38:30PM -0500, Rod Taylor wrote: One example might be a 'self-aggregating' structure. Start with one entry per minute in a table indexed by time. After 2 weeks passes, the per-minute data is aggregated and the single entry at the start of the day is updated with the

Re: [pgsql-advocacy] [HACKERS] PostgreSQL Anniversary Proposals --Important

2006-03-20 Thread Josh Berkus
Dave, That sounds like my only other idea so far - a discussion on allowing clients to modify the config files remotely :-). Actually, I'd be very into this as part of the Configurator project. Wether we discuss it at the Anniversary or not. --Josh ---(end of

Re: [pgsql-advocacy] [HACKERS] PostgreSQL Anniversary Proposals --Important

2006-03-20 Thread Josh Berkus
Robert, It should be easy once we we're finished discussing which CMS to port the website to. :-P smirkSlashcode./smirk --Josh ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?

Re: [pgsql-advocacy] [HACKERS] PostgreSQL Anniversary Proposals --Important

2006-03-20 Thread Josh Berkus
Dave, Chris, Can each of you submit a proposal around the web team meeting and the slony team meeting? I'd like to get them in the queue, so I don't forget in 2 weeks. [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: explain analyze is your

Re: [HACKERS] [PATCHES] PL/pgSQL: #option select_into_1_row (was SELECT INTO

2006-03-20 Thread Bruce Momjian
Matt Miller wrote: On Mon, 2005-08-08 at 17:18 -0400, Tom Lane wrote: If you think that this should be a global option instead of a per-statement one, something like the (undocumented) #option hack might be a good way to specify it; that would give it per-function scope, which seems

Re: [HACKERS] obtaining row locking information

2006-03-20 Thread Bruce Momjian
Tatsuo, have you developed a new version of this for 8.2? --- Tatsuo Ishii wrote: Tatsuo Ishii [EMAIL PROTECTED] writes: To accomplish this I need to add following function into storage/ipc/procarray.c. This is

Re: [HACKERS] [PATCHES] PL/pgSQL: #option select_into_1_row (was SELECT INTO

2006-03-20 Thread Tom Lane
Bruce Momjian pgman@candle.pha.pa.us writes: Are we agreed this is the way we want to control this? AFAICT, no one except Matt wants this feature at all, so I'd much prefer to drop the whole idea. I think it's a insufficiently justified kluge. regards, tom lane

Re: [HACKERS] [PATCHES] PL/pgSQL: #option select_into_1_row (was SELECT

2006-03-20 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian pgman@candle.pha.pa.us writes: Are we agreed this is the way we want to control this? AFAICT, no one except Matt wants this feature at all, so I'd much prefer to drop the whole idea. I think it's a insufficiently justified kluge. Fine. Unless I hear from the

Re: [HACKERS] SQL/XML extension

2006-03-20 Thread Bruce Momjian
Is there any more XML activity that people are working on this area? --- Djoerd Hiemstra wrote: Dear PostreSQL hackers, For the interested, here: http://www.cs.utwente.nl/~hiemstra/courses/reports/sqlxml.pdf you

Re: [HACKERS] SQL/XML extension

2006-03-20 Thread Pavel Stehule
Hello, This patch is well, I hope. I didn't look on it half year. Contains: SQL/XML support + doc by D.Fetter http://candle.pha.pa.us/mhonarc/patches_hold/msg00134.html regards Pavel Stehule _ Najdete si svou lasku a nove