Re: [HACKERS] ecpg compile error

2010-01-06 Thread Boszormenyi Zoltan
Bruce Momjian írta: Bruce Momjian wrote: I am seeing a compile failure in current CVS because my operating system, BSD/OS, does not have inttypes.h: ccache gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -fno-strict-aliasing -O1 -Wall -Wmissing-prototypes

Re: [HACKERS] Streaming replication and postmaster signaling

2010-01-06 Thread Heikki Linnakangas
Fujii Masao wrote: I've done that in my git branch. Could you push that git branch to a public place? Ahh, sorry, forgot that again. It's there now, at git://git.postgresql.org/git/users/heikki/postgres.git, branch 'replication'. -- Heikki Linnakangas EnterpriseDB

Re: [HACKERS] pg_migrator issues

2010-01-06 Thread decibel
On Jan 6, 2010, at 1:52 AM, decibel wrote: On Dec 30, 2009, at 9:50 PM, Bruce Momjian wrote: 3) There is no easy way to analyze all databases. vacuumdb --analyze does analyze _and_ vacuum, which for an 8.4 to 8.5 migration does an unnecessary vacuum. Right now I recommend ANALYZE in every

Re: [HACKERS] ecpg compile error

2010-01-06 Thread Boszormenyi Zoltan
Boszormenyi Zoltan írta: Bruce Momjian írta: Bruce Momjian wrote: I am seeing a compile failure in current CVS because my operating system, BSD/OS, does not have inttypes.h: ccache gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -fno-strict-aliasing -O1 -Wall

Re: [HACKERS] Streaming replication and postmaster signaling

2010-01-06 Thread Craig Ringer
Fujii Masao wrote: On Tue, Jan 5, 2010 at 11:29 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: This was probably discussed to death earlier, but: why was it decided to not simply use a different port for listening for walsender connections? I believe that using a different port would

Re: [HACKERS] Status of plperl inter-sp calling

2010-01-06 Thread Tim Bunce
On Tue, Jan 05, 2010 at 06:54:36PM -0500, Tom Lane wrote: Tim Bunce tim.bu...@pobox.com writes: On Thu, Dec 31, 2009 at 09:47:24AM -0800, David E. Wheeler wrote: Definite benefit, there. How does it handle the difference between IMMUTABLE | STABLE | VOLATILE, as well as STRICT functions?

Re: [HACKERS] libpq naming on Win64

2010-01-06 Thread Craig Ringer
Dave Page wrote: On Tuesday, January 5, 2010, Peter Eisentraut pete...@gmx.net wrote: On tis, 2010-01-05 at 16:48 +, Dave Page wrote: On Tue, Jan 5, 2010 at 3:15 PM, Tom Lane t...@sss.pgh.pa.us wrote: I would have thought Microsoft would have a better solution than this for managing

Re: [HACKERS] libpq naming on Win64

2010-01-06 Thread Craig Ringer
See: http://msdn.microsoft.com/en-us/library/aa376307%28VS.85%29.aspx http://msdn.microsoft.com/en-us/library/aa375155%28VS.85%29.aspx Oh, and: http://blogs.msdn.com/jonwis/archive/2005/12/28/507863.aspx -- Craig Ringer -- Sent via pgsql-hackers mailing list

Re: [HACKERS] New VACUUM FULL

2010-01-06 Thread Simon Riggs
On Wed, 2010-01-06 at 14:41 +0900, Takahiro Itagaki wrote: Simon Riggs si...@2ndquadrant.com wrote: 1. Commit your patch, as-is (you/me) I assume this is OK with you now? I just applied the patch with a few additional comments. Also, I adjusted some messages for vacuumdb to be

Re: [HACKERS] ecpg compile error

2010-01-06 Thread Michael Meskes
On Tue, Jan 05, 2010 at 09:49:27PM -0500, Bruce Momjian wrote: I am seeing a compile failure in current CVS because my operating system, BSD/OS, does not have inttypes.h: Sorry, missed this. I did remove it in another file, but didn't notice it's here too. Should be fixed now that I committed

Re: [HACKERS] ecpg compile error

2010-01-06 Thread Michael Meskes
On Wed, Jan 06, 2010 at 09:42:06AM +0100, Boszormenyi Zoltan wrote: Attached. Passes make check here on 32-bit and 64-bit builds under Fedora 9/x86-64. Applied. Michael -- Michael Meskes Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org) Michael at BorussiaFan dot De,

Re: [HACKERS] New VACUUM FULL

2010-01-06 Thread Peter Eisentraut
On ons, 2010-01-06 at 14:41 +0900, Takahiro Itagaki wrote: Simon Riggs si...@2ndquadrant.com wrote: 1. Commit your patch, as-is (you/me) I assume this is OK with you now? I just applied the patch with a few additional comments. Please clean up the compiler warnings: cluster.c: In

Re: [HACKERS] Status of plperl inter-sp calling

2010-01-06 Thread Tim Bunce
On Tue, Jan 05, 2010 at 07:06:35PM -0500, Tom Lane wrote: Tim Bunce tim.bu...@pobox.com writes: The only question I have at the moment, before I try implementing this, is the the need for freeing the plan. When would that be needed? There's probably no strong need to do it at all, That's

[HACKERS] Change Catalog

2010-01-06 Thread black light
Hi, I can access to system catalog using syscache functions. How can i change the values of cache (e.g. change an attribute in pg_authid)? Are syscache functions readonly? Thanks - B. L.

Re: [HACKERS] tribble.postgresql.org - planned maintenance downtime

2010-01-06 Thread Stefan Kaltenbrunner
Stefan Kaltenbrunner wrote: Hi all! There will be planned downtime on tribble.postgresql.org Jan 6(tomorrow) from 10:00-12:30 GMT(estimated) affecting the following services: cvs.postgresql.org wwwmaster.postgresql.org www.pgadmin.org doxygen.postgresql.org Downtime is necessary to implement

Re: [HACKERS] Change Catalog

2010-01-06 Thread Heikki Linnakangas
black light wrote: Hi, I can access to system catalog using syscache functions. How can i change the values of cache (e.g. change an attribute in pg_authid)? Are syscache functions readonly? I'd suggest that you look at the existing places that modify catalogs for inspiration. E.g

Re: [HACKERS] 'replication' keyword on .pgpass (Streaming Replication)

2010-01-06 Thread Alvaro Herrera
Fujii Masao escribió: On Sat, Dec 26, 2009 at 10:55 AM, Fujii Masao masao.fu...@gmail.com wrote: On Fri, Dec 25, 2009 at 9:56 PM, Andrew Dunstan and...@dunslane.net wrote: I don't see the use case for it - .pgpass is for single users, not a whole cluster. And it does support wildcards,

Re: [HACKERS] 'replication' keyword on .pgpass (Streaming Replication)

2010-01-06 Thread Magnus Hagander
On Wed, Jan 6, 2010 at 15:02, Alvaro Herrera alvhe...@commandprompt.com wrote: Fujii Masao escribió: On Sat, Dec 26, 2009 at 10:55 AM, Fujii Masao masao.fu...@gmail.com wrote: On Fri, Dec 25, 2009 at 9:56 PM, Andrew Dunstan and...@dunslane.net wrote: I don't see the use case for it -

Re: [HACKERS] tribble.postgresql.org - planned maintenance downtime

2010-01-06 Thread Stefan Kaltenbrunner
Stefan Kaltenbrunner wrote: Stefan Kaltenbrunner wrote: Hi all! There will be planned downtime on tribble.postgresql.org Jan 6(tomorrow) from 10:00-12:30 GMT(estimated) affecting the following services: cvs.postgresql.org wwwmaster.postgresql.org www.pgadmin.org doxygen.postgresql.org

[HACKERS] fastgetattr isNull

2010-01-06 Thread Robert Haas
The fastgetattr() attempts to make provision for the case where isnull is a NULL pointer, but it doesn't seem to work. I tried it and got: relcache.c:494: error: invalid use of void expression relcache.c:494: error: invalid use of void expression relcache.c:494: warning: left-hand operand of

Re: [HACKERS] Status of plperl inter-sp calling

2010-01-06 Thread Tom Lane
Tim Bunce tim.bu...@pobox.com writes: For my own benefit, being a PostgreSQL novice, could you expand a little? For example, given two stored procedures, A and V, where V is marked VOLATILE and both are plperl. How would having A call V directly, within the plperl interpreter, cause problems?

Re: [HACKERS] Status of plperl inter-sp calling

2010-01-06 Thread Tom Lane
Tim Bunce tim.bu...@pobox.com writes: Let me ask the question another way... is there any reason to drop plans other than limiting memory usage? No, that's about it. The only reason to care is if you'd otherwise have a code path that would repetitively leak plans.

Re: [HACKERS] pg_migrator issues

2010-01-06 Thread Zdenek Kotala
Dne 4.01.10 19:28, Alvaro Herrera napsal(a): Bruce Momjian escribió: I considered that but realize that pg_migrator has to read pg_controldata in both the old and new servers, meaning it would need access to both C structures, and considering they both have the same structure names, that

Re: [pgsql-www] [HACKERS] tribble.postgresql.org - planned maintenance downtime

2010-01-06 Thread Robert Haas
On Wed, Jan 6, 2010 at 9:42 AM, Stefan Kaltenbrunner ste...@kaltenbrunner.cc wrote: all services should be up now and again sorry for the delays... No, thank you for maintaining this for the rest of us! ...Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] Stats for inheritance trees

2010-01-06 Thread Tom Lane
decibel deci...@decibel.org writes: On Dec 29, 2009, at 6:29 PM, Tom Lane wrote: * when a tabstat message comes in, increment changes_since_analyze by the sum of t_tuples_inserted + t_tuples_updated + t_tuples_deleted; * when an analyze report message comes in, reset changes_since_analyze

Re: [HACKERS] Status of plperl inter-sp calling

2010-01-06 Thread Robert Haas
On Wed, Jan 6, 2010 at 9:46 AM, Tom Lane t...@sss.pgh.pa.us wrote: Tim Bunce tim.bu...@pobox.com writes: For my own benefit, being a PostgreSQL novice, could you expand a little? For example, given two stored procedures, A and V, where V is marked VOLATILE and both are plperl. How would having

Re: [HACKERS] Status of plperl inter-sp calling

2010-01-06 Thread Dimitri Fontaine
Robert Haas robertmh...@gmail.com writes: I think what we should do is either (1) implement a poor man's caching that doesn't try to cope with any of these issues, and document that you get what you pay for or (2) reject this idea in its entirety. Trying to reimplement all of our normal

Re: [pgsql-www] [HACKERS] tribble.postgresql.org - planned maintenance downtime

2010-01-06 Thread Alvaro Herrera
Robert Haas escribió: On Wed, Jan 6, 2010 at 9:42 AM, Stefan Kaltenbrunner ste...@kaltenbrunner.cc wrote: all services should be up now and again sorry for the delays... No, thank you for maintaining this for the rest of us! Seconded, many thanks, pizza and free beer! -- Alvaro Herrera

Re: [HACKERS] Status of plperl inter-sp calling

2010-01-06 Thread Andrew Dunstan
Tom Lane wrote: Tim Bunce tim.bu...@pobox.com writes: For my own benefit, being a PostgreSQL novice, could you expand a little? For example, given two stored procedures, A and V, where V is marked VOLATILE and both are plperl. How would having A call V directly, within the plperl

Re: [HACKERS] Status of plperl inter-sp calling

2010-01-06 Thread Tom Lane
Andrew Dunstan and...@dunslane.net writes: I don't understand that phrase call SPI with the right arguments for the type of function you're currently in. What calls that we make from plperl code would have different arguments depending on the volatility of the function? eg, in

Re: [HACKERS] patch - per-tablespace random_page_cost/seq_page_cost

2010-01-06 Thread Robert Haas
On Tue, Jan 5, 2010 at 10:17 AM, Robert Haas robertmh...@gmail.com wrote: On Mon, Jan 4, 2010 at 1:48 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: My only objection to that is that if we're going to add attoptions also, I'd like to get this committed first

Re: [HACKERS] Status of plperl inter-sp calling

2010-01-06 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan and...@dunslane.net writes: I don't understand that phrase call SPI with the right arguments for the type of function you're currently in. What calls that we make from plperl code would have different arguments depending on the volatility of the function?

Re: [HACKERS] Status of plperl inter-sp calling

2010-01-06 Thread Tom Lane
Andrew Dunstan and...@dunslane.net writes: Tom Lane wrote: spi_rv = SPI_execute(query, current_call_data-prodesc-fn_readonly, ^^^ OK, but won't that automatically supply the value from the function called from postgres, which

Re: [HACKERS] pg_migrator issues

2010-01-06 Thread Bruce Momjian
Zdenek Kotala wrote: Dne 4.01.10 19:28, Alvaro Herrera napsal(a): Bruce Momjian escribi?: I considered that but realize that pg_migrator has to read pg_controldata in both the old and new servers, meaning it would need access to both C structures, and considering they both have the

Re: [HACKERS] Status of plperl inter-sp calling

2010-01-06 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan and...@dunslane.net writes: Tom Lane wrote: spi_rv = SPI_execute(query, current_call_data-prodesc-fn_readonly, ^^^ OK, but won't that automatically supply the value from the

Re: [HACKERS] Status of plperl inter-sp calling

2010-01-06 Thread Tom Lane
Andrew Dunstan and...@dunslane.net writes: Next question: what do we do if a direct-called function calls return_next()? That at least must surely take effect in the caller's context - the callee won't have anywhere to stash the the results at all. Whatever do you mean by take effect in the

Re: [HACKERS] 'replication' keyword on .pgpass (Streaming Replication)

2010-01-06 Thread Tom Lane
Fujii Masao masao.fu...@gmail.com writes: The attached patch supports new keyword 'replication' on .pgpass file. This keyword is used to specify the password for the standby server to connect to the primary server. This strikes me as a completely bad idea. We need get no farther than the

Re: [HACKERS] Type modifiers for DOMAIN

2010-01-06 Thread Tom Lane
Takahiro Itagaki itagaki.takah...@oss.ntt.co.jp writes: Domains were created successfully, but I cannot use type modifiers for them. =# CREATE TABLE tbl (v varchar2(10)); ERROR: type modifier is not allowed for type varchar2 What reason do we have not to inherit typmodin/typmodout

Re: [HACKERS] Streaming replication and postmaster signaling

2010-01-06 Thread Tom Lane
Craig Ringer cr...@postnewspapers.com.au writes: Fujii Masao wrote: On Tue, Jan 5, 2010 at 11:29 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: This was probably discussed to death earlier, but: why was it decided to not simply use a different port for listening for walsender

Re: [HACKERS] Auto-extending table partitions?

2010-01-06 Thread David Fetter
On Tue, Jan 05, 2010 at 08:50:25PM -0700, u235sentinel wrote: Robert Haas wrote: Getting full? ...Robert Ok. Bad analogy. We have the tables setup to write data according to the month it was loaded. We have a December table, a January table and so on. Basically following the

Re: [HACKERS] Auto-extending table partitions?

2010-01-06 Thread Robert Haas
On Wed, Jan 6, 2010 at 12:06 PM, David Fetter da...@fetter.org wrote: On Tue, Jan 05, 2010 at 08:50:25PM -0700, u235sentinel wrote: Robert Haas wrote: Getting full? ...Robert Ok.  Bad analogy.  We have the tables setup to write data according to the month it was loaded.  We have a

Re: [pgsql-www] [HACKERS] tribble.postgresql.org - planned maintenance downtime

2010-01-06 Thread Magnus Hagander
On Wed, Jan 6, 2010 at 16:34, Alvaro Herrera alvhe...@commandprompt.com wrote: Robert Haas escribió: On Wed, Jan 6, 2010 at 9:42 AM, Stefan Kaltenbrunner ste...@kaltenbrunner.cc wrote: all services should be up now and again sorry for the delays... No, thank you for maintaining this for the

Re: [pgsql-www] [HACKERS] tribble.postgresql.org - planned maintenance downtime

2010-01-06 Thread Alvaro Herrera
Magnus Hagander escribió: On Wed, Jan 6, 2010 at 16:34, Alvaro Herrera alvhe...@commandprompt.com wrote: Robert Haas escribió: On Wed, Jan 6, 2010 at 9:42 AM, Stefan Kaltenbrunner ste...@kaltenbrunner.cc wrote: all services should be up now and again sorry for the delays... No,

[HACKERS] snapshot generation broken again...

2010-01-06 Thread Stefan Kaltenbrunner
Looks like somebody broke the snapshot generation script again: Note: meta manvol : see http://docbook.sf.net/el/manvolnum dblink_build_sql_delete Note: Writing man1/dblink_build_sql_delete.1 Note: meta manvol : no refentry/refmeta/manvolnum dblink_build_sql_update Note: meta manvol : see

Re: [HACKERS] Status of plperl inter-sp calling

2010-01-06 Thread Bruce Momjian
Tom Lane wrote: Andrew Dunstan and...@dunslane.net writes: Next question: what do we do if a direct-called function calls return_next()? That at least must surely take effect in the caller's context - the callee won't have anywhere to stash the the results at all. Whatever do you mean

Re: [HACKERS] fastgetattr isNull

2010-01-06 Thread Robert Haas
On Wed, Jan 6, 2010 at 9:43 AM, Robert Haas robertmh...@gmail.com wrote: The fastgetattr() attempts to make provision for the case where isnull is a NULL pointer, but it doesn't seem to work.  I tried it and got: relcache.c:494: error: invalid use of void expression relcache.c:494: error:

Re: [HACKERS] Type modifiers for DOMAIN

2010-01-06 Thread Josh Berkus
/* Domains never accept typmods, so no typmodin/typmodout needed */ but can we relax the restriction? This feature would be useful for migration from other DBMSes that have non-standard data types. For migration, wouldn't it be adequate simply to ignore the typemod? Or to allow it as

Re: [HACKERS] pg_migrator issues

2010-01-06 Thread Bruce Momjian
Bruce Momjian wrote: 2) Right now pg_migrator renames old tablespaces to .old, which fails if the tablespaces are on mount points. I have already received a report of such a failure. $PGDATA also has that issue, but that renaming has to be done by the user before pg_migrator is run, and

Re: [pgsql-www] [HACKERS] tribble.postgresql.org - planned maintenance downtime

2010-01-06 Thread Jaime Casanova
On Wed, Jan 6, 2010 at 12:42 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Oh, so you'r ecoming to FOSDEM? February this year?  No way :-(  I'm probably anchored at home until August or so ... had your baby born now? -- Atentamente, Jaime Casanova Soporte y capacitación de

Re: [HACKERS] fastgetattr isNull

2010-01-06 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: The fastgetattr() attempts to make provision for the case where isnull is a NULL pointer, but it doesn't seem to work. I tried it and got: relcache.c:494: error: invalid use of void expression relcache.c:494: error: invalid use of void expression

Re: [pgsql-www] [HACKERS] tribble.postgresql.org - planned maintenance downtime

2010-01-06 Thread Alvaro Herrera
Jaime Casanova escribió: On Wed, Jan 6, 2010 at 12:42 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Oh, so you'r ecoming to FOSDEM? February this year?  No way :-(  I'm probably anchored at home until August or so ... had your baby born now? Still waiting ... -- Alvaro

Re: [HACKERS] fastgetattr isNull

2010-01-06 Thread Alvaro Herrera
Robert Haas escribió: The fastgetattr() attempts to make provision for the case where isnull is a NULL pointer, but it doesn't seem to work. I tried it and got: relcache.c:494: error: invalid use of void expression relcache.c:494: error: invalid use of void expression relcache.c:494:

Re: [HACKERS] fastgetattr isNull

2010-01-06 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: Spoke with Bruce on IM and we think the best option is to just remove the NULL tests. Since it's been this way for 11 years, presumably nobody is trying to use it with a NULL fourth argument. Proposed patch attached. There are a number of is-null

Re: [HACKERS] fastgetattr isNull

2010-01-06 Thread Robert Haas
On Wed, Jan 6, 2010 at 1:05 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: The fastgetattr() attempts to make provision for the case where isnull is a NULL pointer, but it doesn't seem to work.  I tried it and got: relcache.c:494: error: invalid use of void

Re: I: [HACKERS] TODO: Allow substring/replace() to get/set bit values

2010-01-06 Thread Leonardo F
To sum up: 1) a new function, get_bit, that calls substring 2) a new function, overlay, that replaces bits (starting at a certain position) 3) a new function, set_bit, that calls overlay That seems reasonable to me. Not sure what others think. Is anybody interested? Otherwise the

Re: [HACKERS] Status of plperl inter-sp calling

2010-01-06 Thread Garick Hamlin
On Wed, Jan 06, 2010 at 11:14:38AM -0500, Tom Lane wrote: Andrew Dunstan and...@dunslane.net writes: Tom Lane wrote: spi_rv = SPI_execute(query, current_call_data-prodesc-fn_readonly, ^^^ OK, but won't that automatically

Re: [pgsql-www] [HACKERS] tribble.postgresql.org - planned maintenance downtime

2010-01-06 Thread A. Kretschmer
In response to Alvaro Herrera : Jaime Casanova escribió: had your baby born now? Still waiting ... You are pregnant? ;-) Hey, and yes: i wish you and your wife all the best and many fun with the baby. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639

Re: [HACKERS] fastgetattr isNull

2010-01-06 Thread Robert Haas
On Wed, Jan 6, 2010 at 1:16 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: Spoke with Bruce on IM and we think the best option is to just remove the NULL tests.  Since it's been this way for 11 years, presumably nobody is trying to use it with a NULL fourth

Re: [HACKERS] Type modifiers for DOMAIN

2010-01-06 Thread Kevin Grittner
Takahiro Itagaki itagaki.takah...@oss.ntt.co.jp wrote: This feature would be useful for migration from other DBMSes that have non-standard data types. Domains can indeed be useful to allow migration -- if they are used as intended. If you identify all of the unique data domains on your

Re: [HACKERS] fastgetattr isNull

2010-01-06 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: Well, that comment is a bit misleading too, since a pointer with a NULL value might work but a literal NULL certainly doesn't. I think (bool *) NULL would work. What your compiler is complaining about is trying to dereference a void * expression. In

Re: [HACKERS] fastgetattr isNull

2010-01-06 Thread Robert Haas
On Wed, Jan 6, 2010 at 1:38 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: Well, that comment is a bit misleading too, since a pointer with a NULL value might work but a literal NULL certainly doesn't. I think (bool *) NULL would work.  What your compiler is

Re: [HACKERS] snapshot generation broken again...

2010-01-06 Thread Tom Lane
Stefan Kaltenbrunner ste...@kaltenbrunner.cc writes: Looks like somebody broke the snapshot generation script again: [ scratches head... ] make dist works for me. Can you get a trace indicating what command was used to call genbki.pl? regards, tom lane -- Sent via

Re: [HACKERS] Status of plperl inter-sp calling

2010-01-06 Thread Tom Lane
Garick Hamlin gham...@isc.upenn.edu writes: If you want 'a perl compile time hook', those are called attributes. http://search.cpan.org/~dapm/perl-5.10.1/lib/attributes.pm Hm ... first question that comes to mind is how far back does that work? The comments on that page about this or that part

Re: [HACKERS] snapshot generation broken again...

2010-01-06 Thread Stefan Kaltenbrunner
Tom Lane wrote: Stefan Kaltenbrunner ste...@kaltenbrunner.cc writes: Looks like somebody broke the snapshot generation script again: [ scratches head... ] make dist works for me. Can you get a trace indicating what command was used to call genbki.pl? heh that's a nice one the snapshot

Re: [HACKERS] Status of plperl inter-sp calling

2010-01-06 Thread Andrew Dunstan
Tom Lane wrote: Garick Hamlin gham...@isc.upenn.edu writes: If you want 'a perl compile time hook', those are called attributes. http://search.cpan.org/~dapm/perl-5.10.1/lib/attributes.pm Hm ... first question that comes to mind is how far back does that work? The comments on that

Re: [HACKERS] fastgetattr isNull

2010-01-06 Thread Robert Haas
On Wed, Jan 6, 2010 at 1:16 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: Spoke with Bruce on IM and we think the best option is to just remove the NULL tests.  Since it's been this way for 11 years, presumably nobody is trying to use it with a NULL fourth

Re: I: [HACKERS] TODO: Allow substring/replace() to get/set bit values

2010-01-06 Thread Robert Haas
On Wed, Jan 6, 2010 at 1:21 PM, Leonardo F m_li...@yahoo.it wrote: To sum up: 1) a new function, get_bit, that calls substring 2) a new function, overlay, that replaces bits (starting at a certain position) 3) a new function, set_bit, that calls overlay That seems reasonable to me.  

Re: [HACKERS] snapshot generation broken again...

2010-01-06 Thread John Naylor
Here's a fix. Sorry, I didn't realize it was ever called without a version number. On Wed, Jan 6, 2010 at 11:18 AM, Stefan Kaltenbrunner heh that's a nice one the snapshot generation script uses gmake -s VERSION=snapshot dist and that leads to getting --set-version=snapshot passed to

Re: [HACKERS] snapshot generation broken again...

2010-01-06 Thread Tom Lane
Stefan Kaltenbrunner ste...@kaltenbrunner.cc writes: Tom Lane wrote: [ scratches head... ] make dist works for me. Can you get a trace indicating what command was used to call genbki.pl? heh that's a nice one the snapshot generation script uses gmake -s VERSION=snapshot dist and that

Re: [HACKERS] Auto-extending table partitions?

2010-01-06 Thread Josh Berkus
On 1/6/10 9:13 AM, Robert Haas wrote: On Wed, Jan 6, 2010 at 12:06 PM, David Fetter da...@fetter.org wrote: On Tue, Jan 05, 2010 at 08:50:25PM -0700, u235sentinel wrote: Robert Haas wrote: Getting full? ...Robert Ok. Bad analogy. We have the tables setup to write data according to the

Re: [HACKERS] Status of plperl inter-sp calling

2010-01-06 Thread David E. Wheeler
On Jan 6, 2010, at 11:27 AM, Andrew Dunstan wrote: That's a case of out of date docco more than anything else, AFAIK. It's been there at least since 5.6.2 (which is the earliest source I have on hand). Which likely also means 5.6.1 and quite possibly 5.6.0. I don't recommend anything earlier

[HACKERS] unresolved bugs

2010-01-06 Thread Robert Haas
Over the past few months, I've been attempting to keep tracks of which postings on pgsql-bugs have not gotten a response and to respond to those where I have a clue what the issue might be. However, there are a few that I don't really have an idea about which look like they might be real bugs...

Re: [HACKERS] snapshot generation broken again...

2010-01-06 Thread Tom Lane
John Naylor jcnay...@gmail.com writes: Here's a fix. Sorry, I didn't realize it was ever called without a version number. It's not supposed to be. If it fails to put the correct version number into the .bki file, initdb will spit up. This is really a makefile bug, not genbki's fault.

Re: [HACKERS] Status of plperl inter-sp calling

2010-01-06 Thread Tom Lane
David E. Wheeler da...@kineticode.com writes: Which likely also means 5.6.1 and quite possibly 5.6.0. I don't recommend anything earlier than 5.6.2, though, frankly, and 5.8.9 is a better choice. 5.10.1 better still. Is there a documented required minimum version for PL/Perl? One of the

Re: [HACKERS] snapshot generation broken again...

2010-01-06 Thread Stefan Kaltenbrunner
Tom Lane wrote: John Naylor jcnay...@gmail.com writes: Here's a fix. Sorry, I didn't realize it was ever called without a version number. It's not supposed to be. If it fails to put the correct version number into the .bki file, initdb will spit up. This is really a makefile bug, not

Re: [HACKERS] unresolved bugs

2010-01-06 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: The first of these in particular is a fairly detailed report of what looks might be a fairly serious problem. pg_listener entries deleted under heavy NOTIFY load only on Windows http://archives.postgresql.org/pgsql-bugs/2009-12/msg00274.php Yeah,

Re: [HACKERS] snapshot generation broken again...

2010-01-06 Thread Tom Lane
Stefan Kaltenbrunner ste...@kaltenbrunner.cc writes: really? there are provisions withing genbki.pl that are supposed to provide a proper error message(and would have likely helped to find the issue in that case as well): die Version not specified or wrong format.\n if !defined

Re: [HACKERS] unresolved bugs

2010-01-06 Thread Alvaro Herrera
Robert Haas escribió: Over the past few months, I've been attempting to keep tracks of which postings on pgsql-bugs have not gotten a response and to respond to those where I have a clue what the issue might be. So you installed the bugzilla module on yourself? Neat. Keep at it! Should we

Re: [HACKERS] unresolved bugs

2010-01-06 Thread Robert Haas
On Wed, Jan 6, 2010 at 4:00 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Robert Haas escribió: Over the past few months, I've been attempting to keep tracks of which postings on pgsql-bugs have not gotten a response and to respond to those where I have a clue what the issue might be.

Re: [HACKERS] unresolved bugs

2010-01-06 Thread Stefan Kaltenbrunner
Robert Haas wrote: On Wed, Jan 6, 2010 at 4:00 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Robert Haas escribió: Over the past few months, I've been attempting to keep tracks of which postings on pgsql-bugs have not gotten a response and to respond to those where I have a clue what

[HACKERS] Use of PG_VERSION

2010-01-06 Thread Bruce Momjian
Is there a reason tablespace.c::set_short_version() uses PG_VERSION, and not the simpler PG_MAJORVERSION? initdb.c::get_short_version() does the same thing. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + If

Re: [HACKERS] Serializable Isolation without blocking

2010-01-06 Thread Kevin Grittner
Robert Haas robertmh...@gmail.com wrote: And use git so you can keep merging up to CVS HEAD easily. Regarding this, I was thinking that it would make sense to use a repository on git.postgresql.org to coordinate my work with any other people interested in the project. I would clone from

Re: [HACKERS] unresolved bugs

2010-01-06 Thread Robert Haas
On Wed, Jan 6, 2010 at 4:10 PM, Stefan Kaltenbrunner ste...@kaltenbrunner.cc wrote: Robert Haas wrote: On Wed, Jan 6, 2010 at 4:00 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: Robert Haas escribió: Over the past few months, I've been attempting to keep tracks of which postings on

Re: [HACKERS] Serializable Isolation without blocking

2010-01-06 Thread Robert Haas
On Wed, Jan 6, 2010 at 4:29 PM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Robert Haas robertmh...@gmail.com wrote: And use git so you can keep merging up to CVS HEAD easily. Regarding this, I was thinking that it would make sense to use a repository on git.postgresql.org to

Re: [HACKERS] unresolved bugs

2010-01-06 Thread Alvaro Herrera
Robert Haas escribió: On Wed, Jan 6, 2010 at 4:10 PM, Stefan Kaltenbrunner ste...@kaltenbrunner.cc wrote: hmm maybe I should resurrect the bugzilla testbed again :) If we're going to use a bug-tracker, Bugzilla wouldn't be my first choice, I don't think. Honestly what I'd like better

Re: [HACKERS] win32 socket definition

2010-01-06 Thread Magnus Hagander
On Fri, Jan 1, 2010 at 20:55, Magnus Hagander mag...@hagander.net wrote: On Fri, Jan 1, 2010 at 20:41, Tom Lane t...@sss.pgh.pa.us wrote: Magnus Hagander mag...@hagander.net writes: The win64 port has showed that we have two sockets declared incorrectly. They are supposed to be declared as

Re: [HACKERS] Cancelling idle in transaction state

2010-01-06 Thread Joachim Wieland
On Fri, Jan 1, 2010 at 10:45 PM, Simon Riggs si...@2ndquadrant.com wrote: CancelRequest's behaviour currently equates to SIGINT, so processCancelRequest() can only use SIGINT if SIGINT's behaviour remains same. I would recommend we make SIGINT do cancel-anything, and handle everything else

Re: [HACKERS] win32 socket definition

2010-01-06 Thread Tom Lane
Magnus Hagander mag...@hagander.net writes: Is there a good trick to find out if you've touched every place you need to, because I'm very unsure I have. I don't even get a warning in more than those two places, but there ought to be some way to trick the system to tell me? Can't think of one,

Re: [HACKERS] Cancelling idle in transaction state

2010-01-06 Thread Robert Haas
On Wed, Jan 6, 2010 at 4:37 PM, Joachim Wieland j...@mcknight.de wrote: On Fri, Jan 1, 2010 at 10:45 PM, Simon Riggs si...@2ndquadrant.com wrote: CancelRequest's behaviour currently equates to SIGINT, so processCancelRequest() can only use SIGINT if SIGINT's behaviour remains same. I would

Re: [HACKERS] Status of plperl inter-sp calling

2010-01-06 Thread David E. Wheeler
On Jan 6, 2010, at 12:20 PM, Tom Lane wrote: One of the things on my to-do list for today is to make configure reject Perl versions less than $TBD. I thought we had agreed a week or so back that 5.8 was the lowest safe version because of utf8 and other considerations. +1, and 5.8.3 at a

Re: [HACKERS] Serializable Isolation without blocking

2010-01-06 Thread Dimitri Fontaine
Kevin Grittner kevin.gritt...@wicourts.gov writes: I've read through some git tutorials, but there's a lot to digest and I'm not entirely sure this is a good way to proceed. I found that the following video is really helpful at grasping the concepts of git, that it exposes pretty directly even

Re: [HACKERS] Testing with concurrent sessions

2010-01-06 Thread Kevin Grittner
David E. Wheeler da...@kineticode.com wrote: Last I heard, Andrew was willing to require Test::More for testing, so that a Perl script could handle multiple psql connections (perhaps forked) and output test results based on them. But he wasn't as interested in requiring DBI and DBD::Pg,

Re: [HACKERS] xpath improvement suggestion

2010-01-06 Thread Arie Bikker
Robert Haas wrote: On Tue, Jan 5, 2010 at 6:09 PM, Arie Bikker a...@abikker.nl wrote: Hi all, Well I had to burn some midnight oil trying to figure out why a construct like SELECT xpath('name()','a/'); doesn't give the expected result. Kept getting an empty array: xpath

Re: [HACKERS] Serializable Isolation without blocking

2010-01-06 Thread Kevin Grittner
Robert Haas robertmh...@gmail.com wrote: I think you should have users/kgrittner/postgres.git rather than serializable.git. serializable sounds more like the branch name. Hmmm On a multi-year project it seemed more than remotely possible that responsibility for the project could shift,

Re: [HACKERS] unresolved bugs

2010-01-06 Thread Dimitri Fontaine
Robert Haas robertmh...@gmail.com writes: If we're going to use a bug-tracker, Bugzilla wouldn't be my first choice, I don't think. Honestly what I'd like better than a full-fledged trackers is just a webapp that lists all the unreplied-to emails in the pgsql-bugs archives. For something

Re: [HACKERS] Testing with concurrent sessions

2010-01-06 Thread Peter Eisentraut
On ons, 2010-01-06 at 15:52 -0600, Kevin Grittner wrote: David E. Wheeler da...@kineticode.com wrote: Last I heard, Andrew was willing to require Test::More for testing, so that a Perl script could handle multiple psql connections (perhaps forked) and output test results based on them.

Re: [HACKERS] Use of PG_VERSION

2010-01-06 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: Is there a reason tablespace.c::set_short_version() uses PG_VERSION, and not the simpler PG_MAJORVERSION? initdb.c::get_short_version() does the same thing. Probably that code predates the addition of the separate PG_MAJORVERSION #define. +1 for

Re: [HACKERS] Testing with concurrent sessions

2010-01-06 Thread David E. Wheeler
On Jan 6, 2010, at 1:52 PM, Kevin Grittner wrote: Last I heard, Andrew was willing to require Test::More for testing, so that a Perl script could handle multiple psql connections (perhaps forked) and output test results based on them. But he wasn't as interested in requiring DBI and DBD::Pg,

Re: [HACKERS] Testing with concurrent sessions

2010-01-06 Thread David E. Wheeler
On Jan 6, 2010, at 2:08 PM, Peter Eisentraut wrote: Then I don't see much of a point in using Perl. You might as well fire up a few psqls from a shell script If you're more comfortable with shell, then yes. Although then it won't run on Windows, will it? Best, David -- Sent via

Re: [HACKERS] [COMMITTERS] pgsql: Support ALTER TABLESPACE name SET/RESET ( tablespace_options ).

2010-01-06 Thread Tom Lane
rh...@postgresql.org (Robert Haas) writes: Support ALTER TABLESPACE name SET/RESET ( tablespace_options ). With this patch, a CLOBBER_CACHE_ALWAYS build starts falling apart all over the place :-(. Looks like you blew the memory management somehow; it appears to be using a previously pfree'd

  1   2   >