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

2012-11-04 Thread Kohei KaiGai
2012/11/2 Alexander Korotkov aekorot...@gmail.com: On Mon, Sep 24, 2012 at 12:49 PM, Kohei KaiGai kai...@kaigai.gr.jp wrote: 2012/9/23 Kohei KaiGai kai...@kaigai.gr.jp: 2012/8/29 Kohei KaiGai kai...@kaigai.gr.jp: 2012/8/28 Kohei KaiGai kai...@kaigai.gr.jp: 2012/8/28 Tom Lane

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.034085

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] RFC: Timing Events

2012-11-04 Thread Pavel Stehule
Hello 2012/11/4 Satoshi Nagayasu sn...@uptime.jp: (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

[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('%s,

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 ring...@ringerc.id.au 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

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

2012-11-04 Thread Tom Lane
Matthew Gerber gerber.matt...@gmail.com 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

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

[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

Re: [HACKERS] Arguments to foreign tables?

2012-11-04 Thread Tom Lane
Jeff Davis pg...@j-davis.com 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

Re: [HACKERS] Deparsing DDL command strings

2012-11-04 Thread Dimitri Fontaine
Dimitri Fontaine dimi...@2ndquadrant.fr 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,

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]

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
what does that even mean?how would 'data' accept 'arguments' ??! That's Sherlock Holmes! Don't argue with your data

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

2012-11-04 Thread Tom Lane
Pavan Deolasee pavan.deola...@gmail.com writes: On Sat, Nov 3, 2012 at 10:21 AM, Nikhil Sontakke nikkh...@gmail.com 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

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

2012-11-04 Thread Robert Haas
On Sat, Nov 3, 2012 at 5:44 PM, Florian Weimer f...@deneb.enyo.de 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

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

2012-11-04 Thread Peter van Hardenberg
On Fri, Nov 2, 2012 at 11:16 AM, Peter Eisentraut pe...@eisentraut.orgwrote: 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] [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

[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