Re: [HACKERS] pg_background (and more parallelism infrastructure patches)

2014-09-20 Thread Amit Kapila
On Fri, Sep 12, 2014 at 12:07 AM, Robert Haas robertmh...@gmail.com wrote: On Thu, Sep 11, 2014 at 7:34 AM, Amit Kapila amit.kapil...@gmail.com wrote: Don't we need some way to prohibit changing GUC by launching process, once it has shared the existing GUC? Nope. I mean, eventually, for

Re: [HACKERS] RLS Design

2014-09-20 Thread Craig Ringer
On 09/20/2014 12:38 AM, Stephen Frost wrote: I would not (nor do I feel that I did..) have committed it over a specific request to not do so from another committer. I had been hoping that there would be another review coming from somewhere, but there is always a trade-off between waiting

[HACKERS] WITH CHECK OPTION bug [was RLS Design]

2014-09-20 Thread Dean Rasheed
On 20 September 2014 06:13, Andrew Gierth and...@tao11.riddles.org.uk wrote: Adam == Brightwell, Adam adam.brightw...@crunchydatasolutions.com writes: Adam At any rate, this appears to be a previously existing issue Adam with WITH CHECK OPTION. Thoughts? It's definitely an existing

Re: [HACKERS] pg_receivexlog and replication slots

2014-09-20 Thread Amit Kapila
On Wed, Sep 10, 2014 at 10:09 AM, Michael Paquier michael.paqu...@gmail.com wrote: New patches taking into account all those comments are attached. I have looked into refactoring related patch and would like to share my observations with you: 1. + * Run IDENTIFY_SYSTEM through a given

Re: [HACKERS] WITH CHECK OPTION bug [was RLS Design]

2014-09-20 Thread Michael Paquier
On Sat, Sep 20, 2014 at 7:03 AM, Dean Rasheed dean.a.rash...@gmail.com wrote: Fortunately it looks pretty trivial though. The patch attached fixes the above test cases. Obviously this needs to be fixed in 9.4 and HEAD. Wouldn't it be better if bundled with some regression tests? -- Michael

Re: [HACKERS] gist vacuum seaq access

2014-09-20 Thread Костя Кузнецов
Heikki.I have idea. when i begining vacuum i must create structure like hash table. And the first action i fill this hash table.in code this look like:for( blkno = ..; all pages; blkno++) {  if(! gistPageIsLeaf(blkno)) { for( all tuples in blkno ) { hash[ blkno that is referenced by

[HACKERS] Should we excise the remnants of borland cc support?

2014-09-20 Thread Andres Freund
Hi, At the moment there's some rememnants of support for borland CC. I don't believe it's likely that any of it still works. I can't remember ever seing a buildfarm animal running it either - not surprising it's ~15 years since the last release. Since there's both msvc and mingw support for

[HACKERS] Help to startup

2014-09-20 Thread Tapan Halani
Hello everyone..i am new to PostgreSQL project. I had prior experience with sql+ , with oracle 11g database server. Kindly help me grasp more about the project. Thank you, Tapan Halani

Re: [HACKERS] A mechanism securing web applications in DBMS

2014-09-20 Thread Zhaomo Yang
Stephen, Yes- but that's pretty trivially done, given that you've stipulated that a single connection DB connection must be used from authentication until de-authentication. All that is needed is an additional column in the auth table which is populated with a pseudo-random value which is

Re: [HACKERS] Help to startup

2014-09-20 Thread Andrew Dunstan
On 09/16/2014 01:51 PM, Tapan Halani wrote: Hello everyone..i am new to PostgreSQL project. I had prior experience with sql+ , with oracle 11g database server. Kindly help me grasp more about the project. The first thing you need to do is learn to ask your question in the right forum.

Re: [HACKERS] Should we excise the remnants of borland cc support?

2014-09-20 Thread Andrew Dunstan
On 09/20/2014 09:24 AM, Andres Freund wrote: Hi, At the moment there's some rememnants of support for borland CC. I don't believe it's likely that any of it still works. I can't remember ever seing a buildfarm animal running it either - not surprising it's ~15 years since the last release.

Re: [HACKERS] pg_receivexlog and replication slots

2014-09-20 Thread Michael Paquier
On Sat, Sep 20, 2014 at 7:09 AM, Amit Kapila amit.kapil...@gmail.com wrote: I have looked into refactoring related patch and would like to share my observations with you: Thanks! Useful input is always welcome. 1. + * Run IDENTIFY_SYSTEM through a given connection and give back to caller

Re: [HACKERS] Should we excise the remnants of borland cc support?

2014-09-20 Thread Andres Freund
On September 20, 2014 4:03:43 PM CEST, Andrew Dunstan and...@dunslane.net wrote: On 09/20/2014 09:24 AM, Andres Freund wrote: Hi, At the moment there's some rememnants of support for borland CC. I don't believe it's likely that any of it still works. I can't remember ever seing a buildfarm

Re: [HACKERS] RLS Design

2014-09-20 Thread Josh Berkus
On 09/20/2014 12:23 AM, Craig Ringer wrote: On 09/20/2014 12:38 AM, Stephen Frost wrote: I would not (nor do I feel that I did..) have committed it over a specific request to not do so from another committer. I had been hoping that there would be another review coming from somewhere, but

Re: [HACKERS] Hide 'Execution time' in EXPLAIN (COSTS OFF)

2014-09-20 Thread Christoph Berg
Re: Andres Freund 2014-06-04 20140604194544.gb...@awork2.anarazel.de I'm unconvinced that this'd add much to our regression testing capability, though. The standard thing is to do an EXPLAIN to check the plan shape and then run the query to see if it gets the right answer. Checking row

[HACKERS] conditional query in where has name collision. bug?

2014-09-20 Thread bill wilson
This a toy example from a 'upsert' script that appends new data: select a from (select 1 as a) as t1 where not exists (select true from (select 2 as a) t2 where a=a) ; a ─── (0 rows) select a from (select 1 as a) as t1 where not exists (select true from (select 2 as a) t2 where t1.a=t2.a) ;

Re: [HACKERS] conditional query in where has name collision. bug?

2014-09-20 Thread Andrew Gierth
bill == bill wilson bill.wilson.h...@gmail.com writes: bill This a toy example from a 'upsert' script that appends new data: bill select a from (select 1 as a) as t1 where not exists (select bill true from (select 2 as a) t2 where a=a) ; bill a bill ─── bill (0 rows) bill Please tell me

Re: [HACKERS] Minor improvement in lock.sgml

2014-09-20 Thread Alvaro Herrera
Robert Haas wrote: On Tue, Sep 16, 2014 at 7:20 AM, Etsuro Fujita fujita.ets...@lab.ntt.co.jp wrote: Here is a patch to a bit improve the reference page for the LOCK command. I think it'd be better for the isolation level to be in capitals and wrapped in the literal tags. It's done