Re: [HACKERS] ask for review of MERGE

2010-09-29 Thread Greg Smith
Starting looking at the latest MERGE patch from Boxuan here tonight. The regression tests pass for me here, good starting sign. I expect to move onto trying to break it more creatively next, then onto performance tests. Nothing much more exciting than that to report so far. It had suffered

Re: [HACKERS] libpq changes for synchronous replication

2010-09-29 Thread Fujii Masao
On Tue, Sep 21, 2010 at 1:17 AM, Tom Lane t...@sss.pgh.pa.us wrote: Heikki Linnakangas heikki.linnakan...@enterprisedb.com writes: It doesn't feel right to always accept PQputCopyData in COPY OUT mode, though. IMHO there should be a new COPY IN+OUT mode. Yeah, I was going to make the same

Re: [HACKERS] recovery.conf location

2010-09-29 Thread Fujii Masao
On Tue, Sep 28, 2010 at 10:34 PM, Robert Haas robertmh...@gmail.com wrote: The idea of relying on the existence of recovery.conf to determine whether we should continue recovery forever or switch to normal running seems somewhat klunky to me.  It mixes up settings with control information.  

Re: I: [HACKERS] About Our CLUSTER implementation is pessimal patch

2010-09-29 Thread Leonardo Francalanci
10% is nothing. I was expecting this patch would give an order of magnitude of improvement or somethine like that in the worst cases of the current code (highly unsorted input) Yes. It should be x10 faster than ordinary method in the worst cases. Here's my post with a (very simple)

[HACKERS] operator dependency of commutator and negator

2010-09-29 Thread Itagaki Takahiro
When we drop an operator used by other operators as COMMUTATOR or NEGATOR, pg_dump generates an invalid SQL command for the operators depending on the dropped one. Is it an unavoidable restriction? CREATE OPERATOR ( PROCEDURE = text_lt, LEFTARG = text, RIGHTARG = text, COMMUTATOR = );

Re: [HACKERS] patch: SQL/MED(FDW) DDL

2010-09-29 Thread Shigeru HANADA
On Tue, 28 Sep 2010 10:26:42 -0400 Robert Haas robertmh...@gmail.com wrote: On Mon, Sep 27, 2010 at 2:50 AM, SAKAMOTO Masahiko sakamoto.masah...@oss.ntt.co.jp wrote: ?http://wiki.postgresql.org/wiki/SQL/MED With regard to what is written here, it strikes me that it would be an extremely bad

Re: [HACKERS] is sync rep stalled?

2010-09-29 Thread Fujii Masao
On Wed, Sep 29, 2010 at 11:47 AM, Robert Haas robertmh...@gmail.com wrote: So we've got two patches that implement synchronous replication, and no agreement on which one, if either, should be committed.  We have no agreement on how synchronous replication should be configured, and at most a

Re: [HACKERS] string function - format function proposal

2010-09-29 Thread Pavel Stehule
Hello 2010/9/29 Itagaki Takahiro itagaki.takah...@gmail.com: On Thu, Sep 9, 2010 at 8:57 PM, Pavel Stehule pavel.steh...@gmail.com wrote: I am sending a updated version. changes: * tag %v removed from format function, * proprietary tags %lq a iq removed from sprintf * code cleaned patch

Re: [HACKERS] Stalled post to pgsql-committers

2010-09-29 Thread Magnus Hagander
On Wed, Sep 29, 2010 at 10:08, Peter Eisentraut pete...@gmx.net wrote: On sön, 2010-09-26 at 17:11 +0200, Magnus Hagander wrote: On Sun, Sep 26, 2010 at 15:39, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: On 25/09/10 19:43, Peter Eisentraut wrote: I'm not subscribed to

Re: [HACKERS] Standby registration

2010-09-29 Thread Fujii Masao
On Thu, Sep 23, 2010 at 6:49 PM, Dimitri Fontaine dfonta...@hi-media.com wrote: Automatic registration is a good answer to both your points A) monitoring and C) wal_keep_segments, but needs some more thinking wrt security and authentication. Aside from standby registration itself, I have

Re: [HACKERS] Using streaming replication as log archiving

2010-09-29 Thread Magnus Hagander
On Wed, Sep 29, 2010 at 05:40, Fujii Masao masao.fu...@gmail.com wrote: On Tue, Sep 28, 2010 at 5:23 PM, Magnus Hagander mag...@hagander.net wrote: When I ran that, the size of the WAL file in inprogress directory became more than 16MB. Obviously something isn't right. Wow, that's weird. I'm

Re: [HACKERS] Stalled post to pgsql-committers

2010-09-29 Thread Peter Eisentraut
On ons, 2010-09-29 at 10:19 +0200, Magnus Hagander wrote: Btw., I think it would be more proper if the commit notifications contained a header like Sender: g...@gitmaster.postgresql.org so that they don't give a false impression about the origin of the message. We discussed that

Re: [HACKERS] git diff --patience

2010-09-29 Thread Peter Eisentraut
On ons, 2010-09-15 at 12:58 -0500, Kevin Grittner wrote: I just discovered the --patience flag on the git diff command, and I'd like to suggest that we encourage people to use it when possible for building patches. I just looked at output with and without it (and for good measure, before and

Re: [HACKERS] security hook on table creation

2010-09-29 Thread KaiGai Kohei
Thanks for your reviewing, and sorry for delayed responding due to the LinuxCon Japan for a couple of days. (2010/09/28 12:57), Robert Haas wrote: 2010/9/1 KaiGai Koheikai...@ak.jp.nec.com: This patch allows external security providers to check privileges to create a new relation and to inform

[HACKERS] Git downed?

2010-09-29 Thread KaiGai Kohei
Does the git.postgresql.org down? Harada-san being also unreachable now. -- KaiGai Kohei kai...@kaigai.gr.jp -- 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] Git downed?

2010-09-29 Thread Peter Geoghegan
It looks that way to me too. .Oh wait, it works now. -- Regards, Peter Geoghegan -- 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] Git downed?

2010-09-29 Thread Dave Page
2010/9/29 KaiGai Kohei kai...@kaigai.gr.jp: Does the git.postgresql.org down? Harada-san being also unreachable now. Seems to be a network issue. It's fine for some people (like me), and down for others. Thom reports that it's now back for him. -- Dave Page Blog: http://pgsnake.blogspot.com

Re: [HACKERS] Git downed?

2010-09-29 Thread KaiGai Kohei
(2010/09/29 20:53), Dave Page wrote: 2010/9/29 KaiGai Koheikai...@kaigai.gr.jp: Does the git.postgresql.org down? Harada-san being also unreachable now. Seems to be a network issue. It's fine for some people (like me), and down for others. Thom reports that it's now back for him. Now I'm

Re: I: [HACKERS] About Our CLUSTER implementation is pessimal patch

2010-09-29 Thread Alvaro Herrera
Excerpts from Leonardo Francalanci's message of mié sep 29 03:17:07 -0400 2010: Here's my post with a (very simple) performance test: http://archives.postgresql.org/pgsql-hackers/2010-02/msg00766.php I think the 10M rows test is more in line with what we want (83s vs. 646). -- Álvaro

Re: [HACKERS] patch: SQL/MED(FDW) DDL

2010-09-29 Thread Shigeru HANADA
On Tue, 28 Sep 2010 22:14:22 +0300 Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: On 09/28/10 17:26, Robert Haas wrote: First, it seems totally wrong to assume that the same functions and operators will be defined on the remote side as you have locally; indeed, for CSV files,

Re: I: [HACKERS] About Our CLUSTER implementation is pessimal patch

2010-09-29 Thread Alvaro Herrera
Excerpts from Itagaki Takahiro's message of mié sep 29 01:25:38 -0400 2010: To be exact, It's very complex. During reconstructing tables, it requires about twice disk space of the old table (for sort tapes and the new table). After sorting the table, CLUSTER performs REINDEX. We need {same

Re: [HACKERS] security hook on table creation

2010-09-29 Thread Robert Haas
On Wed, Sep 29, 2010 at 6:38 AM, KaiGai Kohei kai...@kaigai.gr.jp wrote: I don't think it is an option to move the hook after the pollution of system catalogs, although we can pull out any information about the new relation from syscache. Why not? Sorry, it seems to me the idea simplifies

Re: [HACKERS] recovery.conf location

2010-09-29 Thread Robert Haas
On Wed, Sep 29, 2010 at 3:14 AM, Fujii Masao masao.fu...@gmail.com wrote: On Tue, Sep 28, 2010 at 10:34 PM, Robert Haas robertmh...@gmail.com wrote: The idea of relying on the existence of recovery.conf to determine whether we should continue recovery forever or switch to normal running seems

Re: [HACKERS] ask for review of MERGE

2010-09-29 Thread Josh Kupershmidt
On Wed, Sep 29, 2010 at 2:44 AM, Greg Smith g...@2ndquadrant.com wrote: The rest of the compiler warnings I saw didn't look related to his code, maybe stuff my picky Ubuntu compiler is noticing that was done recently to HEAD. I haven't checked HEAD without this patch yet to confirm, and am

Re: I: [HACKERS] About Our CLUSTER implementation is pessimal patch

2010-09-29 Thread Robert Haas
On Wed, Sep 29, 2010 at 1:12 AM, Itagaki Takahiro itagaki.takah...@gmail.com wrote: On Wed, Sep 29, 2010 at 1:27 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: I see a consistent ~10% advantage for the sequential scan clusters. 10% is nothing.  I was expecting this patch would give an

Re: [HACKERS] ask for review of MERGE

2010-09-29 Thread Robert Haas
On Wed, Sep 29, 2010 at 2:44 AM, Greg Smith g...@2ndquadrant.com wrote: One compiler warning I noticed that needs to get resolved: src/backend/commands/explain.c: explain.c: In function ‘ExplainMergeActions’: explain.c:1528: warning: comparison of distinct pointer types lacks a cast That

Re: [HACKERS] ask for review of MERGE

2010-09-29 Thread Boxuan Zhai
On Wed, Sep 29, 2010 at 9:16 PM, Robert Haas robertmh...@gmail.com wrote: On Wed, Sep 29, 2010 at 2:44 AM, Greg Smith g...@2ndquadrant.com wrote: One compiler warning I noticed that needs to get resolved: src/backend/commands/explain.c: explain.c: In function ‘ExplainMergeActions’:

Re: [HACKERS] [BUGS] BUG #5305: Postgres service stops when closing Windows session

2010-09-29 Thread Magnus Hagander
On Mon, Sep 27, 2010 at 14:34, Dave Page dp...@pgadmin.org wrote: On Thu, Sep 9, 2010 at 9:09 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: It's hard to say what the safest option is, I think.  There seem to be basically three proposals on the table: 1.

Re: [HACKERS] [BUGS] BUG #5305: Postgres service stops when closing Windows session

2010-09-29 Thread Magnus Hagander
On Mon, Sep 27, 2010 at 14:34, Dave Page dp...@pgadmin.org wrote: On Thu, Sep 9, 2010 at 9:09 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: It's hard to say what the safest option is, I think.  There seem to be basically three proposals on the table: 1.

Re: [HACKERS] [BUGS] BUG #5305: Postgres service stops when closing Windows session

2010-09-29 Thread Dave Page
On Wed, Sep 29, 2010 at 2:45 PM, Magnus Hagander mag...@hagander.net wrote: On Mon, Sep 27, 2010 at 14:34, Dave Page dp...@pgadmin.org wrote: On Thu, Sep 9, 2010 at 9:09 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: It's hard to say what the safest option is,

Re: [HACKERS] security hook on table creation

2010-09-29 Thread Alvaro Herrera
Excerpts from KaiGai Kohei's message of mié sep 29 06:38:09 -0400 2010: (2010/09/28 12:57), Robert Haas wrote: 2010/9/1 KaiGai Koheikai...@ak.jp.nec.com: This patch allows external security providers to check privileges to create a new relation and to inform the security labels to be

Re: [HACKERS] security hook on table creation

2010-09-29 Thread KaiGai Kohei
(2010/09/29 22:00), Robert Haas wrote: On Wed, Sep 29, 2010 at 6:38 AM, KaiGai Koheikai...@kaigai.gr.jp wrote: I don't think it is an option to move the hook after the pollution of system catalogs, although we can pull out any information about the new relation from syscache. Why not? All

Re: [HACKERS] recovery.conf location

2010-09-29 Thread Tom Lane
Fujii Masao masao.fu...@gmail.com writes: On Tue, Sep 28, 2010 at 10:34 PM, Robert Haas robertmh...@gmail.com wrote: The idea of relying on the existence of recovery.conf to determine whether we should continue recovery forever or switch to normal running seems somewhat klunky to me.  It mixes

Re: [HACKERS] patch: SQL/MED(FDW) DDL

2010-09-29 Thread Alvaro Herrera
Excerpts from Robert Haas's message of mar sep 28 10:26:54 -0400 2010: Then: - Begin a sequential scan with the following set of quals. - Begin an index scan using the index called X with the following set of quals. - Fetch next tuple. - End scan. I'm not sure that it's a good idea to

Re: [HACKERS] git diff --patience

2010-09-29 Thread Kevin Grittner
Peter Eisentraut pete...@gmx.net wrote: I have tried this switch various times now and haven't seen any difference at all in the output. Do you have an existing commit where you see a difference so I can try it and see if there is some other problem that my local configuration has? Having

Re: I: [HACKERS] About Our CLUSTER implementation is pessimal patch

2010-09-29 Thread Itagaki Takahiro
On Wed, Sep 29, 2010 at 10:14 PM, Robert Haas robertmh...@gmail.com wrote: http://reorg.projects.postgresql.org/ Can you reproduce that with this patch? No, I can't use the machine anymore. -- Itagaki Takahiro -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] operator dependency of commutator and negator

2010-09-29 Thread Alvaro Herrera
Excerpts from Itagaki Takahiro's message of mié sep 29 03:56:33 -0400 2010: When we drop an operator used by other operators as COMMUTATOR or NEGATOR, pg_dump generates an invalid SQL command for the operators depending on the dropped one. Is it an unavoidable restriction? Maybe we need a

Re: [HACKERS] documentation udpates to pgupgrade.html

2010-09-29 Thread Colin 't Hart
Bruce, To query for Postgresql services on Windows use: sc query type= service | find postgresql On my machine this yields: SERVICE_NAME: postgresql-9.0 DISPLAY_NAME: postgresql-9.0 - PostgreSQL Server 9.0 NB the space after type= is very important, don't ask me why... I prefer to use

[HACKERS] Unable to generate man pages for translated sgml

2010-09-29 Thread Tatsuo Ishii
Hi, Starting from 9.0, it seems unable to generate man pages for Japanese translated sgml(generating html is ok). Until 8.4 it worked fine. Does anybody succeeded in generating non English/multibyte translated man pages? -- Tatsuo Ishii SRA OSS, Inc. Japan English:

Re: [HACKERS] [BUGS] BUG #5305: Postgres service stops when closing Windows session

2010-09-29 Thread Magnus Hagander
On Wed, Sep 29, 2010 at 15:54, Dave Page dp...@pgadmin.org wrote: On Wed, Sep 29, 2010 at 2:45 PM, Magnus Hagander mag...@hagander.net wrote: On Mon, Sep 27, 2010 at 14:34, Dave Page dp...@pgadmin.org wrote: On Thu, Sep 9, 2010 at 9:09 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas

Re: [HACKERS] Stalled post to pgsql-committers

2010-09-29 Thread Peter Eisentraut
On sön, 2010-09-26 at 17:11 +0200, Magnus Hagander wrote: On Sun, Sep 26, 2010 at 15:39, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: On 25/09/10 19:43, Peter Eisentraut wrote: I'm not subscribed to pgsql-committers, but apparently under the new git-enabled setup, I'm

Re: [HACKERS] operator dependency of commutator and negator

2010-09-29 Thread Tom Lane
Alvaro Herrera alvhe...@commandprompt.com writes: Excerpts from Itagaki Takahiro's message of mié sep 29 03:56:33 -0400 2010: When we drop an operator used by other operators as COMMUTATOR or NEGATOR, pg_dump generates an invalid SQL command for the operators depending on the dropped one. Is

Re: [HACKERS] Path question

2010-09-29 Thread Robert Haas
On Tue, Sep 28, 2010 at 11:13 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: ...what makes the pathkeys potentially useful is that they match the root pathkeys for the query.  However, without Greg's hacks, the transposed child equivalence classes don't show

Re: [HACKERS] recovery.conf location

2010-09-29 Thread Robert Haas
On Wed, Sep 29, 2010 at 10:02 AM, Tom Lane t...@sss.pgh.pa.us wrote: Fujii Masao masao.fu...@gmail.com writes: On Tue, Sep 28, 2010 at 10:34 PM, Robert Haas robertmh...@gmail.com wrote: The idea of relying on the existence of recovery.conf to determine whether we should continue recovery

Re: [HACKERS] operator dependency of commutator and negator

2010-09-29 Thread Itagaki Takahiro
On Wed, Sep 29, 2010 at 11:56 PM, Tom Lane t...@sss.pgh.pa.us wrote: I'm not sure that fixing this case is worth the amount of work it'd take.  How often do you drop just one member of a commutator pair? I found the issue when an user tries to write a safe installer script under DROP before

Re: [HACKERS] git diff --patience

2010-09-29 Thread Kevin Grittner
Peter Eisentraut pete...@gmx.net wrote: Do you have an existing commit where you see a difference so I can try it and see if there is some other problem that my local configuration has? Random poking around in the postgresql.git commits didn't turn up any where it mattered, so here's before

Re: [HACKERS] security hook on table creation

2010-09-29 Thread Stephen Frost
KaiGai, * KaiGai Kohei (kai...@kaigai.gr.jp) wrote: All the existing security checks applies before modifying system catalogs. At least, I cannot find out any constructive reason why we try to apply permission checks on object creation time with different manner towards the existing

Re: [HACKERS] operator dependency of commutator and negator

2010-09-29 Thread Tom Lane
Itagaki Takahiro itagaki.takah...@gmail.com writes: On Wed, Sep 29, 2010 at 11:56 PM, Tom Lane t...@sss.pgh.pa.us wrote: I'm not sure that fixing this case is worth the amount of work it'd take. How often do you drop just one member of a commutator pair? I found the issue when an user tries

Re: [HACKERS] security hook on table creation

2010-09-29 Thread Robert Haas
On Wed, Sep 29, 2010 at 9:59 AM, KaiGai Kohei kai...@kaigai.gr.jp wrote: (2010/09/29 22:00), Robert Haas wrote: On Wed, Sep 29, 2010 at 6:38 AM, KaiGai Koheikai...@kaigai.gr.jp  wrote: I don't think it is an option to move the hook after the pollution of system catalogs, although we can pull

Re: I: [HACKERS] About Our CLUSTER implementation is pessimal patch

2010-09-29 Thread Leonardo Francalanci
Here's my post with a (very simple) performance test: http://archives.postgresql.org/pgsql-hackers/2010-02/msg00766.php I think the 10M rows test is more in line with what we want (83s vs. 646). Can someone else test the patch to see if what I found is still valid? I don't think it makes

Re: [HACKERS] Stalled post to pgsql-committers

2010-09-29 Thread Magnus Hagander
On Wed, Sep 29, 2010 at 17:31, Marc G. Fournier scra...@hub.org wrote: On Wed, 29 Sep 2010, Alvaro Herrera wrote: Excerpts from Peter Eisentraut's message of mi? sep 29 04:08:35 -0400 2010: On s?n, 2010-09-26 at 17:11 +0200, Magnus Hagander wrote: Yeah, that's what you need to do. I would

Re: [HACKERS] documentation udpates to pgupgrade.html

2010-09-29 Thread Massa, Harald Armin
Colin, To query for Postgresql services on Windows use: sc query type= service | find postgresql sad news is that (at least on my computer) it only finds running services. Harald -- GHUM GmbH Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 Amtsgericht Stuttgart,

Re: [HACKERS] Unable to generate man pages for translated sgml

2010-09-29 Thread Peter Eisentraut
On ons, 2010-09-29 at 23:22 +0900, Tatsuo Ishii wrote: Starting from 9.0, it seems unable to generate man pages for Japanese translated sgml(generating html is ok). Until 8.4 it worked fine. Does anybody succeeded in generating non English/multibyte translated man pages? You leave a lot to be

Re: [HACKERS] documentation udpates to pgupgrade.html

2010-09-29 Thread Colin 't Hart
Oops. Apparently type= service is the default, so we can remove that bit. Then we should add state= all. The default = active, a third option = inactive. So: sc query state= all should list all services, in all states. And then we pipe to find which is the Windows equivalent of grep, but it

Re: [HACKERS] recovery.conf location

2010-09-29 Thread Dimitri Fontaine
Robert Haas robertmh...@gmail.com writes: On Wed, Sep 29, 2010 at 10:02 AM, Tom Lane t...@sss.pgh.pa.us wrote: I think keeping the status information in a transient text file may still be a good design choice.  If you push it into pg_control it will be impossible to modify by hand. It could

[HACKERS] Postgres vs. intel ccNUMA on Linux

2010-09-29 Thread James Robinson
Hackers, Any tips / conventional wisdom regarding running postgres on large- ish memory ccNUMA intel machines, such as a 32G dual-quad-core, showing two NUMA nodes of 16G each? I expect each postgres backend's non-shared memory usage to remain nice and reasonably sized, hopefully staying

Re: [HACKERS] Stalled post to pgsql-committers

2010-09-29 Thread Marc G. Fournier
Done On Wed, 29 Sep 2010, Magnus Hagander wrote: On Wed, Sep 29, 2010 at 17:31, Marc G. Fournier scra...@hub.org wrote: On Wed, 29 Sep 2010, Alvaro Herrera wrote: Excerpts from Peter Eisentraut's message of mi? sep 29 04:08:35 -0400 2010: On s?n, 2010-09-26 at 17:11 +0200, Magnus

Re: [HACKERS] recovery.conf location

2010-09-29 Thread Robert Haas
On Wed, Sep 29, 2010 at 3:09 PM, Dimitri Fontaine dfonta...@hi-media.com wrote: Robert Haas robertmh...@gmail.com writes: On Wed, Sep 29, 2010 at 10:02 AM, Tom Lane t...@sss.pgh.pa.us wrote: I think keeping the status information in a transient text file may still be a good design choice.  If

[HACKERS] the way to get tupledesc from ArrayType

2010-09-29 Thread Pavel Stehule
Hello What is the way to get tupledesc from array of records? Regards Pavel Stehule -- 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] Using streaming replication as log archiving

2010-09-29 Thread Kevin Grittner
Magnus Hagander mag...@hagander.net wrote: Comments and contributions are most welcome. This is probably too esoteric to be worked on yet, but for this to be useful for us we would need to pass the resulting files through pg_clearxlogtail and gzip in an automated fashion. And we would need

Re: [HACKERS] Unable to generate man pages for translated sgml

2010-09-29 Thread Tatsuo Ishii
On ons, 2010-09-29 at 23:22 +0900, Tatsuo Ishii wrote: Starting from 9.0, it seems unable to generate man pages for Japanese translated sgml(generating html is ok). Until 8.4 it worked fine. Does anybody succeeded in generating non English/multibyte translated man pages? You leave a lot to

[HACKERS] external pid file

2010-09-29 Thread Euler Taveira de Oliveira
Hi, Is there any reason the postmaster.pid and external_pid_file contents to be different? -- Euler Taveira de Oliveira http://www.timbira.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] Unable to generate man pages for translated sgml

2010-09-29 Thread Itagaki Takahiro
On Thu, Sep 30, 2010 at 8:09 AM, Tatsuo Ishii is...@postgresql.org wrote: Japanese community has been using the DocBook/SGML tool chain with EUC-JP translated documents since SGML was emplyed by PostgreSQL. Problem with 9.0 doc build system is now it's a mixture of DocBook/SGML *and*

[HACKERS] Patch to reindex primary keys

2010-09-29 Thread Gurjeet Singh
Attached is a patch that implements replacing a primary key with another index. This would help overcome the limitation that primary keys cannot be reindexed without taking exclusive locks. The use case is to create an identical index, concurrenlty, with the same structure as the primary

Re: [HACKERS] english parser in text search: support for multiple words in the same position

2010-09-29 Thread Robert Haas
On Wed, Sep 29, 2010 at 1:29 AM, Sushant Sinha sushant...@gmail.com wrote: Any updates on this? On Tue, Sep 21, 2010 at 10:47 PM, Sushant Sinha sushant...@gmail.com wrote: I looked at this patch a bit.  I'm fairly unhappy that it seems to be inventing a brand new mechanism to do

Re: [HACKERS] Path question

2010-09-29 Thread Greg Stark
2010/9/23 Robert Haas robertmh...@gmail.com: All of this leaves me wondering why Greg ended up ifdefing out this code in the first place.  There's probably something I'm missing here...  but for now I can't think of a better idea than just removing the #ifdefs and hoping that whatever problem

Re: [HACKERS] is sync rep stalled?

2010-09-29 Thread Robert Haas
On Wed, Sep 29, 2010 at 3:56 AM, Fujii Masao masao.fu...@gmail.com wrote: On Wed, Sep 29, 2010 at 11:47 AM, Robert Haas robertmh...@gmail.com wrote: So we've got two patches that implement synchronous replication, and no agreement on which one, if either, should be committed.  We have no

Re: [HACKERS] Unable to generate man pages for translated sgml

2010-09-29 Thread Tatsuo Ishii
On Thu, Sep 30, 2010 at 8:09 AM, Tatsuo Ishii is...@postgresql.org wrote: Japanese community has been using the DocBook/SGML tool chain with EUC-JP translated documents since SGML was emplyed by PostgreSQL. Problem with 9.0 doc build system is now it's a mixture of DocBook/SGML *and*

Re: [HACKERS] security hook on table creation

2010-09-29 Thread KaiGai Kohei
(2010/09/30 0:36), Robert Haas wrote: On Wed, Sep 29, 2010 at 9:59 AM, KaiGai Koheikai...@kaigai.gr.jp wrote: (2010/09/29 22:00), Robert Haas wrote: On Wed, Sep 29, 2010 at 6:38 AM, KaiGai Koheikai...@kaigai.gr.jpwrote: I don't think it is an option to move the hook after the pollution

Re: [HACKERS] security hook on table creation

2010-09-29 Thread Robert Haas
2010/9/29 KaiGai Kohei kai...@ak.jp.nec.com: But with that exception, they seemed to think that coarse-grained permissions would be fine for a basic implementation: perhaps even just install something in ProcessUtility_hook and bounce DDL across the board, so long as it's controlled by

Re: [HACKERS] patch: SQL/MED(FDW) DDL

2010-09-29 Thread Itagaki Takahiro
On Wed, Sep 29, 2010 at 11:09 PM, Alvaro Herrera alvhe...@commandprompt.com wrote: I'm not sure that it's a good idea to embed into the FDW API the set of operations known to the executor.  For example your proposal fails to consider bitmap scans.  Seems simpler and more general to hand the

Re: [HACKERS] security hook on table creation

2010-09-29 Thread KaiGai Kohei
(2010/09/30 10:28), Robert Haas wrote: 2010/9/29 KaiGai Koheikai...@ak.jp.nec.com: But with that exception, they seemed to think that coarse-grained permissions would be fine for a basic implementation: perhaps even just install something in ProcessUtility_hook and bounce DDL across the

Re: [HACKERS] Path question

2010-09-29 Thread Robert Haas
On Wed, Sep 29, 2010 at 11:01 AM, Robert Haas robertmh...@gmail.com wrote: Makes sense to me.  It seems that there are actually two halves to this problem: getting the child EMs to be generated in the first place, and then getting them to be examined at the appropriate time. So I tried out the

Re: [HACKERS] Fw: patch for pg_ctl.c to add windows service start-type

2010-09-29 Thread Itagaki Takahiro
Hi, I have a question about the latest patch. On Sun, Aug 22, 2010 at 11:03 PM, Quan Zongliang quanzongli...@gmail.com wrote: New patch attached. How about this? I don't see us ever using anything other than auto or demand. The others aren't for regular services + set_starttype(char

Re: I: [HACKERS] About Our CLUSTER implementation is pessimal patch

2010-09-29 Thread Josh Kupershmidt
On Wed, Sep 29, 2010 at 11:55 AM, Leonardo Francalanci m_li...@yahoo.it wrote: Can someone else test the patch to see if what I found is still valid? I don't think it makes much sense if I'm the only one that says this is faster :) I ran a few more performance tests on this patch. Here's what

Re: [HACKERS] recovery.conf location

2010-09-29 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: But that's not what Tom is talking about, I don't think: you might also want a way to explicitly whack the flag in pg_control around. That would probably be along the lines of pg_resetxlog. I'm not sure how much use case there is for such a thing, but

[HACKERS] starting to review the Extend NOT NULL representation to pg_constraint patch

2010-09-29 Thread Andrew Geery
Reference: https://commitfest.postgresql.org/action/patch_view?id=312 The patch from http://archives.postgresql.org/message-id/ca2e4c4762eae28d68404...@amenophis does not apply cleanly to the current git master: $ patch -p1 extend_not_null.patch patching file src/backend/catalog/heap.c

Re: [HACKERS] Unable to generate man pages for translated sgml

2010-09-29 Thread Peter Eisentraut
On tor, 2010-09-30 at 08:09 +0900, Tatsuo Ishii wrote: Problem with 9.0 doc build system is now it's a mixture of DocBook/SGML *and* DocBook/XML(used for man pages). The former *only* accepts EUC-JP, the latter *only* accepts UTF-8. So we are stuck. How do you get to the conclusion that