Re: [GENERAL] Code of Conduct: Is it time?

2016-01-11 Thread Joshua D. Drake
Steve, Please see the new thread WIP: CoC V2 -- Command Prompt, Inc. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack support, consulting and development. Announcing "I'm offended" is basically telling the world you can't control your own emotions, so everyone else sh

Re: [GENERAL] Offline Tablespaces and Partial Restore

2016-01-11 Thread David Steele
On 1/11/16 8:41 AM, Pedro França wrote: I've tried to put the data on another database but it didn't help as tablespaces are required cluster-wide on startup. If putting the data in a separate database works for you then it wouldn't be a big leap to put it in a separate cluster. Functionality

Re: [GENERAL] WIP: CoC V2

2016-01-11 Thread Stephen Cook
On 1/11/2016 6:41 PM, Alban Hertroys wrote: > >> On 12 Jan 2016, at 0:16, Joshua D. Drake wrote: >> >> 3. A safe, respectful, productive and collaborative environment is free of >> non-technical or personal comments, for example ones related to gender, >> sexual orientation, disability, physica

Re: [GENERAL] WIP: CoC

2016-01-11 Thread James Keener
>> We value the opinions of members who have contributed most more than > we value the opinions of others. > >> A CoC is not the place to say some animals are more equal than others. A > core commiter calling someone the n- or b- words is just as bad as me, a > non commiter (if not worse!) > > Ye

Re: [GENERAL] WIP: CoC

2016-01-11 Thread John R Pierce
On 1/11/2016 4:35 PM, James Keener wrote: To me that's psychological trauma. It's the same psychological trauma I >had to face being born a left-handed and being forced to write with my >right-hand. But it's still not trauma, where is the trauma? Something like Master/Slave to Primary/Replica (

[GENERAL] Building PostgreSQL in Eclipse on Windows

2016-01-11 Thread Igal @ Lucee.org
Can anyone help me figure out how to run/debug PostgreSQL in Eclipse on Windows? This is a cross post with http://stackoverflow.com/questions/34733991/building-postgresql-in-eclipse-on-windows : I'm trying to build|PosgreSQL|in Eclipse CDT Mars on Windows using the MinGW-64 gcc 5.3.0 I ins

[GENERAL] plv8 binaries for PostgreSQL 9.5 on Windows

2016-01-11 Thread Igal @ Lucee.org
Where can I find binaries for plv8 for PostgreSQL 9.5 for Windows? Thanks, -- Igal Sapir Lucee Core Developer Lucee.org

Re: [GENERAL] WIP: CoC

2016-01-11 Thread Regina Obe
> That has nothing to do with the Code of Conduct, though. The community > accepting Tom saying "no" to Feature X is vastly different than the community > not calling Tom out for being mean. > The CoC is about the later situation and not the prior; and the community > should call Tom out. (

Re: [GENERAL] Building PostgreSQL in Eclipse on Windows

2016-01-11 Thread Michael Paquier
On Tue, Jan 12, 2016 at 10:32 AM, Igal @ Lucee.org wrote: > I downloaded the PostgreSQL source code and tried to follow the docs but > can't figure out where to download the dependencies? 1. libreadline5-dev, 2. > zlib1g-dev, 3. bison (YACC), 4. flex and where to save them to on disk? Regarding

Re: [GENERAL] JSONB performance enhancement for 9.6

2016-01-11 Thread Tom Smith
Hi, Congrats on the official release of 9.5 And I'd like bring up the issue again about if 9.6 would address the jsonb performance issue with large number of top level keys. It is true that it does not have to use JSON format. it is about serialization and fast retrieval of dynamic tree structure

Re: [GENERAL] WIP: CoC

2016-01-11 Thread James Keener
>> That has nothing to do with the Code of Conduct, though. The >> community accepting Tom saying "no" to Feature X is vastly >> different than the community not calling Tom out for being mean. > >> The CoC is about the later situation and not the prior; and the >> community should call Tom out.

Re: [GENERAL] WIP: CoC

2016-01-11 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 (Wow. I cannot recall a time I've seen so many posts that just make me shake my head in sadness. It's painfully obvious that a code of conduct is way outside the wheelhouse of many of the participants in this thread.) > Below please find a W

Re: [GENERAL] Building PostgreSQL in Eclipse on Windows

2016-01-11 Thread John R Pierce
On 1/11/2016 5:32 PM, Igal @ Lucee.org wrote: Can anyone help me figure out how to run/debug PostgreSQL in Eclipse on Windows? This is a cross post with http://stackoverflow.com/questions/34733991/building-postgresql-in-eclipse-on-windows : I'm trying to build|PosgreSQL|in Eclipse CDT

[GENERAL] row-level security, views and materialized views?

2016-01-11 Thread Karl Czajkowski
Hi, has there been any discussion as to supporting row-level security policies on materialized views? I didn't have much luck searching on this topic. I see that PostgreSQL 9.5 refuses to create a policy on a materialized view, consistent with the documentation focusing only on tables. First off,

Re: [GENERAL] Building PostgreSQL in Eclipse on Windows

2016-01-11 Thread Igal @ Lucee.org
On 1/11/2016 6:21 PM, John R Pierce wrote: wait, are you trying to USE postgres on Eclipse on Windows, or BUILD it ?I would use the enterprisedb build of postgres-for-windows, and then you just need to install the appropriate postgresql jdbc jar file into Eclipse to be able to use it from y

Re: [GENERAL] WIP: CoC V3

2016-01-11 Thread Joshua D. Drake
tl;dr; * Removed #6 (Social Justice) PostgreSQL Global Development Group (PGDG) Code of Conduct (CoC): 1. The CoC is to provide community guidelines for creating and enforcing a safe, respectful, productive, and collaborative place for any person who is willing to contribute in a safe, respec

Re: [GENERAL] WIP: CoC V3

2016-01-11 Thread Andy Chambers
Any reason not to just adopt the contributor covenant? http://contributor-covenant.org/ tl;dr; * Removed #6 (Social Justice) PostgreSQL Global Development Group (PGDG) Code of Conduct (CoC): 1. The CoC is to provide community guidelines for creating and enforcing a safe, respectful, productive,

Re: [GENERAL] Request - repeat value of \pset title during \watch interations

2016-01-11 Thread Michael Paquier
On Tue, Jan 12, 2016 at 1:15 AM, David G. Johnston wrote: > On Mon, Jan 11, 2016 at 9:03 AM, Tom Lane wrote: >> >> "David G. Johnston" writes: >> > On Mon, Jan 11, 2016 at 8:14 AM, Tom Lane wrote: >> >> Perhaps we should replace the "Watch every Ns" text by the user-given >> >> title if a title

Re: [GENERAL] WIP: CoC

2016-01-11 Thread Tom Lane
[ just a few comments on specific points ] "Greg Sabino Mullane" writes: >> 2. The CoC is not about being offended. The act of being offended is >> purely a recipient response and usually the offended individual is more >> interested in being a victim than moving forward. > Too defensive; not

[GENERAL] Giving error for function

2016-01-11 Thread Sachin Srivastava
Hi, I am getting the below error while I am running the below function "add_po_doc_hist", for "c_company" cursor, please suggest what is wrong with code. ERROR: relation "c_company" does not exist CONTEXT: compilation of PL/pgSQL function "add_po_doc_hist" near line 11 ** Error

Re: [GENERAL] WIP: CoC

2016-01-11 Thread Regina Obe
Jim, > That has nothing to do with the Code of Conduct, though. The community > accepting Tom saying "no" to Feature X is vastly different than the community > not calling Tom out for being mean. > The CoC is about the later situation and not the prior; and the community > should call Tom out

Re: [GENERAL] Code of Conduct: Is it time?

2016-01-11 Thread Albe Laurenz
Tom Lane wrote: > In my admittedly-limited experience with dealing with such problems, > it's a lot easier to achieve positive results if you can discuss > issues in private, before people's positions harden. > > In short, I wouldn't characterize that complainant as "a troll" for > the substance o

<    1   2