Re: [HACKERS] 8.5 development schedule

2009-07-02 Thread Guillaume Smet
On Wed, Jul 1, 2009 at 11:42 PM, Andrew Dunstanand...@dunslane.net wrote: You have correctly identified the requirement in the sentence quoted above. I for one am quite prepared to support core or some person designated by core having such authority. I agree with you that without something like

Re: [HACKERS] HEAD is open for 8.5 development

2009-07-02 Thread Peter Eisentraut
On Thursday 02 July 2009 05:29:58 Robert Haas wrote: If you are taking a look at any of the patches submitted for this CommitFest, please put your name next to them on the wiki. Please ALSO add a comment saying something like tgl says: I am reviewing this, no need to assign a round-robin

Re: [HACKERS] First CommitFest: July 15th

2009-07-02 Thread Dave Page
On Thu, Jul 2, 2009 at 1:21 AM, Josh Berkusj...@agliodbs.com wrote: Robert, I have not reviewed your software.  Do I need a login or something? It's not in productions yet as It's not been documented or given a public hostname/servicename, both of which are requirements for any postgresql.org

Re: [HACKERS] First CommitFest: July 15th

2009-07-02 Thread Robert Haas
On Jul 2, 2009, at 3:41 AM, Dave Page dp...@pgadmin.org wrote: On Thu, Jul 2, 2009 at 1:21 AM, Josh Berkusj...@agliodbs.com wrote: Robert, I have not reviewed your software. Do I need a login or something? It's not in productions yet as It's not been documented or given a public

Re: [HACKERS] First CommitFest: July 15th

2009-07-02 Thread Dave Page
On Thu, Jul 2, 2009 at 12:04 PM, Robert Haasrobertmh...@gmail.com wrote: On Jul 2, 2009, at 3:41 AM, Dave Page dp...@pgadmin.org wrote: On Thu, Jul 2, 2009 at 1:21 AM, Josh Berkusj...@agliodbs.com wrote: Robert, I have not reviewed your software.  Do I need a login or something? It's not

Re: [HACKERS] First CommitFest: July 15th

2009-07-02 Thread Robert Haas
On Thu, Jul 2, 2009 at 7:11 AM, Dave Pagedp...@pgadmin.org wrote: On Thu, Jul 2, 2009 at 12:04 PM, Robert Haasrobertmh...@gmail.com wrote: On Jul 2, 2009, at 3:41 AM, Dave Page dp...@pgadmin.org wrote: On Thu, Jul 2, 2009 at 1:21 AM, Josh Berkusj...@agliodbs.com wrote: Robert, I have not

Re: [HACKERS] Query progress indication - an implementation

2009-07-02 Thread Greg Stark
On Thu, Jul 2, 2009 at 2:32 AM, Bruce Momjianbr...@momjian.us wrote: I think the only resonable solution would be to consider the estimated cost of each node and then compute what percentage complete each node is. Well you can do better for some nodes. A sequential scan for example can tell

Re: [HACKERS] HEAD is open for 8.5 development

2009-07-02 Thread Robert Haas
On Thu, Jul 2, 2009 at 2:42 AM, Peter Eisentrautpete...@gmx.net wrote: On Thursday 02 July 2009 05:29:58 Robert Haas wrote: If you are taking a look at any of the patches submitted for this CommitFest, please put your name next to them on the wiki.  Please ALSO add a comment saying something

Re: [HACKERS] First CommitFest: July 15th

2009-07-02 Thread Joshua Tolley
On Thu, Jul 02, 2009 at 08:41:27AM +0100, Dave Page wrote: As far as I'm aware, there's been no code review yet either, which would probably be a good idea. I don't have loads of time in the coming days, but IIRC I've taken a glance at a past version of the code, and would be willing to do so

[HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Tom Lane
I'd like to return to the project I suggested here: http://archives.postgresql.org/message-id/18653.1239741...@sss.pgh.pa.us of getting rid of plpgsql's private lexer and having it use the core lexer instead. This will require making the core lexer re-entrant, which is not possible with our

[HACKERS] tsvector extraction patch

2009-07-02 Thread Hans-Juergen Schoenig -- PostgreSQL
hello, i made a small patch which i found useful for my personal tasks. it would be nice to see this in 8.5. if not core then maybe contrib. it transforms a tsvector to table format which is really nice for text processing and comparison. test=# SELECT * FROM tsvcontent(to_tsvector('english',

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Andrew Dunstan
Tom Lane wrote: I'd like to return to the project I suggested here: http://archives.postgresql.org/message-id/18653.1239741...@sss.pgh.pa.us of getting rid of plpgsql's private lexer and having it use the core lexer instead. This will require making the core lexer re-entrant, which is not

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Kevin Grittner
Tom Lane t...@sss.pgh.pa.us wrote: so the new minimum supported version would probably be 2.5.33 (2.5.31 was kinda broken for other reasons, and there was no 2.5.32). Since 2.5.33 is now over three years old, this does not seem like an onerous requirement, but I thought I'd better ask if

Re: [HACKERS] First CommitFest: July 15th

2009-07-02 Thread Dave Page
On Thu, Jul 2, 2009 at 3:22 PM, Joshua Tolleyeggyk...@gmail.com wrote: On Thu, Jul 02, 2009 at 08:41:27AM +0100, Dave Page wrote: As far as I'm aware, there's been no code review yet either, which would probably be a good idea. I don't have loads of time in the coming days, but IIRC I've

Re: [HACKERS] First CommitFest: July 15th

2009-07-02 Thread Dickson S. Guedes
Em Thu, 02 Jul 2009 00:26:14 -0300, Brendan Jurd dire...@gmail.com escreveu: I imagine that migration would basically be converting the wiki data into SQL, so I would need the database schema underlying the new CF app. How about parsing wiki content and create a migration script based on

Re: [HACKERS] tsvector extraction patch

2009-07-02 Thread Robert Haas
On Thu, Jul 2, 2009 at 10:13 AM, Hans-Juergen Schoenig -- PostgreSQLpostg...@cybertec.at wrote: hello, i made a small patch which i found useful for my personal tasks. it would be nice to see this in 8.5. if not core then maybe contrib. it transforms a tsvector to table format which is really

Re: [HACKERS] tsvector extraction patch

2009-07-02 Thread Oleg Bartunov
I have simple solution http://www.sai.msu.su/~megera/wiki/2008-12-17 On Thu, 2 Jul 2009, Hans-Juergen Schoenig -- PostgreSQL wrote: hello, i made a small patch which i found useful for my personal tasks. it would be nice to see this in 8.5. if not core then maybe contrib. it transforms a

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Kevin Grittner
Kevin Grittner kevin.gritt...@wicourts.gov wrote: Tom Lane t...@sss.pgh.pa.us wrote: so the new minimum supported version would probably be 2.5.33 We still have five SuSE Enterprise 9 boxes in use as database servers; while we've got someone tasked with replacing them, I wonder if that

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Tom Lane
Andrew Dunstan and...@dunslane.net writes: I think it would need to be benchmarked. My faint recollection is that the re-entrant lexers are slower. The flex documentation states in so many words: The option `--reentrant' does not affect the performance of the scanner. Do you feel a

Re: [HACKERS] First CommitFest: July 15th

2009-07-02 Thread Dickson S. Guedes
Em Thu, 02 Jul 2009 00:15:22 -0300, Robert Haas robertmh...@gmail.com escreveu: The main problem is that my fine software only contains test data at this point. If we have any volunteers who are available to migrate the information from the Wiki to my app (which will involve a fair amount of

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan and...@dunslane.net writes: I think it would need to be benchmarked. My faint recollection is that the re-entrant lexers are slower. The flex documentation states in so many words: The option `--reentrant' does not affect the performance of

Re: [HACKERS] First CommitFest: July 15th

2009-07-02 Thread Dave Page
On Thu, Jul 2, 2009 at 12:48 PM, Robert Haasrobertmh...@gmail.com wrote: On Thu, Jul 2, 2009 at 7:11 AM, Dave Pagedp...@pgadmin.org wrote: Suggest a suitable name by which we can address the service (we don't use the internal names like coridan because things can get moved around), and I can

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Alvaro Herrera
Kevin Grittner wrote: Tom Lane t...@sss.pgh.pa.us wrote: so the new minimum supported version would probably be 2.5.33 (2.5.31 was kinda broken for other reasons, and there was no 2.5.32). Since 2.5.33 is now over three years old, this does not seem like an onerous requirement,

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Tom Lane
Kevin Grittner kevin.gritt...@wicourts.gov writes: kgri...@ccdev-db:/etc/init.d flex --version flex 2.5.31 Just how broken is the version we're using? You might want to take that up with SuSE. The flex NEWS file just cites numerous bug and security fixes from .31 to .33. Our CVS logs show

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Tom Lane
Alvaro Herrera alvhe...@commandprompt.com writes: Kevin Grittner wrote: Tom Lane t...@sss.pgh.pa.us wrote: Since 2.5.33 is now over three years old, this does not seem like an onerous requirement, but I thought I'd better ask if anyone has an objection? You'd be causing problems for SuSE

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Andrew Dunstan
Tom Lane wrote: Alvaro Herrera alvhe...@commandprompt.com writes: Kevin Grittner wrote: Tom Lane t...@sss.pgh.pa.us wrote: Since 2.5.33 is now over three years old, this does not seem like an onerous requirement, but I thought I'd better ask if anyone has an objection?

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Kevin Grittner
Alvaro Herrera alvhe...@commandprompt.com wrote: Keep in mind that if you build from a tarball, the lexer has already been run elsewhere and you don't need flex. Does that hold for the daily snapshots? If so, I should be good. My workstation is OK on flex version. (I run kubuntu on my

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Tom Lane
Andrew Dunstan and...@dunslane.net writes: Tom Lane wrote: Right, this will only affect people doing development or otherwise building from a CVS pull. Of course, that includes the whole buildfarm. We might need to ask some people to upgrade there. Yes. What I was thinking of doing was

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Alvaro Herrera
Kevin Grittner wrote: Alvaro Herrera alvhe...@commandprompt.com wrote: Keep in mind that if you build from a tarball, the lexer has already been run elsewhere and you don't need flex. Does that hold for the daily snapshots? If so, I should be good. Yes, the snapshots have the

Re: [HACKERS] First CommitFest: July 15th

2009-07-02 Thread Robert Haas
On Thu, Jul 2, 2009 at 11:05 AM, Dickson S. Guedeslis...@guedesoft.net wrote: Em Thu, 02 Jul 2009 00:15:22 -0300, Robert Haas robertmh...@gmail.com escreveu: The main problem is that my fine software only contains test data at this point.  If we have any volunteers who are available to

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Greg Stark
Tom Lane wrote: Right, this will only affect people doing development or otherwise building from a CVS pull. Someone doing a CVS pull already needs a specific recent version of autoconf anyways. How old is this version of flex compared to the version of autoconf we require? -- greg

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Robert Haas
On Thu, Jul 2, 2009 at 11:39 AM, Greg Starkgsst...@mit.edu wrote: Tom Lane wrote: Right, this will only affect people doing development or otherwise building from a CVS pull. Someone doing a CVS pull already needs a specific recent version of autoconf anyways. How old is this version of flex

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: On Thu, Jul 2, 2009 at 11:39 AM, Greg Starkgsst...@mit.edu wrote: Someone doing a CVS pull already needs a specific recent version of autoconf anyways. How old is this version of flex compared to the version of autoconf we require? Really? configure

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Kevin Grittner
Alvaro Herrera alvhe...@commandprompt.com wrote: Yes, the snapshots have the derived files too. Then I take it back -- the new flex versions would have little or no impact on me. Worst case, I might need to download a snapshot to apply my patch for testing on the big machines. If I

Re: [HACKERS] single bit integer (TINYINT) revisited for 8.5

2009-07-02 Thread Simon Riggs
On Wed, 2009-07-01 at 11:19 -0400, Caleb Cushing wrote: I'd like to see this topic revisited since as far as I can see it hasn't been seriously discussed in years. I believe the main arguments against are why do we need more more numeric datatypes and increased maintenance. It would seem to

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Tom Lane
Kevin Grittner kevin.gritt...@wicourts.gov writes: Then I take it back -- the new flex versions would have little or no impact on me. Worst case, I might need to download a snapshot to apply my patch for testing on the big machines. If I understood what make options I could use on my machine

Re: [HACKERS] First CommitFest: July 15th

2009-07-02 Thread Joshua Tolley
On Thu, Jul 02, 2009 at 03:42:56PM +0100, Dave Page wrote: On Thu, Jul 2, 2009 at 3:22 PM, Joshua Tolleyeggyk...@gmail.com wrote: On Thu, Jul 02, 2009 at 08:41:27AM +0100, Dave Page wrote: As far as I'm aware, there's been no code review yet either, which would probably be a good idea.

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Tom Lane
I wrote: Yes. What I was thinking of doing was committing a configure change to reject flex 2.5.31, and waiting to see how much of the buildfarm goes red. Actually, most of the buildfarm members show which flex version they are running in the configure output. A quick look shows that of the

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Kevin Grittner
Tom Lane t...@sss.pgh.pa.us wrote: Peter or Marc could clue you in a bit better, but I think it's as simple as saying make dist at the top level of a modified source tree. This gets you a source tarball the same way the release tarballs are made. I seem to be able to sneak up on it from

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Tom Lane
Kevin Grittner kevin.gritt...@wicourts.gov writes: I seem to be able to sneak up on it from behind by doing a regular make and then make distclean and copying the results. Perhaps someone knows off-hand what I'm missing that prevents make dist from working. The attempt ends with: jade -D

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Kevin Grittner
Tom Lane t...@sss.pgh.pa.us wrote: Kevin Grittner kevin.gritt...@wicourts.gov writes: jade -D . -d stylesheet.dsl -i output-text -t sgml -V nochunks tempfile_HISTORY.sgml HISTORY.html /bin/sh: jade: not found Looks like you're missing openjade. However, that's only used to produce

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Peter Eisentraut
On Thursday 02 July 2009 19:46:04 Tom Lane wrote: Kevin Grittner kevin.gritt...@wicourts.gov writes: Then I take it back -- the new flex versions would have little or no impact on me. Worst case, I might need to download a snapshot to apply my patch for testing on the big machines. If I

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Jaime Casanova
On Thu, Jul 2, 2009 at 12:13 PM, Tom Lanet...@sss.pgh.pa.us wrote: However I'm a bit worried about the situation for Windows --- does anyone know whether a newer flex is readily available for Windows? MSYS Suplementary Tools (for mingw) includes flex-2.5.33

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Kevin Grittner
Peter Eisentraut pete...@gmx.net wrote: make distprep is what prepares those files. Perfect! Flex files built. No errors. Thanks much! -Kevin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] First CommitFest: July 15th

2009-07-02 Thread Robert Haas
On Thu, Jul 2, 2009 at 1:10 PM, Joshua Tolleyeggyk...@gmail.com wrote: On Thu, Jul 02, 2009 at 03:42:56PM +0100, Dave Page wrote: On Thu, Jul 2, 2009 at 3:22 PM, Joshua Tolleyeggyk...@gmail.com wrote: On Thu, Jul 02, 2009 at 08:41:27AM +0100, Dave Page wrote: As far as I'm aware, there's

Re: [HACKERS] pg_migrator mention in documentation

2009-07-02 Thread Peter Eisentraut
On Friday 19 June 2009 00:56:42 Bruce Momjian wrote: The makefile for pg_migrator currently assumes by default that it is located under contrib/. Which confuses me. You can compile pg_migrator by copying it to /contrib, or using PGXS; both work. Read the 15-step install instructions for

Re: [HACKERS] Query progress indication - an implementation

2009-07-02 Thread Robert Haas
On Thu, Jul 2, 2009 at 12:48 PM, Euler Taveira de Oliveiraeu...@timbira.com wrote: I know that it didn't solve the estimation problem but ... IMHO the [under|over]estimation should be treated by an external tool (autoexplain?). So when we enable the query progress and some node reports a

Re: [HACKERS] pg_migrator mention in documentation

2009-07-02 Thread Alvaro Herrera
Peter Eisentraut wrote: On Friday 19 June 2009 00:56:42 Bruce Momjian wrote: The makefile for pg_migrator currently assumes by default that it is located under contrib/. Which confuses me. You can compile pg_migrator by copying it to /contrib, or using PGXS; both work. Read the

Re: [HACKERS] pg_migrator mention in documentation

2009-07-02 Thread Kevin Grittner
Alvaro Herrera alvhe...@commandprompt.com wrote: I wonder why we have two ways at all (I'm not counting the stuff about copying it to contrib because it seems pointless). The other day I was looking at orafce code in pgfoundry, and at clearxlogtail too IIRC, and they both had the ifdef

[HACKERS] Autoconf 2.63

2009-07-02 Thread Peter Eisentraut
... is now the required version to rebuild configure. Other than that, nothing changes. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] 8.5 development schedule

2009-07-02 Thread Chris Browne
gsst...@mit.edu (Greg Stark) writes: I would like to propose a different strategy. Instead of always tackling all the smaller patches and leaving the big patches for last, I would suggest we start with Hot Standby. In fact I would suggest as Hot Standby has already gotten a first pass review

Re: [HACKERS] [PATCH] Psql List Languages

2009-07-02 Thread Peter Eisentraut
On Monday 02 February 2009 15:29:51 Fernando Ike wrote: Hi, On Fri, Jan 30, 2009 at 3:03 PM, Fernando Ike f...@midstorm.org wrote: Hi,, My job, I maintainer some postgres server for clients. We have many PL/(Java, Perl, Ruby, Python, R) and to more easy administration, I worked

Re: [HACKERS] [PATCH] Psql List Languages

2009-07-02 Thread Tom Lane
Peter Eisentraut pete...@gmx.net writes: Looks good, but needs documentation and tab-complete.c updates, it seems. And you should revisit this patch to make it consistent with the S flag that was added to most \d commands. For example, \dL would show only user-added languages, but \dLS

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Zdenek Kotala
Tom Lane píše v čt 02. 07. 2009 v 11:32 -0400: Andrew Dunstan and...@dunslane.net writes: Tom Lane wrote: Right, this will only affect people doing development or otherwise building from a CVS pull. Of course, that includes the whole buildfarm. We might need to ask some people to

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

2009-07-02 Thread Zdenek Kotala
Tom Lane píše v čt 02. 07. 2009 v 13:13 -0400: I wrote: Yes. What I was thinking of doing was committing a configure change to reject flex 2.5.31, and waiting to see how much of the buildfarm goes red. Actually, most of the buildfarm members show which flex version they are running

Re: [HACKERS] pg_migrator mention in documentation

2009-07-02 Thread Tom Lane
Peter Eisentraut pete...@gmx.net writes: On Friday 19 June 2009 00:56:42 Bruce Momjian wrote: A third install method is to use PGXS (assuming the new 'pg_config' is in your $PATH): USE_PGXS=1 gmake prefix=/usr/local/pgsql.new install Maybe the latter method should be the default, as it

Re: [HACKERS] First CommitFest: July 15th

2009-07-02 Thread Zdenek Kotala
Josh Berkus píše v st 01. 07. 2009 v 17:21 -0700: Folks, There's been a lot of discussion/argument around how to handle the last commitfest, but there seems to be a total consensus that we want to have the first CF on July 15th. Can we add flags like bump catalog version, bump page

[HACKERS] PGXS problem with pdftotext

2009-07-02 Thread Kevin Grittner
I've been wondering whether anyone else would want to use the functions we wrote to extract text from PDF documents stored in bytea columns. If so, I would need to sort out the problems I've been having with builds through the PGXS techniques. Here's the directory, after a successful build under

[HACKERS] bug in Google translate snippet

2009-07-02 Thread Alvaro Herrera
Hi, I was having a look at this snippet: http://wiki.postgresql.org/wiki/Google_Translate and it turns out that it doesn't work if the result contains non-ASCII chars. Does anybody know how to fix it? alvherre=# select gtranslate('en', 'es', 'he'); ERROR: plpython: function gtranslate could

Re: [HACKERS] PGXS problem with pdftotext

2009-07-02 Thread Tom Lane
Kevin Grittner kevin.gritt...@wicourts.gov writes: PG_CPPFLAGS =-I/usr/include/poppler -shared -fpic SHLIB_LINK = -lpoppler -L/usr/local/lib It doesn't seem appropriate to put -shared or -fpic into PG_CPPFLAGS. If you need those, the makefiles should add them automatically. The other thing

Re: [HACKERS] PGXS problem with pdftotext

2009-07-02 Thread Kevin Grittner
Tom Lane t...@sss.pgh.pa.us wrote: Kevin Grittner kevin.gritt...@wicourts.gov writes: PG_CPPFLAGS =-I/usr/include/poppler -shared -fpic SHLIB_LINK = -lpoppler -L/usr/local/lib It doesn't seem appropriate to put -shared or -fpic into PG_CPPFLAGS. If you need those, the makefiles should add

[HACKERS] TODO items

2009-07-02 Thread Jaime Casanova
Hi, I guess todo items marked as [D] (Done) should be removed now... right? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] TODO items

2009-07-02 Thread Alvaro Herrera
Jaime Casanova wrote: Hi, I guess todo items marked as [D] (Done) should be removed now... right? Would there be some value in creating a new page TodoDone84 and moving those items to it? -- Alvaro Herrerahttp://www.CommandPrompt.com/ The PostgreSQL Company -

Re: [HACKERS] bug in Google translate snippet

2009-07-02 Thread Andrew Dunstan
Alvaro Herrera wrote: Hi, I was having a look at this snippet: http://wiki.postgresql.org/wiki/Google_Translate and it turns out that it doesn't work if the result contains non-ASCII chars. Does anybody know how to fix it? alvherre=# select gtranslate('en', 'es', 'he'); ERROR: plpython:

Re: [HACKERS] TODO items

2009-07-02 Thread Joshua D. Drake
On Thu, 2009-07-02 at 17:29 -0400, Alvaro Herrera wrote: Jaime Casanova wrote: Hi, I guess todo items marked as [D] (Done) should be removed now... right? Would there be some value in creating a new page TodoDone84 and moving those items to it? For historical record I could see

Re: [HACKERS] PGXS problem with pdftotext

2009-07-02 Thread Tom Lane
Kevin Grittner kevin.gritt...@wicourts.gov writes: Does it seem likely that fixing these issues will allow PGXS to work? Couldn't say. It would be useful to compare ldd output for pdftotext.so built both ways. regards, tom lane -- Sent via pgsql-hackers mailing list

Re: [HACKERS] bug in Google translate snippet

2009-07-02 Thread Alvaro Herrera
Andrew Dunstan wrote: Alvaro Herrera wrote: Hi, I was having a look at this snippet: http://wiki.postgresql.org/wiki/Google_Translate and it turns out that it doesn't work if the result contains non-ASCII chars. Does anybody know how to fix it? alvherre=# select gtranslate('en', 'es',

Re: [HACKERS] TODO items

2009-07-02 Thread Andrew Dunstan
Joshua D. Drake wrote: On Thu, 2009-07-02 at 17:29 -0400, Alvaro Herrera wrote: Jaime Casanova wrote: Hi, I guess todo items marked as [D] (Done) should be removed now... right? Would there be some value in creating a new page TodoDone84 and moving those items to it?

Re: [HACKERS] TODO items

2009-07-02 Thread Tom Lane
Alvaro Herrera alvhe...@commandprompt.com writes: Jaime Casanova wrote: I guess todo items marked as [D] (Done) should be removed now... right? Would there be some value in creating a new page TodoDone84 and moving those items to it? In the past we've figured that old TODO versions could be

Re: [HACKERS] First CommitFest: July 15th

2009-07-02 Thread Greg Stark
So I currently have some free time as I'm currently between jobs. I can start going through the queued patches in the next few weeks. Should I be looking at the wiki currently? Or is your tool ready to go? -- greg http://mit.edu/~gsstark/resume.pdf -- Sent via pgsql-hackers mailing list

Re: [HACKERS] TODO items

2009-07-02 Thread Alvaro Herrera
Andrew Dunstan wrote: Joshua D. Drake wrote: On Thu, 2009-07-02 at 17:29 -0400, Alvaro Herrera wrote: Jaime Casanova wrote: I guess todo items marked as [D] (Done) should be removed now... right? Would there be some value in creating a new page TodoDone84 and moving those

Re: [HACKERS] TODO items

2009-07-02 Thread Jaime Casanova
On Thu, Jul 2, 2009 at 4:50 PM, Tom Lanet...@sss.pgh.pa.us wrote: Alvaro Herrera alvhe...@commandprompt.com writes: Jaime Casanova wrote: I guess todo items marked as [D] (Done) should be removed now... right? Would there be some value in creating a new page TodoDone84 and moving those items

Re: [HACKERS] TODO items

2009-07-02 Thread Tom Lane
Jaime Casanova jcasa...@systemguards.com.ec writes: We want to use the same format/sections like in the TODO? Sure, why not? Just copy the page and strip out the not-done items. No reason to think hard here. regards, tom lane -- Sent via pgsql-hackers mailing list

Re: [HACKERS] pg_migrator mention in documentation

2009-07-02 Thread Bruce Momjian
Peter Eisentraut wrote: On Friday 19 June 2009 00:56:42 Bruce Momjian wrote: The makefile for pg_migrator currently assumes by default that it is located under contrib/. Which confuses me. You can compile pg_migrator by copying it to /contrib, or using PGXS; both work. Read the

Re: [HACKERS] pg_migrator mention in documentation

2009-07-02 Thread Bruce Momjian
Tom Lane wrote: Peter Eisentraut pete...@gmx.net writes: On Friday 19 June 2009 00:56:42 Bruce Momjian wrote: A third install method is to use PGXS (assuming the new 'pg_config' is in your $PATH): USE_PGXS=1 gmake prefix=/usr/local/pgsql.new install Maybe the latter method should

Re: [HACKERS] First CommitFest: July 15th

2009-07-02 Thread Robert Haas
On Thu, Jul 2, 2009 at 5:50 PM, Greg Starkgsst...@mit.edu wrote: So I currently have some free time as I'm currently between jobs. I can start going through the queued patches in the next few weeks. Should I be looking at the wiki currently? Or is your tool ready to go? Wiki for now. Brendan

Re: [HACKERS] [PATCH] SE-PostgreSQL Updates rev.2096

2009-07-02 Thread Robert Haas
2009/6/30 KaiGai Kohei kai...@ak.jp.nec.com: The SE-PostgreSQL patches are updated as follows: 01) http://sepgsql.googlecode.com/files/sepgsql-01-sysatt-8.4-r2096.patch 02) http://sepgsql.googlecode.com/files/sepgsql-02-core-8.4-r2096.patch 03)

Re: [HACKERS] Synch Rep: direct transfer of WAL file from the primary to the standby

2009-07-02 Thread Robert Haas
On Tue, Jun 16, 2009 at 2:13 AM, Fujii Masaomasao.fu...@gmail.com wrote: The attached latest patch provides this capability. You can easily set up the synch rep according to the following procedure. http://wiki.postgresql.org/wiki/NTT%27s_Development_Projects#How_to_set_up_Synch_Rep This patch

Re: [HACKERS] Synch Rep: direct transfer of WAL file from the primary to the standby

2009-07-02 Thread Robert Haas
On Thu, Jul 2, 2009 at 10:02 PM, Robert Haasrobertmh...@gmail.com wrote: Second, I am wondering whether Heikki feels that it would be useful to assign round-robin reviewers for this patch, or whether he's going to be the principal reviewer himself.  We could assign either a reviewer (or

Re: [HACKERS] First CommitFest: July 15th

2009-07-02 Thread Robert Haas
On Thu, Jul 2, 2009 at 3:42 PM, Zdenek Kotalazdenek.kot...@sun.com wrote: Josh Berkus píše v st 01. 07. 2009 v 17:21 -0700: Folks, There's been a lot of discussion/argument around how to handle the last commitfest, but there seems to be a total consensus that we want to have the first CF on

Re: [HACKERS] Synch Rep: direct transfer of WAL file from the primary to the standby

2009-07-02 Thread Alvaro Herrera
Robert Haas escribió: Second, I am wondering whether Heikki feels that it would be useful to assign round-robin reviewers for this patch, or whether he's going to be the principal reviewer himself. We could assign either a reviewer (or reviewers) to the whole patch, or we could assign

Re: [HACKERS] [PATCH] SE-PostgreSQL Updates rev.2096

2009-07-02 Thread KaiGai Kohei
Robert Haas wrote: 2009/6/30 KaiGai Kohei kai...@ak.jp.nec.com: The SE-PostgreSQL patches are updated as follows: 01) http://sepgsql.googlecode.com/files/sepgsql-01-sysatt-8.4-r2096.patch 02) http://sepgsql.googlecode.com/files/sepgsql-02-core-8.4-r2096.patch 03)

Re: [HACKERS] Synch Rep: direct transfer of WAL file from the primary to the standby

2009-07-02 Thread Fujii Masao
Hi, On Fri, Jul 3, 2009 at 11:02 AM, Robert Haasrobertmh...@gmail.com wrote: On Tue, Jun 16, 2009 at 2:13 AM, Fujii Masaomasao.fu...@gmail.com wrote: The attached latest patch provides this capability. You can easily set up the synch rep according to the following procedure.

Re: [HACKERS] Synch Rep: direct transfer of WAL file from the primary to the standby

2009-07-02 Thread Fujii Masao
Hi, On Fri, Jul 3, 2009 at 11:59 AM, Alvaro Herreraalvhe...@commandprompt.com wrote: WRT the signal handling piece, I remember something in that area being committed and then reverted because it had issues.  Does this version fix those issues?  (Assuming it's the same patch) Yes. After the

[HACKERS] commitfest.postgresql.org

2009-07-02 Thread Robert Haas
Per Dave Page's request of this morning, my CommitFest management application now has a real hostname (see subject line). I have also sent Dave an email with details of the install process and location of files, per his request (let me know if there's somewhere else those details should be

Re: [HACKERS] Synch Rep: direct transfer of WAL file from the primary to the standby

2009-07-02 Thread Robert Haas
On Fri, Jul 3, 2009 at 12:32 AM, Fujii Masaomasao.fu...@gmail.com wrote: Hi, On Fri, Jul 3, 2009 at 11:02 AM, Robert Haasrobertmh...@gmail.com wrote: On Tue, Jun 16, 2009 at 2:13 AM, Fujii Masaomasao.fu...@gmail.com wrote: The attached latest patch provides this capability. You can easily set

Re: [HACKERS] [PATCH] SE-PostgreSQL Updates rev.2096

2009-07-02 Thread Robert Haas
On Thu, Jul 2, 2009 at 10:45 PM, KaiGai Koheikai...@kaigai.gr.jp wrote: Right now, I think it is preferable to focus on the first three patches at the first commit fest. What's your opinion? If the first three patches are the least amount of code that makes a complete feature, then that's the

Re: [HACKERS] Synch Rep: direct transfer of WAL file from the primary to the standby

2009-07-02 Thread Fujii Masao
Hi, On Fri, Jul 3, 2009 at 2:01 PM, Robert Haasrobertmh...@gmail.com wrote: My preference for ease of CommitFest management would be one thread on -hackers for each chunk that can be separately reviewed and committed.  So if there are three severable chunks here, send a patch for each one

Re: [HACKERS] HEAD is open for 8.5 development

2009-07-02 Thread Greg Smith
On Thu, 2 Jul 2009, Robert Haas wrote: I think it's important to clarify the distinction between when a committer is planning to look at the patch but maybe somebody else should too, and when the committer is planning to take exclusive responsibility for the patch and nobody else should

Re: [HACKERS] [PATCH] SE-PostgreSQL Updates rev.2096

2009-07-02 Thread KaiGai Kohei
Robert Haas wrote: On Thu, Jul 2, 2009 at 10:45 PM, KaiGai Koheikai...@kaigai.gr.jp wrote: Right now, I think it is preferable to focus on the first three patches at the first commit fest. What's your opinion? If the first three patches are the least amount of code that makes a complete

Re: [HACKERS] [pgsql-www] commitfest.postgresql.org

2009-07-02 Thread Brendan Jurd
2009/7/3 Robert Haas robertmh...@gmail.com:  Also, we're currently missing the reviewer names due to limitations of the import script; Brendan is fixing this. Update: The reviewer names have now been populated. Cheers, BJ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)

Re: [HACKERS] [pgsql-www] commitfest.postgresql.org

2009-07-02 Thread Jaime Casanova
On Fri, Jul 3, 2009 at 12:34 AM, Brendan Jurddire...@gmail.com wrote: 2009/7/3 Robert Haas robertmh...@gmail.com:  Also, we're currently missing the reviewer names due to limitations of the import script; Brendan is fixing this. Update: The reviewer names have now been populated. looks

Re: [HACKERS] [pgsql-www] commitfest.postgresql.org

2009-07-02 Thread Brendan Jurd
2009/7/3 Jaime Casanova jcasa...@systemguards.com.ec: On Fri, Jul 3, 2009 at 12:34 AM, Brendan Jurddire...@gmail.com wrote: 2009/7/3 Robert Haas robertmh...@gmail.com:  Also, we're currently missing the reviewer names due to limitations of the import script; Brendan is fixing this. Update: