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

Hi All, I just saw this thread. I tend to agree with the general idea of having a code of conduct. If you are on a long distance journey then it will help to have road signs every now and then. Following your nose won't hurt but doesn't necessarily help either! LOL More seriously, on the

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

2016-01-06 9:20 GMT+01:00 David Rowley : > On 6 January 2016 at 20:36, Pavel Stehule wrote: > >> Almost all developers write code for job not for hobby. >> > > As much as I'm trying not to get involved in this thread mainly due to my > lack

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

On Wed, Jan 06, 2016 at 11:22:17AM -, FarjadFarid(ChkNet) wrote: > I am not in favour of massive price structures but that > there should be $100-$200 costs for smallest version. Times > several million products. This may allow postgresql to reduce > its prices on its the top of the range

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

> I agree with Jim, something is wrong, I see our developers community isn't > growing and getting older. > There is no formal problem to start contribute, but steep learning curve and > lack of mentoring practice scare people. The "Debian Med" Debian Blend has quite successfully used a

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

Hi Everyone , My only aim is further progress of postgresql. Emails are not the best medium for consulting about complex issues. One last point I would like to make is this. As per Sun Microsystem’s case charging zero dollars (for Java and mysql) means there is zero income. I

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

Hi Karsten, > You may be mistaking the community version for any of the commercially supported offerings ? It is possible. Please fill in the figures. What I am suggesting is that even for community version there should be a charge. But as I mentioned it is not just prices. May be I wasn't

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

Hi Karsten, > You may be mistaking the community version for any of the commercially supported offerings ? It is possible. Please fill in the figures. What I am suggesting is that even for community version there should be a charge. But as I mentioned it is not just prices. May be I wasn't

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

What are you talking about? What business structure? Commercial offerings can and will continue to exist in terms of custom features or consulting. Firstly, it ceases to be a community version when there is a charge. Secondly, it would damage our community by shrinking the size to effectively

[GENERAL] Charging for PostgreSQL

As Melvin mentioned, this belongs in a new thread. > Just one last example. Consider the music industry. For years Apple amongst > others promoted low cost per unit downloads and then streaming. We all know > the history. > > Once a thriving industry music industry has been decimated. Neither

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

All, The subject of the discussion/track is to whether or not there should be a code of condect (Coc). Whether or not there should be a charge for PostgreSQL does not belong in this track, and is, in fact, a moot point as PostgreSQL IS a _free_ database, as is this community board. If you feel

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

On 1/6/16 2:17 AM, Victor Yegorov wrote: Another very wanted change in the community is mentorship. Personally, I don't feel confident to ask endless questions I have when looking into the code, as I understand, that this might be a very basic (for PostgreSQL hackers) stuff. For me it'd be a

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

While at first glance, it would seem a code of conduct is a good idea, having once would be pointless if there is no way to enforce it. As others have already shown by totally ignoring the subject of this track and hijacking it into a discussion of fees (which, IMHO, is totally ridiculous), there

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

Hi James, I value your passion and commitment to postgresql. I am equally passionate about postgresql and am just like you another user but not pointing these on simple commercial practical bases. These are simple feedbacks. Just one last example. Consider the music industry. For years

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

On 1/6/16 9:48 AM, Melvin Davidson wrote: there is no way it can be enforced. So while I applaud Joshua Drake for his good intent, I there must therefore take the position of saying no to a CoC A good CoC is not just a code, it is also a means of enforcement. To wit, from the CouchDB CoC[1]:

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

> My only aim is further progress of postgresql. Charging for it would do exactly that. Most people would simply switch to MySQL (or Maria) or stop upgrading/upgrade to a fork. > As per Sun Microsystem’s case charging zero dollars (for Java and mysql) > means there is zero income. Why do you

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

Hi James, I value your passion and commitment to postgresql. I am equally passionate about postgresql and am just like you another user but pointing these on simple commercial practical bases. These are simple feedbacks. Just one last example. Consider the music industry. For years Apple

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

On 1/6/16 1:36 AM, Pavel Stehule wrote: The CoC doesn't solve it. We do on mature, stable, pretty complex code - use C (not JavaScript or Java). This isn't hobby project or student project. No, CoC by itself doesn't grow the community. That doesn't mean we shouldn't have one. Another

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

> The coc sounds like a Washington politics play, but as long as the best > still engage > in this forum, I could care less. The list serves its purpose without > overhead...a rare > resource in today's flood of incoherent technical chatter. Beyond "Hey! Look at us! We're telling people to play

Re: [GENERAL] Charging for PostgreSQL

How does one "start a new thread"? I wasn't aware that changing the subject wouldn't be enough. I tried :/ Jim On January 6, 2016 12:17:54 PM EST, "Stéphane Schildknecht" wrote: >On 06/01/2016 16:54, James Keener wrote: >> As Melvin mentioned, this belongs

[GENERAL] Postgresql 9.3 not coming up after restart in centos

Hi I have installed postgresql-9.3 in my centos application. When the application starts for first-time Postgres starts without any issue most of the time. But when I reboot the centOs, Postgres is not getting started on subsequent boot and I am getting the error, LOG: invalid magic number

[GENERAL] Off topic - How to start a new thread

On Wed, 06 Jan 2016 12:46:08 -0500 James Keener wrote: > How does one "start a new thread"? I wasn't aware that changing the > subject wouldn't be enough. I tried :/ If you want to start a new thread don't reply to an existing one. Even if you change the subject it is still

Re: [GENERAL] Charging for PostgreSQL

[offtopic alert] On 2016-01-06 12:46 PM, James Keener wrote: How does one "start a new thread"? 'New Message' in your favourite email client. 'pgsql-general@postgresql.org' in the 'To' box. I wasn't aware that changing the subject wouldn't be enough. I tried :/ Check the raw source of the

What another group does (was Re: [GENERAL] Code of Conduct: Is it time?)

Hi, I'm not much of a contributor to the project any more, but I thought perhaps some information about what some other communities do might be helpful. (For those of you who don't know me, I used to be somewhat active in this community until I got heavily involved in the Intenet Engineering

[GENERAL] Conflict detection in ON CONFLICT

Hello, Is there any way for a client to know if a conflict happened in an ON CONFLICT DO UPDATE query ? Thanks ! -- Nicolas "Pause" ALBEZA

Re: [GENERAL] Submitting to this list

Responded to the separately cross-posted version on -www...in short this is not a big reporting list and doesn't need the same rules or expectations. Assume agnostic o/s and current release then deal with variations as they are needed. David J. On Wednesday, January 6, 2016, Melvin Davidson

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

By application I mean centOS. We are starting and stopping Postgres using systemd service. We have a service file called postgresql9.3.service which is used to start or stop Postgres. Excerpts of postgresql9.3.service ExecStartPre=/usr/pgsql-9.3/bin/postgresql93-check-db-dir ${PGDATA}

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

Hi Joshua, Thanks for the posting. That was a good list of areas to cover. Specially about speakers/events/third party plugins etc. How would you sum it up? Would it be right to summed up as anything that could affect the Postgresql as a brand should be protected? This is of course also

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

Victor Yegorov wrote: > Perhaps, this is a good project for a newby to do. Perhaps, it is > worthwhile to create Developer's documentation, either as a section in > the official docs or as a separate resource with structure and design > similar to the official docs? Here's an idea. We have a

Re: [GENERAL] Getting the function definition from oid in before firing the function

Hi, Thanks for your answer! I know that this is not the only language for triggers, but the algorithm I have to implement only supports these triggers. I have looked at the audit trigger, but that is not quite what I am trying to achieve. I have implemented the stack push and pop for the initial

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

On 01/05/2016 11:18 AM, balajishanmu...@live.in wrote: Hi I have installed postgresql-9.3 in my centos application. When the application starts for first-time Postgres starts without any issue most of Not sure what you are talking about when you say CentOS application. Are you saying when

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

2016-01-06 17:46 GMT+01:00 Jeff Anton : > On 01/06/16 08:04, Jim Nasby wrote: > ... > >> increase the number of active developers. My very talented colleague >>> doesn't write to Postgres due C language. He like to write planner in >>> lisp or erlang. Or like to play in

Re: [GENERAL] Submitting to this list

On Wed, Jan 6, 2016 at 9:15 AM, Melvin Davidson wrote: > > I would like to see the following added to the introduction to this list. > > "When submitting to this list, please include the full version of > PostgreSQL and the O/S you are using. > Also, if you are reportaing a

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

On 01/06/2016 08:50 AM, Joshua D. Drake wrote: On 01/06/2016 08:11 AM, James Keener wrote: The coc sounds like a Washington politics play, but as long as the best still engage in this forum, I could care less. The list serves its purpose without overhead...a rare resource in today's flood of

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

2016-01-06 17:04 GMT+01:00 Jim Nasby : > On 1/6/16 1:36 AM, Pavel Stehule wrote: > >> The CoC doesn't solve it. We do on mature, stable, pretty complex >> code - use C (not JavaScript or Java). This isn't hobby project or >> student project. >> > > No, CoC by itself

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

On 01/06/16 08:04, Jim Nasby wrote: ... increase the number of active developers. My very talented colleague doesn't write to Postgres due C language. He like to write planner in lisp or erlang. Or like to play in these languages. C is barrier for younger people. ... better job of "eating

[GENERAL] Submitting to this list

I would like to see the following added to the introduction to this list. "When submitting to this list, please include the full version of PostgreSQL and the O/S you are using. Also, if you are reportaing a problem, it is essential that a minimal amount of schema & data be provided in order to

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

On 01/06/2016 09:20 AM, Adrian Klaver wrote: We just have to figure out if it will. (As a cis-hetero white middle class male) I'm not a "targeted" group and as such my views may not be of the most use here. Which is another very good point. Except it is not true. Re: my previous post about

Re: [GENERAL] Charging for PostgreSQL

Hi Jim/Melvin and all, Music industry is a good example where too low charges has damaged it. People in the industry will tell you that not enough young talent are coming through the system. I do agree that there is some corruption but there is no escaping the fact that the industry's turn

Re: [GENERAL] Charging for PostgreSQL

On 06/01/2016 16:54, James Keener wrote: > As Melvin mentioned, this belongs in a new thread. And as such, it would have been really kind to actually start a new one. (...) -- Stéphane Schildknecht Contact régional PostgreSQL pour l'Europe francophone Loxodata - Conseil, expertise et formations

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

> No, CoC by itself doesn't grow the community. That doesn't mean we > shouldn't have one. I'd agree with that. Thinking back over my previous points, it does make sense to have one, if only to deal with people who represent the community in some way, i.e. have some kind of commit or marketing

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

On 01/06/2016 08:11 AM, James Keener wrote: The coc sounds like a Washington politics play, but as long as the best still engage in this forum, I could care less. The list serves its purpose without overhead...a rare resource in today's flood of incoherent technical chatter. Beyond "Hey! Look

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

On 01/06/2016 08:13 AM, Jim Nasby wrote: (BTW, if your concern on enforcement is about control, not only can people be removed from mailing lists and the like, but there actually is a Postgres legal entity that could start legal proceedings if it ever came to it.) As a Director for 2 of the

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

2016-01-06 9:08 GMT+02:00 Oleg Bartunov : > I agree with Jim, something is wrong, I see our developers community isn't > growing and getting older. There is no formal problem to start contribute, > but steep learning curve and lack of mentoring practice scare people. I

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

On 6 January 2016 at 20:36, Pavel Stehule wrote: > Almost all developers write code for job not for hobby. > As much as I'm trying not to get involved in this thread mainly due to my lack of ability to foresee that a block of text will solve a bunch of problems, I do

Re: [GENERAL] Submitting to this list

On 1/6/2016 9:15 AM, Melvin Davidson wrote: I would like to see the following added to the introduction to this list. "When submitting to this list, please include the full version of PostgreSQL and the O/S you are using. Also, if you are reportaing a problem, it is essential that a minimal

Re: [GENERAL] Definitive answer: can functions use indexes?

On Wed, Jan 6, 2016, at 08:41 PM, Tom Lane wrote: > Seamus Abshere writes: > > -> Can a function like `LEFT()` use an index? > Since the question makes little sense as stated, I'm going to assume > you mean "can a query like SELECT ... WHERE left(foo, 3) = 'bar' > use an index

[GENERAL] Re: [BUGS] BUG #13847: WARNING: skipping "pg_toast_" --- cannot vacuum indexes, views, or special system tables VACUUM

Hi Kevin, Thanks a lot for getting back on this. 1) Customer is facing issue in our application running 8.2 version PG linux# su postgres -s /bin/sh -c "postgres --version" postgres (PostgreSQL) 8.2.3 unicorn=# select version();     version

Re: [GENERAL] Conflict detection in ON CONFLICT

On Wed, Jan 6, 2016 at 10:48 AM, Nicolas ALBEZA wrote: > Hello, > > Is there any way for a client to know if a conflict happened in an ON > CONFLICT DO UPDATE query ? Here is one way: create table foo (x int primary key, y text); insert into foo values (3,'insert') on

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

On 01/06/2016 01:08 PM, balajishanmu...@live.in wrote: Most of the time I will be restarting centOS by issuing reboot command. Which will do the orderly shutdown of all the service and sometimes just pull the plug. But the issue appears to be random. Is there a way that before Postgres starts

Re: [GENERAL] Charging for PostgreSQL

On 1/6/2016 8:25 AM, FarjadFarid(ChkNet) wrote: Music industry is a good example where too low charges has damaged it. People in the industry will tell you that not enough young talent are coming through the system. I do agree that there is some corruption but there is no escaping the fact

Re: [GENERAL] Definitive answer: can functions use indexes?

Seamus Abshere writes: > I've been using Postgres for years ( :heart: ) and I'm still in doubt > about this. Would somebody provide an authoritative, definitive, > narrative answer? > -> Can a function like `LEFT()` use an index? To do what? Since the question makes little

Re: [GENERAL] Definitive answer: can functions use indexes?

On 1/6/16 5:15 PM, Seamus Abshere wrote: I've been using Postgres for years ( :heart: ) and I'm still in doubt about this. Would somebody provide an authoritative, definitive, narrative answer? -> Can a function like `LEFT()` use an index? (Or do I have to find an "equivalent" operator in

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

On 01/06/2016 02:50 PM, David Gibbons wrote: On 1/6/2016 8:50 AM, Joshua D. Drake wrote: It provides a sense of confidence to those who are not confident that they can come play in our playground and not be bullied. That is what every single code of conduct is

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

Uhm, you mean this one? https://git.kernel.org/cgit/linux/kernel/git/torvalds/linux.git/commit/?id=b0bc65729070b9cbdbb53ff042984a3c545a0e34 +If however, anyone feels personally abused, threatened, or otherwise +uncomfortable due to this process, that is not acceptable. If so, +please contact the

Re: [GENERAL] Definitive answer: can functions use indexes?

Seamus Abshere writes: > I should have been more general. In layman's/narrative terms, what's the > deal with functions vs. operators for postgres indexes? > For example, `exist(hstore,text)` vs. `hstore ? text` ? Yeah. exist(hstore,text) and hstore?text may yield the same

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

On 1/6/2016 8:50 AM, Joshua D. Drake wrote: It provides a sense of confidence to those who are not confident that they can come play in our playground and not be bullied. That is what every single code of conduct is about. There are a lot of very talented people in the FLOSS community that

[GENERAL] Definitive answer: can functions use indexes?

hi, I've been using Postgres for years ( :heart: ) and I'm still in doubt about this. Would somebody provide an authoritative, definitive, narrative answer? -> Can a function like `LEFT()` use an index? (Or do I have to find an "equivalent" operator in order to leverage indexes?) Thanks!

[GENERAL] Trigger function interface

Is it possible to get the parse tree in a C trigger function which is invoked when DML (INSERT/UPDATE/DELETE against a view) is executed? Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp -- Sent via pgsql-general

Re: [GENERAL] Definitive answer: can functions use indexes?

On 1/6/16 5:41 PM, Tom Lane wrote: Since the question makes little sense as stated, I'm going to assume you mean "can a query like SELECT ... WHERE left(foo, 3) = 'bar' use an index on column foo?" The answer to that is no, there is no such optimization built into Postgres. (In principle there

Re: [GENERAL] RAM of Postgres Server

On Wed, Jan 6, 2016 at 10:39 PM, Sachin Srivastava wrote: > Dear Team, > > Please suggest, how much RAM and core should be define for New Postgres > database server, if we will use Postgres 9.3 and above. > > If suppose my postgres database size will be near about 300 to

Re: [GENERAL] 9.5rc1 RLS select policy on insert?

* Ted Toth (txt...@gmail.com) wrote: > I see the insert policy check running but also the select policy using > on insert. I don't understand why the select policy is being run. > Could it possibly be related to using a sequence on the table? It's used when SELECT rights are required on the

Re: [GENERAL] COPY FROM STDIN

On 1/6/16 9:45 PM, Luke Coldiron wrote: In the example above I'm not sure if I can use some sub struct of the SPIPlanPtr and hand it off to the DoCopy function as the CopyStmt or if I need to go about this entirely different. Any advice on the matter would be much appreciated. I don't know

Re: [GENERAL] Getting the function definition from oid in before firing the function

On Wed, Jan 6, 2016 at 4:29 PM, Mohammed Ajil wrote: > What is an executor hook? Here you go, with a particular focus on the ones names Executor*_hook: https://wiki.postgresql.org/images/e/e3/Hooks_in_postgresql.pdf -- Michael -- Sent via pgsql-general mailing list

[GENERAL] RAM of Postgres Server

Dear Team, Please suggest, how much RAM and core should be define for New Postgres database server, if we will use Postgres 9.3 and above. If suppose my postgres database size will be near about 300 to 500 GB for future. There is any document regarding this server configuration, suggest ?

Re: [GENERAL] COPY FROM STDIN

> On 1/4/16 12:18 PM, Luke Coldiron wrote: > > Is there a way to achieve the performance of the COPY FROM STDIN command > > within a C extension function connected to the db connection that called > > the C function? I have text that I would like to receive as input to a C > > function that

Re: [GENERAL] RAM of Postgres Server

On 07/01/16 18:39, Sachin Srivastava wrote: Dear Team, Please suggest, how much RAM and core should be define for New Postgres database server, if we will use Postgres 9.3 and above. If suppose my postgres database size will be near about 300 to 500 GB for future. There is any document

Re: [GENERAL] Trigger function interface

On 1/6/16 7:03 PM, Tatsuo Ishii wrote: Is it possible to get the parse tree in a C trigger function which is invoked when DML (INSERT/UPDATE/DELETE against a view) is executed? Yes, it's in fcinfo->flinfo->fn_expr. -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in

Re: [GENERAL] RAM of Postgres Server

Dear David, Q: RAM holds data that is recently accessed - how much of that will you have? Ans: Kindly confirm, as per your question “RAM holds data that is recently accessed” : How we figured out that how much data we will have. Is it depends of Total WAL files (total "checkpoint_segment"

[GENERAL] 9.5rc1 RLS select policy on insert?

I see the insert policy check running but also the select policy using on insert. I don't understand why the select policy is being run. Could it possibly be related to using a sequence on the table? Ted -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

On Wed, Jan 6, 2016 at 12:36 PM, balajishanmu...@live.in wrote: > By application I mean centOS. > > We are starting and stopping Postgres using systemd service. We have a > service file called postgresql9.3.service which is used to start or stop > Postgres. > > Excerpts

[GENERAL] Re: [BUGS] BUG #13847: WARNING: skipping "pg_toast_" --- cannot vacuum indexes, views, or special system tables VACUUM

Please quote only enough to remind readers of context an respond below the quoted text. This is the conventional style for the PostgreSQL lists, and saves a lot of time for the thousands who will read this. Thanks! On Wed, Jan 6, 2016 at 12:36 PM, Navaneethakrishnan Gopal

Re: [GENERAL] Postgresql 9.3 not coming up after restart in centos

Most of the time I will be restarting centOS by issuing reboot command. Which will do the orderly shutdown of all the service and sometimes just pull the plug. But the issue appears to be random. Is there a way that before Postgres starts we can check whether data is flushed, if not flush it