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

2010-02-16 Thread Pavel Stehule
Hello I thinking about more restrictive query and expression checking than now. Used parser checking isn't enough - so some possible bugs can be detected in production stage. Other problem is using any expression as SELECT expr. The request on validation can be different and it is probably for

Re: [HACKERS] [GENERAL] libecpg versions and libecpg_compat

2010-02-16 Thread Boszormenyi Zoltan
Rob Newton írta: Hi Hackers, I posted this to the GENERAL list a while back, but got no repies. Perhaps someone here can help... I've been building ECPG (embedded SQL/C) programs on a system with Pg version 8.0 installed. When I tried to run them recently on version 8.4 I found that there

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

2010-02-16 Thread Joachim Wieland
On Tue, Feb 16, 2010 at 6:20 AM, Tom Lane t...@sss.pgh.pa.us wrote: Another possibility is to force a ProcessIncomingNotifies scan to occur before we reach ReadyForQuery if we sent any notifies in the just-finished transaction --- but that won't help if there are uncommitted messages in front

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

2010-02-16 Thread Jakub Ouhrabka
You might want to try setting log_autovacuum_min_duration=0 in the postgresql.conf Thanks, tried it. There is nothing in the log - the actual vacuum/analyze commands are not run (as there is no query activity). I suspect that autovacuum is checking each database if it should run - and

Re: [HACKERS] ToDo: preload for fulltext dictionary

2010-02-16 Thread Pavel Stehule
2010/2/16 Takahiro Itagaki itagaki.takah...@oss.ntt.co.jp: Pavel Stehule pavel.steh...@gmail.com wrote: The dictionary data could be shared or minimally dictionary could be preloaded like some PL language. What do you think about this? Surely preloading is the most realistic approach, but

[HACKERS] OpenVMS?

2010-02-16 Thread David Fetter
Folks, Would it be worthwhile to light up some buildfarm animals on OpenVMS? http://www.openvms.org/stories.php?story=10/02/09/2319162 Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP:

Re: [HACKERS] [GENERAL] libecpg versions and libecpg_compat

2010-02-16 Thread Michael Meskes
On Tue, Feb 16, 2010 at 09:44:26AM +1000, Rob Newton wrote: I posted this to the GENERAL list a while back, but got no repies. Perhaps someone here can help... Didn't see it there, sorry. Then I noticed libecpg_compat in the lib area. What is this used for? compat suggests compatibility

Re: [HACKERS] xpath improvement V2

2010-02-16 Thread Jan Urbański
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 Feedback on the 6th of

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

2010-02-16 Thread Fujii Masao
Hi, 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., SetTransactionIdLimit() is not called) until VACUUM is

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

2010-02-16 Thread Fujii Masao
On Tue, Feb 16, 2010 at 12:37 AM, Magnus Hagander mag...@hagander.net wrote: With the libpq fixes, I get further (more on that fix later, btw), but now I get stuck in this. When I do something on the master that generates WAL, such as insert a record, and then try to query this on the slave,

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

2010-02-16 Thread Magnus Hagander
2010/2/16 Fujii Masao masao.fu...@gmail.com: On Tue, Feb 16, 2010 at 12:37 AM, Magnus Hagander mag...@hagander.net wrote: With the libpq fixes, I get further (more on that fix later, btw), but now I get stuck in this. When I do something on the master that generates WAL, such as insert a

Re: [HACKERS] Explain buffers display units.

2010-02-16 Thread Greg Stark
On Tue, Feb 16, 2010 at 2:48 AM, Robert Haas robertmh...@gmail.com wrote:  Multiplying by the block size makes it sound as if all the memory was read or used, which is simply not the case - especially for things like buffer hits, which don't actually read or allocate any memory at all. In

Re: [HACKERS] NaN/Inf fix for ECPG

2010-02-16 Thread Boszormenyi Zoltan
Hi, buildfarm member pika fails the NaN test. Does FreeBSD/MIPS really return true for isinf(NaN)? Anyway, the attached patch tries to fix the test case by testing isnan() first and doesn't check isinf() if isnan() returned true. Best regards, Zoltán Böszörményi -- Bible has answers for

Re: [HACKERS] NaN/Inf fix for ECPG

2010-02-16 Thread Boszormenyi Zoltan
Boszormenyi Zoltan írta: Hi, buildfarm member pika fails the NaN test. Does FreeBSD/MIPS really return true for isinf(NaN)? Anyway, the attached patch tries to fix the test case by testing isnan() first and doesn't check isinf() if isnan() returned true. I lied in the patch name, it

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

2010-02-16 Thread Tim Bunce
On Mon, Feb 15, 2010 at 02:58:47PM -0800, David E. Wheeler wrote: On Feb 15, 2010, at 2:42 PM, Tim Bunce wrote: I've not really looked the the DBD::Pg code much so this seemed like a good excuse... It looks like the default is to call PQprepare() with paramTypes Oid values of 0. Yes,

[HACKERS] MIT Kerberos support in Windows builds

2010-02-16 Thread Dave Page
Just a heads-up really - following discussion with Magnus and other people involved in building our Windows packages, I intend to stop including MIT Kerberos support from 9.0 onwards. This is largely due to the fact that most (maybe all) users are more likely to use SSPI on Windows, and more

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

2010-02-16 Thread Kevin Grittner
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 traditional aspect of transactional integrity is that a transaction always sees *its own*

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

2010-02-16 Thread Fujii Masao
On Tue, Feb 16, 2010 at 7:20 PM, Magnus Hagander mag...@hagander.net wrote: 2010/2/16 Fujii Masao masao.fu...@gmail.com: On Tue, Feb 16, 2010 at 12:37 AM, Magnus Hagander mag...@hagander.net wrote: With the libpq fixes, I get further (more on that fix later, btw), but now I get stuck in

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

2010-02-16 Thread Hitoshi Harada
2010/2/16 Pavel Stehule pavel.steh...@gmail.com: 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? How do you identify them? Running function body

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

2010-02-16 Thread Joachim Wieland
On Tue, Feb 16, 2010 at 1:31 PM, Kevin Grittner kevin.gritt...@wicourts.gov 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 traditional

Re: [HACKERS] OpenVMS?

2010-02-16 Thread Andrew Dunstan
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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

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

2010-02-16 Thread Pavel Stehule
2010/2/16 Hitoshi Harada umi.tan...@gmail.com: 2010/2/16 Pavel Stehule pavel.steh...@gmail.com: 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] Re: [COMMITTERS] pgsql: Remove old-style VACUUM FULL (which was known for a little while

2010-02-16 Thread Bruce Momjian
Greg Smith wrote: If you think through the implications of that far enough, eventually you start to realize that you really can't even add a feature that requires an in-place upgrade hack to fix without first having the code that performs said hack done. Otherwise you're never completely

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

2010-02-16 Thread Alvaro Herrera
Fujii Masao escribió: Hi, 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., SetTransactionIdLimit()

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

2010-02-16 Thread Alvaro Herrera
Jakub Ouhrabka wrote: You might want to try setting log_autovacuum_min_duration=0 in the postgresql.conf Thanks, tried it. There is nothing in the log - the actual vacuum/analyze commands are not run (as there is no query activity). I suspect that autovacuum is checking each database if

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

2010-02-16 Thread Greg Stark
On Mon, Feb 15, 2010 at 7:51 PM, Jeroen Vermeulen j...@xs4all.nl wrote: AFAIC a statement could go to re-planning mode if the shortest execution time for the generic plan takes at least 10x longer than the longest planning time.  That gives us a decent shot at finding statements where

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

2010-02-16 Thread Greg Stark
On Mon, Feb 15, 2010 at 7:11 PM, Bruce Momjian br...@momjian.us 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 think of this

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

2010-02-16 Thread Pavel Stehule
Well using parameters will always have a better chance of producing a better plan but that's not the only factor people consider important. For a lot of users *predictability* is more important than absolute performance. If my web server could run 10% faster that might be nice but if it's

Re: [HACKERS] Explain buffers display units.

2010-02-16 Thread Alvaro Herrera
Greg Stark escribió: On Tue, Feb 16, 2010 at 2:48 AM, Robert Haas robertmh...@gmail.com wrote: Upon further review, I also notice that this patch seems to have falsified the EXPLAIN documentation - both the description of the BUFFERS option and the description of the FORMAT option are no

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

2010-02-16 Thread Euler Taveira de Oliveira
Jakub Ouhrabka escreveu: These databases are archive databases, so there is no user activity - no connected users. But the stats collector generates load - 20-40% of modern 2.8GHz core all the time. Did you try to set stats_temp_directory in a RAM based filesystem? Any clues what does it

Re: [HACKERS] OpenVMS?

2010-02-16 Thread Tom Lane
David Fetter da...@fetter.org writes: Would it be worthwhile to light up some buildfarm animals on OpenVMS? Have we ever even claimed to support VMS? I have no particular desire to undertake a major new porting effort. regards, tom lane -- Sent via pgsql-hackers

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

2010-02-16 Thread Greg Stark
On Tue, Feb 16, 2010 at 2:04 PM, Bruce Momjian br...@momjian.us 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 the same

[HACKERS] 9.0 - core dump - plpgsql - #option dump

2010-02-16 Thread Pavel Stehule
Hello Server crash on code postgres=# create or replace function f() returns void as $$#option dump begin for i in 1..10 loop raise notice '%', i; end loop; return; end $$ language plpgsql; server closed the connection unexpectedly This probably means the server terminated abnormally

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

2010-02-16 Thread Bruce Momjian
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 (name);

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

2010-02-16 Thread Tom Lane
Joachim Wieland j...@mcknight.de writes: On Tue, Feb 16, 2010 at 1:31 PM, Kevin Grittner kevin.gritt...@wicourts.gov 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

[HACKERS] auto_explain causes regression failures

2010-02-16 Thread Andrew Dunstan
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] ToDo: plpgsql plugin for query and expression verification

2010-02-16 Thread Tom Lane
Pavel Stehule pavel.steh...@gmail.com 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

Re: [HACKERS] psycopg2 license changed

2010-02-16 Thread Bruce Momjian
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 +

Re: [HACKERS] Explain buffers display units.

2010-02-16 Thread Tom Lane
Alvaro Herrera alvhe...@commandprompt.com 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

Re: [HACKERS] psycopg2 license changed

2010-02-16 Thread Bruce Momjian
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 permission to

Re: [HACKERS] OpenVMS?

2010-02-16 Thread Marc G. Fournier
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 da...@fetter.org writes: Would it be worthwhile to light up some buildfarm animals on OpenVMS? Have we ever even

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

2010-02-16 Thread Hitoshi Harada
2010/2/16 Pavel Stehule pavel.steh...@gmail.com: 2010/2/16 Hitoshi Harada umi.tan...@gmail.com: 2010/2/16 Pavel Stehule pavel.steh...@gmail.com: 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

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

2010-02-16 Thread Tom Lane
Alvaro Herrera alvhe...@commandprompt.com 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

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

2010-02-16 Thread Greg Sabino Mullane
-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] ToDo: plpgsql plugin for query and expression verification

2010-02-16 Thread Pavel Stehule
2010/2/16 Tom Lane t...@sss.pgh.pa.us: Pavel Stehule pavel.steh...@gmail.com 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

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

2010-02-16 Thread Bruce Momjian
Tom Lane wrote: Robert Haas robertmh...@gmail.com 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

Re: [HACKERS] OpenVMS?

2010-02-16 Thread David Fetter
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's what I sent them:

Re: [HACKERS] Explain buffers display units.

2010-02-16 Thread Greg Stark
On Tue, Feb 16, 2010 at 3:54 PM, Tom Lane t...@sss.pgh.pa.us wrote: Alvaro Herrera alvhe...@commandprompt.com 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

Re: [HACKERS] buildfarm breakage

2010-02-16 Thread Bruce Momjian
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 different

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

2010-02-16 Thread David E. Wheeler
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 docs (as

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

2010-02-16 Thread Martijn van Oosterhout
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 that? My

Re: [HACKERS] OpenVMS?

2010-02-16 Thread Rayson Ho
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 in

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

2010-02-16 Thread Richard Huxton
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

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

2010-02-16 Thread David E. Wheeler
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_path in

Re: [HACKERS] OpenVMS?

2010-02-16 Thread David Fetter
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 to the HP

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

2010-02-16 Thread Richard Huxton
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 that in

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

2010-02-16 Thread Alvaro Herrera
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 Procedure? Yes. Hmm -

Re: [HACKERS] XQuery support

2010-02-16 Thread Matthias Brantner
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 XQuery

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

2010-02-16 Thread Jeff Davis
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 of cache

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

2010-02-16 Thread Jeff Davis
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

Re: [HACKERS] NaN/Inf fix for ECPG

2010-02-16 Thread Michael Meskes
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

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

2010-02-16 Thread Jakub Ouhrabka
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] Problem with 8.4 stats collector high load

2010-02-16 Thread Alvaro Herrera
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 strace output and

Re: [HACKERS] NaN/Inf fix for ECPG

2010-02-16 Thread Boszormenyi Zoltan
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 I

Re: [HACKERS] Streaming Replication on win32

2010-02-16 Thread Magnus Hagander
2010/2/16 Fujii Masao masao.fu...@gmail.com: On Tue, Feb 16, 2010 at 1:33 AM, Magnus Hagander mag...@hagander.net wrote: 2010/2/15 Tom Lane t...@sss.pgh.pa.us: Magnus Hagander mag...@hagander.net writes: I changed your patch to this, because I find it a lot simpler. The change is in the

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

2010-02-16 Thread Merlin Moncure
On Tue, Feb 16, 2010 at 10:38 AM, Tom Lane t...@sss.pgh.pa.us 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

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

2010-02-16 Thread Jakub Ouhrabka
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. Am

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

2010-02-16 Thread Alvaro Herrera
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().

[HACKERS]

2010-02-16 Thread Kevin Ar18
_ Hotmail: Trusted email with powerful SPAM protection. http://clk.atdmt.com/GBL/go/201469227/direct/01/

Re: [HACKERS] OpenVMS?

2010-02-16 Thread Dann Corbit
-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 11:22

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

2010-02-16 Thread Bruce Momjian
Greg Stark wrote: On Mon, Feb 15, 2010 at 7:11 PM, Bruce Momjian br...@momjian.us 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

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

2010-02-16 Thread Bruce Momjian
Greg Stark wrote: On Tue, Feb 16, 2010 at 2:04 PM, Bruce Momjian br...@momjian.us 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

Re: [HACKERS] OpenVMS?

2010-02-16 Thread Bruce Momjian
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 use

Re: [HACKERS] OpenVMS?

2010-02-16 Thread Rayson Ho
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?

2010-02-16 Thread Marc G. Fournier
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

Re: [HACKERS] OpenVMS?

2010-02-16 Thread Bruce Momjian
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 impact on

[HACKERS]

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

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

2010-02-16 Thread Bruce Momjian
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 Network by

Re: [HACKERS] OpenVMS?

2010-02-16 Thread Andrew Chernow
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

Re: [HACKERS] OpenVMS?

2010-02-16 Thread Joshua D. Drake
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 dedicating their

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

2010-02-16 Thread Bruce Momjian
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 commandSELECT/command or

Re: [HACKERS] OpenVMS?

2010-02-16 Thread Robert Doerfler
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] psql 8.4 \c repeats version banner

2010-02-16 Thread Bruce Momjian
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) You are now

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

2010-02-16 Thread Tom Lane
Jeff Davis pg...@j-davis.com 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

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

2010-02-16 Thread Tom Lane
Merlin Moncure mmonc...@gmail.com writes: On Tue, Feb 16, 2010 at 10:38 AM, Tom Lane t...@sss.pgh.pa.us 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

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

2010-02-16 Thread Bruce Momjian
Applied. --- Bruce Momjian wrote: Guy Rouillier wrote: On 1/6/2010 3:29 PM, Tom Lane wrote: Guy Rouillierguyr-...@burntmail.com writes: Oracle states clearly in the SQL Reference manual: A modifier can

Re: [HACKERS] OpenVMS?

2010-02-16 Thread Chris Browne
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. Because someone feels

Re: [HACKERS] OpenVMS?

2010-02-16 Thread Chris Browne
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 would

Re: [HACKERS] NaN/Inf fix for ECPG

2010-02-16 Thread Michael Meskes
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] Streaming replication on win32, still broken

2010-02-16 Thread Magnus Hagander
2010/2/16 Fujii Masao masao.fu...@gmail.com: On Tue, Feb 16, 2010 at 7:20 PM, Magnus Hagander mag...@hagander.net wrote: 2010/2/16 Fujii Masao masao.fu...@gmail.com: On Tue, Feb 16, 2010 at 12:37 AM, Magnus Hagander mag...@hagander.net wrote: With the libpq fixes, I get further (more on that

Re: [HACKERS] log_error_verbosity placement

2010-02-16 Thread Bruce Momjian
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] CommitFest Status Summary - 2010-02-14

2010-02-16 Thread Andrew Dunstan
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

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

2010-02-16 Thread Tim Bunce
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()'

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

2010-02-16 Thread David E. Wheeler
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 the

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

2010-02-16 Thread Tim Bunce
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 namespace and Safe

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

2010-02-16 Thread David E. Wheeler
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. I

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

2010-02-16 Thread Robert Haas
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

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

2010-02-16 Thread Tom Lane
Joachim Wieland j...@mcknight.de 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

Re: [HACKERS] OpenVMS?

2010-02-16 Thread Tom Lane
Bruce Momjian br...@momjian.us 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 ... ?

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

2010-02-16 Thread David E. Wheeler
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

  1   2   >