Re: [HACKERS] NaN/Inf fix for ECPG

On Tue, Feb 16, 2010 at 10:28:00PM +0100, Michael Meskes wrote: > I was trying to stress the *beta* status. Maybe someone into NetBSD might be > interested in reporting this as a bug. At least it behaves different to all > other archs we have. Hmm, it seems the patch didn't work. Back to the dra

Re: [HACKERS] Problem with 8.4 stats collector high load

> This would guarantee that autovacuum is fired no later than > autovacuum_naptime after the condition for the run became true. Of course, this unfortunately not true... The guarantee is 1,5x autovacuum_naptime. But I'd be happy with it but I agree that's not what I'd as a user expect from this

Re: [HACKERS] Problem with 8.4 stats collector high load

> well, my current opinion is that we should spend some nonzero amount > of thought into figuring out what to do. I'd suggest to do it like this: Do autovac_refresh_stats() once per autovacuum_naptime/2 and share the result among all autovacuum workers. This would guarantee that autovacuum is

Re: [HACKERS] XQuery support

> I've been playing around with Zorba and xQilla today. I couldn't actually get > Zorba to build on my system. It looks like the two share a common (or > similar) C API though. Yes, Zorba and XQilla both implement the XQC API. It was developed by the Zorba and XQilla teams in a joint effort. The

Re: [HACKERS] XQuery support

> Well, maybe you can answer the questions I had last time I looked at it, > namely: > >> XQuery is a whole other question. Adding another library dependency is >> something we try to avoid. Zorba might work, >> but it appears to have its own impressive list of de

Re: [HACKERS] Streaming replication on win32, still broken

On Wed, Feb 17, 2010 at 3:27 PM, Tom Lane wrote: > Magnus Hagander writes: >> On Wed, Feb 17, 2010 at 06:55, Fujii Masao wrote: >>> 2. Straightforwardly observe the alignment rule. Since the received WAL >>>   data might start at the middle of WAL block, walreceiver needs to keep >>>   the last

Re: [HACKERS] Streaming replication on win32, still broken

On Wed, Feb 17, 2010 at 3:03 PM, Magnus Hagander wrote: > In that case, O_DIRECT would be counterproductive, no? It maps to > FILE_FLAG_NOI_BUFFERING, which makes sure it doesn't go into the > cache. So the read in the startup proc is actually guaranteed to > reuqire a physical read - of something

Re: [HACKERS] CommitFest Status Summary - 2010-02-14

Robert Haas writes: > * Fix large object support in pg_dump. I think this is just waiting > for a second opinion on whether the approach is correct. I've been > meaning to look at it, but haven't gotten enough round tuits; maybe > someone else would like to take a look? This is an open item, so

Re: [HACKERS] XQuery support

Scott Bailey writes: > If it were possible to drop the xerces dependency from Zorba and use > libxml2 for parsing, that would be a strong case for it. The other big > dependency for Zorba was ICU for converting character sets. I'm not > familiar with that part of Postgres. But it seems to me th

Re: [HACKERS] Streaming replication on win32, still broken

Magnus Hagander writes: > On Wed, Feb 17, 2010 at 06:55, Fujii Masao wrote: >> 2. Straightforwardly observe the alignment rule. Since the received WAL >>   data might start at the middle of WAL block, walreceiver needs to keep >>   the last half-written WAL block for alignment. OTOH since the rec

Re: [HACKERS] auto_explain causes regression failures

Takahiro Itagaki writes: > Thank you for the bug report. Auto_explan tries to explain the query > even if it is failed, but schema objects that are created in the same > transaction might not be available. "cache lookup failed" erros can be > avoided if auto_explain skips explaining queries in ab

Re: [HACKERS] XQuery support

Andrew Dunstan wrote: Matthias Brantner wrote: I know this has been discussed several times and it seems the conclusin was it's impossible if we would like to use existing XQuery external modules (some are by license reasons and some are by techinical reasons). So it seems the only way to sup

Re: [HACKERS] auto_explain causes regression failures

Andrew Dunstan writes: > I am getting regression failures on the rowtypes, transactions and > arrays tests. Diff file is attached. I'm going to look into it, but if > anyone has a good idea what's going on please speak up ASAP. And as for the transactions-test failures, a stack trace tells the

Re: [HACKERS] Streaming replication on win32, still broken

On Wed, Feb 17, 2010 at 06:55, Fujii Masao wrote: > On Wed, Feb 17, 2010 at 6:28 AM, Magnus Hagander wrote: >> If you send me your amazon id, I can get you premissions on my private >> image. I plan to clean it up and make it public, just haven't gotten >> around to it yet... > > Thanks for your

Re: [HACKERS] auto_explain causes regression failures

Andrew Dunstan writes: > I am getting regression failures on the rowtypes, transactions and > arrays tests. Diff file is attached. I'm going to look into it, but if > anyone has a good idea what's going on please speak up ASAP. Hmm. Didn't decipher the transactions-test failures yet, but the e

Re: [HACKERS] Streaming replication on win32, still broken

On Wed, Feb 17, 2010 at 6:28 AM, Magnus Hagander wrote: > If you send me your amazon id, I can get you premissions on my private > image. I plan to clean it up and make it public, just haven't gotten > around to it yet... Thanks for your concern! I'll send the ID when I complete the preparation.

[HACKERS] Re: [COMMITTERS] pgsql: Clean up package namespace use and use of Safe in plperl.

Tom Lane wrote: aduns...@postgresql.org (Andrew Dunstan) writes: Clean up package namespace use and use of Safe in plperl. According to buildfarm member kite, there is more than one spelling of the Perl warning message that was (randomly?) chosen for the test added here. I doubt it'

Re: [HACKERS] Listen / Notify - what to do when the queue is full

Simon Riggs writes: > * Don't really like pg_listening() as a name. Perhaps pg_listening_to() > or pg_listening_on() or pg_listening_for() or pg_listening_channels() or > pg_listen_channels() BTW, I used pg_listening_channels() for that. > * I think it's confusing that pg_notify is both a data s

Re: [HACKERS] auto_explain causes regression failures

Andrew Dunstan wrote: > With the following settings > > custom_variable_classes = 'auto_explain' > auto_explain.log_min_duration = 0 > auto_explain.log_format = 'xml' > auto_explain.log_analyze = on > auto_explain.log_verbose = on > shared_preload_libraries = 'auto_expla

Re: [HACKERS] bug? autovacuum is not launched even if autovacuum_freeze_max_age is reached

On Wed, Feb 17, 2010 at 12:12 PM, Tom Lane wrote: > Alvaro Herrera writes: >> Maybe check at backend startup whether the limit is valid, and call >> SetTransactionIdLimit if not? > > Actually, the intent was that that would get called during startup, > but it seems I forgot to actually plug that

Re: [HACKERS] [COMMITTERS] pgsql: Clean up package namespace use and use of Safe in plperl.

aduns...@postgresql.org (Andrew Dunstan) writes: > Clean up package namespace use and use of Safe in plperl. According to buildfarm member kite, there is more than one spelling of the Perl warning message that was (randomly?) chosen for the test added here. I doubt it's worth maintaining a varian

Re: [HACKERS] Tightening binary receive functions

On Nov 10, 2009, at 9:54 AM, Bruce Momjian wrote: > FYI, Heikki has fixed this bug and the fix will appear in Postgres 8.5. >> Heikki> Oops, you're right. The check is indeed confusing julian day >> Heikki> numbers, with epoch at 23th of Nov 4714 BC, with >> Heikki> postgres-reckoning day numbers

Re: [HACKERS] OpenVMS?

On Tue, Feb 16, 2010 at 1:02 PM, David Fetter wrote: > You clearly know vastly more than I do about this, and should lead this > effort :) I have been working on OpenVMS on and off for a few years, but I am sure a lot of people are more qualified than I am :) I guess I will create a page in the

Re: [HACKERS] Avoiding bad prepared-statement plans.

On Tue, Feb 16, 2010 at 8:17 PM, Bruce Momjian wrote: >> Incidentally, can you have two active anonymous portals at the same time? > > No, the first one is deleted when the second is created, i.e., our docs > have: > >        An unnamed prepared statement lasts only until the next Parse statement

Re: [HACKERS] bug? autovacuum is not launched even if autovacuum_freeze_max_age is reached

Alvaro Herrera writes: > Maybe check at backend startup whether the limit is valid, and call > SetTransactionIdLimit if not? Actually, the intent was that that would get called during startup, but it seems I forgot to actually plug that in :-(. Loose wires now reattached in the right places. Pl

Re: [HACKERS] xpath improvement V2

Jan Urbański wrote: Arie Bikker wrote: Hi all, I've combined the review suggestions of Jan Urbański, Scott Bailey, and others. This was a lot harder, then I had foreseen; and I took my time to do it the right way (hope you agree!). Hi, I see the patch has been marked as "Returned with Feedba

Re: [HACKERS] OpenVMS?

Josh Berkus writes: > In my 12 years on the PostgreSQL project, this is the 2nd time, ever, > I've heard a question about OpenVMS support. The previous time was in 2003. Well, a search of our archives for "OpenVMS" finds a few more, but it still looks like about one request a year. If we could

Re: [HACKERS] OpenVMS?

All, In my 12 years on the PostgreSQL project, this is the 2nd time, ever, I've heard a question about OpenVMS support. The previous time was in 2003. Maybe there's an untapped community out there, but personally I think we'd find more users on z/OS than on OpenVMS. --Josh Berkus -- Sent via

Re: [HACKERS] PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl

Martijn van Oosterhout writes: > On Tue, Feb 16, 2010 at 09:11:24AM -0800, David E. Wheeler wrote: >>> An extra source of puzzlement is that the oid of the 'unknown' type is >>> 705 not 0, and the unknown type isn't discussed in the docs (as far as I >>> could see). >> >> Yes, I noticed that, too

Re: [HACKERS] LISTEN/NOTIFY and notification timing guarantees

t...@sss.pgh.pa.us (Tom Lane) writes: > Merlin Moncure writes: >> On Tue, Feb 16, 2010 at 10:38 AM, Tom Lane wrote: >>> 2. Add an extra lock to serialize writers to the queue, so that messages >>> are guaranteed to be added to the queue in commit order.  As long as > >> fwiw, I think you're defin

Re: [HACKERS] XQuery support

Matthias Brantner wrote: I know this has been discussed several times and it seems the conclusin was it's impossible if we would like to use existing XQuery external modules (some are by license reasons and some are by techinical reasons). So it seems the only way to support XQuery is, develop

Re: [HACKERS] Problem with 8.4 stats collector high load

Tom Lane wrote: > Alvaro Herrera writes: > > Jakub Ouhrabka wrote: > >> Was autovacuum requesting to write this 20MB file 650x per minute? > > > Yes, exactly. > > > Ideally, autovacuum would only request a new copy of the file if the one > > it got was considerably out of date. Obviously a tent

Re: [HACKERS] Problem with 8.4 stats collector high load

Alvaro Herrera writes: > Jakub Ouhrabka wrote: >> Was autovacuum requesting to write this 20MB file 650x per minute? > Yes, exactly. > Ideally, autovacuum would only request a new copy of the file if the one > it got was considerably out of date. Obviously a tenth of a second is > not old enoug

Re: [HACKERS] PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl

On Feb 16, 2010, at 3:01 PM, Tom Lane wrote: > I think the reason the client-side docs recommend using zero is to avoid > having clients know about the unknown type explicitly (in particular, to > discourage people from hardwiring "705" into their code). AFAIR there's > not a lot of difference in

Re: [HACKERS] OpenVMS?

Bruce Momjian writes: > Marc G. Fournier wrote: >> On Tue, 16 Feb 2010, Bruce Momjian wrote: >>> I hate to pour cold water on this, but why is it worth adding support >>> for a platform that has such marginal usage. >> >> Because someone feels like dedicating their resources to it ... ? > Well,

Re: [HACKERS] Listen / Notify - what to do when the queue is full

Joachim Wieland writes: > [ listen/notify patch ] Applied after rather a lot of hacking. Aside from the issues previously raised, I changed the NOTIFY syntax to include a comma between channel name and payload. The submitted syntax with no comma looked odd to me, and it would have been a real n

Re: [HACKERS] CommitFest Status Summary - 2010-02-14

> It's certainly been an interesting introduction to PostgreSQL > development! Hopefully we haven't scared you off - your work is definitely very much appreciated (and I at least hope to see you back for 9.1)! ...Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To ma

Re: [HACKERS] CommitFest Status Summary - 2010-02-14

On Feb 16, 2010, at 2:19 PM, Tim Bunce wrote: > It's certainly been an interesting introduction to PostgreSQL development! "Interesting," eh? Look forward to your blog post about the experience. ;-P > Tim. > > p.s. One quick heads-up: David Wheeler has reported a possible issue > with Safe 2.21

Re: [HACKERS] CommitFest Status Summary - 2010-02-14

On Tue, Feb 16, 2010 at 04:42:29PM -0500, Andrew Dunstan wrote: > Tim Bunce wrote: > >On Sun, Feb 14, 2010 at 10:14:28PM -0500, Andrew Dunstan wrote: > >>Robert Haas wrote: > >>>We're down to 5 patches remaining, and 1 day remaining, so it's time > >>>to try to wrap things up. > >>> > >>>* Package

Re: [HACKERS] PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl

On Feb 16, 2010, at 2:06 PM, Tim Bunce wrote: >> I assume that type names can be omitted her, too, yes? > > No, it seems not. You have to either repeat the type name the right number > of times, or use '...', which simply duplicates the type name for you > behind the scenes. I'll clarify that in

Re: [HACKERS] PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl

On Tue, Feb 16, 2010 at 09:11:24AM -0800, David E. Wheeler wrote: > On Feb 16, 2010, at 4:08 AM, Tim Bunce wrote: > > From the docs: > > > Immediately after the function name, in parenthesis, a comma separated list > > of > > type names can be given. For example: > > > > 'pi()' > > 'gen

Re: [HACKERS] CommitFest Status Summary - 2010-02-14

Tim Bunce wrote: On Sun, Feb 14, 2010 at 10:14:28PM -0500, Andrew Dunstan wrote: Robert Haas wrote: We're down to 5 patches remaining, and 1 day remaining, so it's time to try to wrap things up. * Package namespace and Safe init cleanup for plperl. Andrew Dunstan is taking care of t

Re: [HACKERS] log_error_verbosity placement

Applied. --- Bruce Momjian wrote: > I just realized that log_error_verbosity is in the wrong section in > postgresql.conf and in our manual. It is listed under "When to log" > when in fact it should be in the "What to log"

Re: [HACKERS] Streaming replication on win32, still broken

2010/2/16 Fujii Masao : > On Tue, Feb 16, 2010 at 7:20 PM, Magnus Hagander wrote: >> 2010/2/16 Fujii Masao : >>> On Tue, Feb 16, 2010 at 12:37 AM, Magnus Hagander >>> wrote: With the libpq fixes, I get further (more on that fix later, btw), but now I get stuck in this. When I do someth

Re: [HACKERS] NaN/Inf fix for ECPG

> I realized my typo after sending my mail. Sorry if I offended anyone > calling NetBSD FreeBSD. :-) I was trying to stress the *beta* status. Maybe someone into NetBSD might be interested in reporting this as a bug. At least it behaves different to all other archs we have. Michael -- Michael

Re: [HACKERS] OpenVMS?

scra...@hub.org ("Marc G. Fournier") writes: > On Tue, 16 Feb 2010, Bruce Momjian wrote: > >> I hate to pour cold water on this, but why is it worth adding >> support for a platform that has such marginal usage. > > Because someone feels like dedicating their resources to it ... ? But adding it in

Re: [HACKERS] OpenVMS?

rocr...@gmx.de (Robert Doerfler) writes: > On Tue, 16 Feb 2010, Bruce Momjian wrote: > >> Marc G. Fournier wrote: >>> On Tue, 16 Feb 2010, Bruce Momjian wrote: >>> I hate to pour cold water on this, but why is it worth adding support for a platform that has such marginal usage. >>> >>> Be

Re: [HACKERS] Re: [GENERAL] FM format modifier does not remove leading zero from year

Applied. --- Bruce Momjian wrote: > Guy Rouillier wrote: > > On 1/6/2010 3:29 PM, Tom Lane wrote: > > > Guy Rouillier writes: > > >> Oracle states clearly in the SQL Reference manual: > > > > > >> "A modifier can appear in

Re: [HACKERS] LISTEN/NOTIFY and notification timing guarantees

Merlin Moncure writes: > On Tue, Feb 16, 2010 at 10:38 AM, Tom Lane wrote: >> 2. Add an extra lock to serialize writers to the queue, so that messages >> are guaranteed to be added to the queue in commit order.  As long as > fwiw, I think you're definitely on the right track. IMO, any scenario

Re: [HACKERS] LISTEN/NOTIFY and notification timing guarantees

Jeff Davis writes: > On Tue, 2010-02-16 at 10:38 -0500, Tom Lane wrote: >> 2. Add an extra lock to serialize writers to the queue, so that messages >> are guaranteed to be added to the queue in commit order. > I assume this is a heavyweight lock, correct? Yeah, that seems the easiest way to do i

Re: [HACKERS] psql 8.4 \c repeats version banner

Applied. --- Bruce Momjian wrote: > Peter Eisentraut wrote: > > In 8.3, running \c from a file prints something like > > > > You are now connected to database "postgres". > > > > In 8.4 it prints > > > > psql (8.4.1) > >

Re: [HACKERS] OpenVMS?

On Tue, 16 Feb 2010, Bruce Momjian wrote: Marc G. Fournier wrote: On Tue, 16 Feb 2010, Bruce Momjian wrote: I hate to pour cold water on this, but why is it worth adding support for a platform that has such marginal usage. Because someone feels like dedicating their resources to it ... ?

Re: [HACKERS] [PATCH] Provide rowcount for utility SELECTs

Applied. Thanks. --- Bruce Momjian wrote: > Boszormenyi Zoltan wrote: > > >>> Ah, I didn't even see that that section needed to be updated. Good > > >>> catch. I'd suggest the following wording: > > >>> > > >>> For a SELE

Re: [HACKERS] OpenVMS?

On Tue, 2010-02-16 at 15:47 -0500, Andrew Chernow wrote: > Marc G. Fournier wrote: > > On Tue, 16 Feb 2010, Bruce Momjian wrote: > > > >> I hate to pour cold water on this, but why is it worth adding support > >> for a platform that has such marginal usage. > > > > Because someone feels like ded

Re: [HACKERS] OpenVMS?

Marc G. Fournier wrote: On Tue, 16 Feb 2010, Bruce Momjian wrote: I hate to pour cold water on this, but why is it worth adding support for a platform that has such marginal usage. Because someone feels like dedicating their resources to it ... ? That's step one. Step two is community appr

Re: Looking for Bill Huang; was [HACKERS] Personal Copyright Notices

Bruce Momjian wrote: > Bruce Momjian wrote: > > Some more _personalized_ copyright noticed have crept into our source > > tree: > > > > /src/tutorial/basics.sourceCopyright (c) 1994, Andrew Yu, > > University of California > > /contrib/intagg/Makefile Copyright (c) 2001 Digital Music

[HACKERS]

_ Your E-mail and More On-the-Go. Get Windows Live Hotmail Free. http://clk.atdmt.com/GBL/go/201469229/direct/01/

Re: [HACKERS] OpenVMS?

Marc G. Fournier wrote: > On Tue, 16 Feb 2010, Bruce Momjian wrote: > > > I hate to pour cold water on this, but why is it worth adding support > > for a platform that has such marginal usage. > > Because someone feels like dedicating their resources to it ... ? Well, there is going to be impac

Re: [HACKERS] OpenVMS?

On Tue, 16 Feb 2010, Bruce Momjian wrote: I hate to pour cold water on this, but why is it worth adding support for a platform that has such marginal usage. Because someone feels like dedicating their resources to it ... ? Marc G. FournierHub.Org Hosting Solutions

Re: [HACKERS] OpenVMS?

On Tue, Feb 16, 2010 at 2:56 PM, Dann Corbit wrote: > For PostgreSQL, you will probably want to use LIB$SPAWN() as a rough > equivalent to CreateProcess() on Windows We will need to support running PostgreSQL as a detached process, and thus it won't have access to the DCL CLI. The implication is

Re: [HACKERS] OpenVMS?

Dann Corbit wrote: > > PostgreSQL uses fork(), which is not supported on OpenVMS. However, > > the techniques used by the WIN32 version of internal_forkexec() in > > src/backend/postmaster/postmaster.c give the VMS version a good > > starting point. > > For PostgreSQL, you will probably want to us

[HACKERS] Re: [COMMITTERS] pgsql: Remove old-style VACUUM FULL (which was known for a little while

Greg Stark wrote: > On Tue, Feb 16, 2010 at 2:04 PM, Bruce Momjian wrote: > > The MOVE_* bits go away after a while by vacuum and there is an easy > > solution for 9.1 --- vacuum everything in 9.0. ?Where things really get > > hard is when we have to support two page formats or two data formats in

Re: [HACKERS] Avoiding bad prepared-statement plans.

Greg Stark wrote: > On Mon, Feb 15, 2010 at 7:11 PM, Bruce Momjian wrote: > > 1. Why do we only do bind-level planning for anonymous wire-level queries? > > > > 2. I realize we did anonymous-only because that was the only way we had > > in the protocol to _signal_ bind-time planning, but didn't we

Re: [HACKERS] OpenVMS?

> -Original Message- > From: pgsql-hackers-ow...@postgresql.org [mailto:pgsql-hackers- > ow...@postgresql.org] On Behalf Of Rayson Ho > Sent: Tuesday, February 16, 2010 9:39 AM > To: David Fetter > Cc: Andrew Dunstan; PG Hackers > Subject: Re: [HACKERS] OpenVMS? > > On Tue, Feb 16, 2010 at

[HACKERS]

_ Hotmail: Trusted email with powerful SPAM protection. http://clk.atdmt.com/GBL/go/201469227/direct/01/

Re: [HACKERS] Problem with 8.4 stats collector high load

Jakub Ouhrabka wrote: > > Ideally, autovacuum would only request a new copy of the file if the > > one it got was considerably out of date. Obviously a tenth of a > > second is not old enough. > > I've tried to look at it and found that's already implemented - see > autovac_refresh_stats(). STATS

Re: [HACKERS] Problem with 8.4 stats collector high load

> Ideally, autovacuum would only request a new copy of the file if the > one it got was considerably out of date. Obviously a tenth of a > second is not old enough. I've tried to look at it and found that's already implemented - see autovac_refresh_stats(). STATS_READ_DELAY which is set to 1s.

Re: [HACKERS] LISTEN/NOTIFY and notification timing guarantees

On Tue, Feb 16, 2010 at 10:38 AM, Tom Lane wrote: > 2. Add an extra lock to serialize writers to the queue, so that messages > are guaranteed to be added to the queue in commit order.  As long as fwiw, I think you're definitely on the right track. IMO, any scenario where an issued notification e

Re: [HACKERS] Streaming Replication on win32

2010/2/16 Fujii Masao : > On Tue, Feb 16, 2010 at 1:33 AM, Magnus Hagander wrote: >> 2010/2/15 Tom Lane : >>> Magnus Hagander writes: I changed your patch to this, because I find it a lot simpler. The change is in the checking in pgwin32_recv - there is no need to ever call waitfor

Re: [HACKERS] NaN/Inf fix for ECPG

Michael Meskes írta: > On Tue, Feb 16, 2010 at 12:21:34PM +0100, Boszormenyi Zoltan wrote: > >>> Does FreeBSD/MIPS really return true for isinf(NaN)? >>> > > Actually it's a netbsd beta version, so maybe there's a bug in their libc. > I realized my typo after sending my mail. Sorry if

Re: [HACKERS] Problem with 8.4 stats collector high load

Jakub Ouhrabka wrote: > > Maybe you should decrease naptime a bit. > > That did the trick, thanks! > > > Yes. There were some changes that needed to be done to autovacuum so > > that it didn't read the stats file too often, but I don't recall if I > > got around to it. > > I looked at the strac

Re: [HACKERS] Problem with 8.4 stats collector high load

> Maybe you should decrease naptime a bit. That did the trick, thanks! > Yes. There were some changes that needed to be done to autovacuum so > that it didn't read the stats file too often, but I don't recall if I > got around to it. I looked at the strace output and there are *writes* to the

Re: [HACKERS] NaN/Inf fix for ECPG

On Tue, Feb 16, 2010 at 12:21:34PM +0100, Boszormenyi Zoltan wrote: > > Does FreeBSD/MIPS really return true for isinf(NaN)? Actually it's a netbsd beta version, so maybe there's a bug in their libc. But anyway, the patch doesn't seem to hurt, so I committed it. Michael -- Michael Meskes Micha

Re: [HACKERS] LISTEN/NOTIFY and notification timing guarantees

On Tue, 2010-02-16 at 10:38 -0500, Tom Lane wrote: > 2. Add an extra lock to serialize writers to the queue, so that messages > are guaranteed to be added to the queue in commit order. I assume this is a heavyweight lock, correct? Regards, Jeff Davis -- Sent via pgsql-hackers mailing l

Re: [HACKERS] Listen / Notify - what to do when the queue is full

On Tue, 2010-02-16 at 16:02 +, Greg Sabino Mullane wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: RIPEMD160 > > > > * We also discussed the idea of having a NOTIFY command that > > would work from Primary to Standby. > > Just curious, what's a use case for this? If you have some kind

Re: [HACKERS] XQuery support

>> I know this has been discussed several times and it seems the >> conclusin was it's impossible if we would like to use existing XQuery >> external modules (some are by license reasons and some are by >> techinical reasons). >> >> So it seems the only way to support XQuery is, developing our own

Re: [HACKERS] PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl

Richard Huxton wrote: > On 16/02/10 17:51, David E. Wheeler wrote: > >On Feb 16, 2010, at 9:43 AM, Richard Huxton wrote: > > > >>Perhaps it would be better to be explicit about what's going on? > >> SEARCHPATH->function() > >> SCHEMA('public')->function2() > >> > >>Or did "SP" mean "Stored Proced

Re: [HACKERS] PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl

On 16/02/10 17:51, David E. Wheeler wrote: On Feb 16, 2010, at 9:43 AM, Richard Huxton wrote: Perhaps it would be better to be explicit about what's going on? SEARCHPATH->function() SCHEMA('public')->function2() Or did "SP" mean "Stored Procedure"? Yes. Hmm - might be worth avoiding th

Re: [HACKERS] OpenVMS?

On Tue, Feb 16, 2010 at 12:39:29PM -0500, Rayson Ho wrote: > On Tue, Feb 16, 2010 at 11:22 AM, David Fetter wrote: > >    * Shell access from several accounts > >    * Git or cvs client > >    * Compiler tools > >    * Perl of a fairly recent vintage > >    * Outbound http access > > I had access

Re: [HACKERS] PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl

On Feb 16, 2010, at 9:43 AM, Richard Huxton wrote: > Perhaps it would be better to be explicit about what's going on? > SEARCHPATH->function() > SCHEMA('public')->function2() > > Or did "SP" mean "Stored Procedure"? Yes. > On a (kind of) related note, it might be worthwhile to mention search_

Re: [HACKERS] PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl

On 16/02/10 17:11, David E. Wheeler wrote: On Feb 16, 2010, at 4:08 AM, Tim Bunce wrote: Wouldn't work unless you'd installed an AUTOLOAD function into each schema:: package that you wanted to use. (schema->SP::function_name() could be made to work but that's just too bizzare :) Maybe SP->sc

Re: [HACKERS] OpenVMS?

On Tue, Feb 16, 2010 at 11:22 AM, David Fetter wrote: >    * Shell access from several accounts >    * Git or cvs client >    * Compiler tools >    * Perl of a fairly recent vintage >    * Outbound http access I had access to the HP testdrive before they closed it down (the Unix servers were down

Re: [HACKERS] PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl

On Tue, Feb 16, 2010 at 09:11:24AM -0800, David E. Wheeler wrote: > > An extra source of puzzlement is that the oid of the 'unknown' type is > > 705 not 0, and the unknown type isn't discussed in the docs (as far as I > > could see). > > Yes, I noticed that, too. Greg, do you know the answer to th

Re: [HACKERS] PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl

On Feb 16, 2010, at 4:08 AM, Tim Bunce wrote: >> Yes, IIRC, 0 == unknown as far as the server is concerned. It just >> tells the server to resolve it when it can. > > An extra source of puzzlement is that the oid of the 'unknown' type is > 705 not 0, and the unknown type isn't discussed in the do

Re: [HACKERS] buildfarm breakage

Zdenek Kotala wrote: > Andrew Dunstan p??e v po 08. 02. 2010 v 20:07 -0500: > > > > > Our Solaris *moth members seem to have stopped building. Have we lost them? > > Hi Andrew, > > The answer is not simple. Yes, we lost Solaris 8 and 9 machines which > was reinstalled and now they are used for

Re: [HACKERS] Explain buffers display units.

On Tue, Feb 16, 2010 at 3:54 PM, Tom Lane wrote: > Alvaro Herrera writes: >> Greg Stark escribió: >>> Oops. Well, I would like to know if I'm in the minority and have to >>> roll this back before I fix that. > >> My personal opinion is that displaying number of blocks in all EXPLAIN >> formats is

Re: [HACKERS] OpenVMS?

On Tue, Feb 16, 2010 at 08:11:15AM -0500, Andrew Dunstan wrote: > > > David Fetter wrote: > >Folks, > > > >Would it be worthwhile to light up some buildfarm animals on OpenVMS? > > > >http://www.openvms.org/stories.php?story=10/02/09/2319162 > > > > Sure, go for it. > > cheers > > andrew Here

Re: [HACKERS] CommitFest Status Summary - 2010-02-14

Tom Lane wrote: > Robert Haas writes: > > * Listen / Notify rewrite. This is the only one of the remaining > > patches that is not marked as Ready for Committer, but I think it > > would be good if someone (probably Tom) at least took a look at it. > > I'm not sure if it's committable at this poi

Re: [HACKERS] ToDo: plpgsql plugin for query and expression verification

2010/2/16 Tom Lane : > Pavel Stehule writes: >> I don't would to execute function - it is useless because you need >> good UI for execution all path. My idea is different. gram.y has >> check_sql_expr rutine. This is used for parser checking every static >> SQL fragment in plpgsql function. With s

Re: [HACKERS] Listen / Notify - what to do when the queue is full

-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > * We also discussed the idea of having a NOTIFY command that > would work from Primary to Standby. Just curious, what's a use case for this? - -- Greg Sabino Mullane g...@turnstep.com End Point Corporation http://www.endpoint.com/ PGP Key:

Re: [HACKERS] bug? autovacuum is not launched even if autovacuum_freeze_max_age is reached

Alvaro Herrera writes: > Fujii Masao escribió: >> In HEAD, when autovacuum is disabled, autovacuum process is not >> launched forcibly to prevent XID wraparound even if we go through >> autovacuum_freeze_max_age. This seems to be because >> ShmemVariableCache->xidVacLimit is not initialized (i.e.,

Re: [HACKERS] ToDo: plpgsql plugin for query and expression verification

2010/2/16 Pavel Stehule : > 2010/2/16 Hitoshi Harada : >> 2010/2/16 Pavel Stehule : >>> I think, so these problem have to be identified in compile stage - but >>> it can be too strict for all (and can slow down production) - it is >>> reason for plugin. >>> >>> What do you think about this idea? >>

Re: [HACKERS] OpenVMS?

It could be interesting to see how big a porting effort it was ... ? I'd say go for it and let's see what is involved ... On Tue, 16 Feb 2010, Tom Lane wrote: David Fetter writes: Would it be worthwhile to light up some buildfarm animals on OpenVMS? Have we ever even claimed to support VM

Re: [HACKERS] psycopg2 license changed

Greg Smith wrote: > Federico Di Gregorio wrote: > > Even if tests and examples code aren't almost never distributed except > > in the psycopg2 source package? A couple of other people contributed to > > the tests: if you really feel like it is so important I'll contact them > > and ask their permis

Re: [HACKERS] Explain buffers display units.

Alvaro Herrera writes: > Greg Stark escribió: >> Oops. Well, I would like to know if I'm in the minority and have to >> roll this back before I fix that. > My personal opinion is that displaying number of blocks in all EXPLAIN > formats is more consistent. FWIW, I vote for number of blocks too.

Re: [HACKERS] psycopg2 license changed

Federico Di Gregorio wrote: > Even if tests and examples code aren't almost never distributed except > in the psycopg2 source package? A couple of other people contributed to > the tests: if you really feel like it is so important I'll contact them > and ask their permission to use the LGPL3 + exce

Re: [HACKERS] ToDo: plpgsql plugin for query and expression verification

Pavel Stehule writes: > I don't would to execute function - it is useless because you need > good UI for execution all path. My idea is different. gram.y has > check_sql_expr rutine. This is used for parser checking every static > SQL fragment in plpgsql function. With some hook we can do full pla

[HACKERS] auto_explain causes regression failures

With the following settings custom_variable_classes = 'auto_explain' auto_explain.log_min_duration = 0 auto_explain.log_format = 'xml' auto_explain.log_analyze = on auto_explain.log_verbose = on shared_preload_libraries = 'auto_explain' I am getting regression failures on the

Re: [HACKERS] LISTEN/NOTIFY and notification timing guarantees

Joachim Wieland writes: > On Tue, Feb 16, 2010 at 1:31 PM, Kevin Grittner > wrote: >> Tom Lane  wrote: >>> We could adopt the historical policy of sending self-notifies >>> pre-commit, but that doesn't seem tremendously appetizing from the >>> standpoint of transactional integrity. >> >> But one

Re: [HACKERS] [GENERAL] possible bug with inheritance?

Bruce Momjian wrote: > For primary key, there is no enforcement of the primary key, e.g.: > > test=> CREATE TABLE parent (name TEXT); > CREATE TABLE > test=> CREATE TABLE child (age INT) inherits (parent) ; > CREATE TABLE > test=> ALTER TABLE parent ADD primary KEY (n

  1   2   >