[HACKERS] Update obsolete text in indexam.sgml

2012-11-04 Thread Etsuro Fujita
ISTM it would be better to update the text about index cost estimation in indexam.sgml. Please find attached a patch. Thanks, Best regards, Etsuro Fujita indexam.sgml.patch Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] [PATCH]Tablesample Submission

2012-11-04 Thread Qi Huang
Dear hackers Sorry for not replying the patch review. I didn't see the review until recently as my mail box is full of Postgres mails and I didn't notice the one for me, my mail box configuration problem. I am still kind of busy with my university final year project. I shall not have tim

Re: [HACKERS] Synchronous commit not... synchronous?

2012-11-04 Thread Peter van Hardenberg
On Fri, Nov 2, 2012 at 11:16 AM, Peter Eisentraut wrote: > > Did the inserted row also arrive at the standby? > No, as there was no standby. -- Peter van Hardenberg San Francisco, California "Everything was beautiful, and nothing hurt." -- Kurt Vonnegut

Re: [HACKERS] Synchronous commit not... synchronous?

2012-11-04 Thread Robert Haas
On Sat, Nov 3, 2012 at 5:44 PM, Florian Weimer wrote: > * Daniel Farina: >> The idea of canceling a COMMIT statement causing a COMMIT seems pretty >> strange to me. > > Canceling commits is inherently racy, so I'm not sure if this behavior > so strange after all. Yeah. You can't make the local f

Re: [HACKERS] Bug in ALTER COLUMN SET DATA TYPE ?

2012-11-04 Thread Tom Lane
Pavan Deolasee writes: > On Sat, Nov 3, 2012 at 10:21 AM, Nikhil Sontakke wrote: So coming back to the issue, do you think it's a good idea to teach ATAddCheckConstraint() that the call is coming from a late phase of ALTER TABLE ? >>> +1 >> You mentioned AT_PASS_OLD_INDEX in your

Re: [HACKERS] Arguments to foreign tables?

2012-11-04 Thread Willem Leenen
> > what does that even mean?how would 'data' accept 'arguments' ??! > > That's Sherlock Holmes! "Don't argue with your data"

Re: [HACKERS] Arguments to foreign tables?

2012-11-04 Thread John R Pierce
On 11/04/12 11:59 AM, Jeff Davis wrote: Is there any fundamental or philosophical reason why a foreign table can't accept arguments? Should that be a TODO? what does that even mean?how would 'data' accept 'arguments' ??! -- john r pierceN 37, W 122 santa cruz

Re: [HACKERS] Arguments to foreign tables?

2012-11-04 Thread Willem Leenen
I don't understand the question. A table accepting arguments? What do you mean with that? Can you give an code example in an other RDBMS (like oracle)? Perhaps nothing came up because there are more people not understanding what you want to accomplish? regards, Willem > Subject: [HACKERS] Ar

Re: [HACKERS] Deparsing DDL command strings

2012-11-04 Thread Dimitri Fontaine
Dimitri Fontaine writes: > The current design for event triggers is to spit out several things: > > - command tag is already commited > - object id, can be null > - schema name, can be null > - object name > - operationeither ALTER, CREATE or DROP,

Re: [HACKERS] Arguments to foreign tables?

2012-11-04 Thread Tom Lane
Jeff Davis writes: > Is there any fundamental or philosophical reason why a foreign table > can't accept arguments? That isn't a table; it's some sort of function. Now that we have LATERAL, there is no good reason to contort SQL's syntax and semantics in the direction you suggest.

[HACKERS] Arguments to foreign tables?

2012-11-04 Thread Jeff Davis
Is there any fundamental or philosophical reason why a foreign table can't accept arguments? Should that be a TODO? Right now, to accept arguments to a from-clause item, you have to use an SRF, which is much more limited than a foreign table. If foreign tables could accept arguments, then SRFs cou

Re: [HACKERS] SP-GiST for ranges based on 2d-mapping and quad-tree

2012-11-04 Thread Jeff Davis
On Fri, 2012-11-02 at 12:47 +0400, Alexander Korotkov wrote: > Right version of patch is attached. > * In bounds_adjacent, there's no reason to flip the labels back. * Comment should indicate more explicitly that bounds_adjacent is sensitive to the argument order. * In bounds_adjacent, it appears

Re: [HACKERS] Unresolved error 0xC0000409 on Windows Server

2012-11-04 Thread Tom Lane
Matthew Gerber writes: >> Here is the command that was executing when the 0xC409 exception was >> raised: >> INSERT INTO places (bounding_box,country,full_name,id,name,type,url) >> VALUES >> (st_transform_null(ST_GeometryFromText('POLYGON((-97.034085 >> 32.771786,-97.034085 32.953966,-96.88878

Re: [HACKERS] Unresolved error 0xC0000409 on Windows Server

2012-11-04 Thread Matthew Gerber
On Sun, Nov 4, 2012 at 3:39 AM, Craig Ringer wrote: > On 11/04/2012 08:47 AM, Matthew Gerber wrote: > > > Here is the command that was executing when the 0xC409 exception was > raised: > > INSERT INTO places (bounding_box,country,full_name,id,name,type,url) > > VALUES > > (st_transform_null

[HACKERS] proposal: fix corner use case of variadic fuctions usage

2012-11-04 Thread Pavel Stehule
Hello here is patch, that enables using a variadic parameter modifier for variadic "any" function. Motivation for this patch is consistent behave of "format" function, but it fixes behave of all this class variadic functions. postgres=> -- check pass variadic argument postgres=> select format('%

Re: [HACKERS] Unresolved error 0xC0000409 on Windows Server

2012-11-04 Thread Craig Ringer
On 11/04/2012 08:47 AM, Matthew Gerber wrote: > > Here is the command that was executing when the 0xC409 exception > was raised: > > INSERT INTO places (bounding_box,country,full_name,id,name,type,url) > > VALUES > > (st_transform_null(ST_GeometryFromText('POLYGON((-97.034085 > 32.771786,-97.03

Re: [HACKERS] RFC: Timing Events

2012-11-04 Thread Pavel Stehule
Hello 2012/11/4 Satoshi Nagayasu : > (2012/11/03 10:44), Josh Berkus wrote: >> >> >>> I don't see all that going into core without a much bigger push than I >>> think people will buy. What people really want for all these is a >>> proper trending system, and that means graphs and dashboards and >

Re: [HACKERS] RFC: Timing Events

2012-11-04 Thread Satoshi Nagayasu
(2012/11/03 10:44), Josh Berkus wrote: I don't see all that going into core without a much bigger push than I think people will buy. What people really want for all these is a proper trending system, and that means graphs and dashboards and bling--not a history table. Well, I'm particularly

Re: [HACKERS] [v9.3] writable foreign tables

2012-11-04 Thread Kohei KaiGai
2012/11/2 Alexander Korotkov : > On Mon, Sep 24, 2012 at 12:49 PM, Kohei KaiGai wrote: >> >> 2012/9/23 Kohei KaiGai : >> > 2012/8/29 Kohei KaiGai : >> >> 2012/8/28 Kohei KaiGai : >> >>> 2012/8/28 Tom Lane : >> Kohei KaiGai writes: >> >> Would it be too invasive to introduce a new pointer