Re: [GENERAL] repeated characters in SQL

On 24 January 2016 at 12:44, Govind Chettiar wrote: > I have a simple table consisting of a bunch of English words. I am trying > to find words that have repeated characters in them, for example > apple > tattoo > > but not > > orange > lemon > > I know that only a maximum of one repetition can o

Re: [GENERAL] Let's Do the CoC Right

This is mostly in response to David's recent comments. I should say David, you are really beginning to make me feel unsafe. By unsafe I mean my mental safety of being able to speak truthfully without fear of being kicked out of a community I love. I do not think we need a Coc and if we do, it's o

Re: [GENERAL] Let's Do the CoC Right

On Sat, 23 Jan 2016 15:43:11 -0800 "Joshua D. Drake" wrote: > I have been accused of being a fat hater. My crime? I suggested that > generally speaking, obesity is a matter of diet and exercise. Worse? > The individual started the conversation and I am also classified as > obese (barely, I won'

Re: [GENERAL] CoC [Final v2]

On 01/23/2016 04:00 PM, David E. Wheeler wrote: On Jan 22, 2016, at 6:47 PM, Joshua D. Drake wrote: This document provides community guidelines for a safe, respectful, productive, and collaborative place for any person who is willing to contribute to the PostgreSQL community. It applies to a

Re: [GENERAL] Let's Do the CoC Right

On Sat, 23 Jan 2016 17:09:32 -0500 Melvin Davidson wrote: > I been pretty quiet about this whole discussion, but now I have to > ask the following questions. > > This is an INTERNET SUPPORT FORUM. > Just how in the hell is it possible for anyone to have their actual > sex detected unless they vo

Re: [GENERAL] Let's Do the CoC Right

On Sun, 24 Jan 2016 00:00:27 + Geoff Winkless wrote: > On 23 January 2016 at 21:59, Steve Litt > wrote: > > I'm reminded of a person on a computer on a no-Internet-connection > > LAN saying that everyone needs equal protection from firewalls. > > Ummm, no. The Internet connected firewall has

Re: [GENERAL] Let's Do the CoC Right

On 23 January 2016 at 23:39, David E. Wheeler wrote: > I get that my short, snarky posts don’t help my argument, but I admit to > being a bit frustrated that the posts wherein I have tried to lay out a > position get little or no response. So let me try again. They get a response; however it's

Re: [GENERAL] Let's Do the CoC Right

On Jan 23, 2016, at 3:43 PM, Joshua D. Drake wrote: > I have been accused of being a fat hater. My crime? I suggested that > generally speaking, obesity is a matter of diet and exercise. Worse? The > individual started the conversation and I am also classified as obese > (barely, I won't be in

Re: [GENERAL] Let's Do the CoC Right

On Jan 23, 2016, at 1:59 PM, Steve Litt wrote: > We all need the necessary protection, which is not necessarily equal > protection, because some of us are subjected to much more harassment. > And I think we all need to walk a mile in other peoples shoes before > assuming others need only the meag

Re: [GENERAL] CoC [Final v2]

On Jan 22, 2016, at 6:47 PM, Joshua D. Drake wrote: > This document provides community guidelines for a safe, respectful, > productive, and collaborative place for any person who is willing to > contribute to the PostgreSQL community. It applies to all "collaborative > space", which is defined

Re: [GENERAL] Let's Do the CoC Right

On 23 January 2016 at 21:59, Steve Litt wrote: > I'm reminded of a person on a computer on a no-Internet-connection LAN > saying that everyone needs equal protection from firewalls. Ummm, no. > The Internet connected firewall has many, many more attempts made > against it than the guy on the islan

Re: [GENERAL] A motion

On 01/23/2016 03:40 PM, Andres Freund wrote: On 2016-01-23 15:31:02 -0800, Joshua D. Drake wrote: With respect Adrian, that is a motion that never stands a chance. If you don't want to read it, set up a filter that sends it right to the round file. It'd help if there weren't six, but one threa

[GENERAL] repeated characters in SQL

I have a simple table consisting of a bunch of English words. I am trying to find words that have repeated characters in them, for example apple tattoo but not orange lemon I know that only a maximum of one repetition can occur I tried various options like SELECT word FROM public."SpellItWord

Re: [GENERAL] Let's Do the CoC Right

On 01/23/2016 01:59 PM, Steve Litt wrote: We all need the necessary protection, which is not necessarily equal protection, because some of us are subjected to much more harassment. And I think we all need to walk a mile in other peoples shoes before assuming others need only the meager amount of

Re: [GENERAL] A motion

On 01/23/2016 03:31 PM, Joshua D. Drake wrote: On 01/23/2016 03:08 PM, Adrian Klaver wrote: On 01/23/2016 03:03 PM, Berend Tober wrote: Adrian Klaver wrote: Motion: The Coc discussion be moved to its own list where those who care can argue to their hearts content and leave the rest of us to

Re: [GENERAL] A motion

On 2016-01-23 15:31:02 -0800, Joshua D. Drake wrote: > With respect Adrian, that is a motion that never stands a chance. If you > don't want to read it, set up a filter that sends it right to the round > file. It'd help if there weren't six, but one thread... -- Sent via pgsql-general mailing l

Re: [GENERAL] Let's Do the CoC Right

Hi PostgreSQL General. I get that my short, snarky posts don’t help my argument, but I admit to being a bit frustrated that the posts wherein I have tried to lay out a position get little or no response. So let me try again. 1. Items in the current draft of the CoC can be manipulated by abusers

Re: [GENERAL] A motion

On 01/23/2016 03:08 PM, Adrian Klaver wrote: On 01/23/2016 03:03 PM, Berend Tober wrote: Adrian Klaver wrote: Motion: The Coc discussion be moved to its own list where those who care can argue to their hearts content and leave the rest of us to deal with technical questions. Upon a decision o

Re: [GENERAL] long transfer time for binary data

Am 23.01.2016 um 23:38 schrieb John R Pierce: > On 1/23/2016 2:19 PM, Johannes wrote: >> I save my images as large object, which afaik is in practise not >> readable with a binary cursor (we should use the lo_* functions). And of >> course I already use the LargeObjectManager of the postgresql jdbc

Re: [GENERAL] A motion

On 01/23/2016 03:03 PM, Berend Tober wrote: Adrian Klaver wrote: Motion: The Coc discussion be moved to its own list where those who care can argue to their hearts content and leave the rest of us to deal with technical questions. Upon a decision on said list the result be posted to the Postgr

[GENERAL] A motion

Motion: The Coc discussion be moved to its own list where those who care can argue to their hearts content and leave the rest of us to deal with technical questions. Upon a decision on said list the result be posted to the Postgres web site for consideration. Thanks, -- Adrian Klaver adria

Re: [GENERAL] long transfer time for binary data

On 1/23/2016 2:19 PM, Johannes wrote: I save my images as large object, which afaik is in practise not readable with a binary cursor (we should use the lo_* functions). And of course I already use the LargeObjectManager of the postgresql jdbc library. afaik, Large Objects are completely indepe

Re: [GENERAL] long transfer time for binary data

Am 23.01.2016 um 01:25 schrieb Daniel Verite: > Johannes wrote: > >> psql >> select lo_get(12345); >> +ssl -compression 6.0 sec >> -ssl 4.4 sec > > psql requests results in text format so that SELECT does not > really test the transfer of binary data. > With bytea_output to 'he

Re: [GENERAL] Let's Do the CoC Right

I been pretty quiet about this whole discussion, but now I have to ask the following questions. This is an INTERNET SUPPORT FORUM. Just how in the hell is it possible for anyone to have their actual sex detected unless they voluntarily provide it? Further to the point, how is it possible to harass

Re: [GENERAL] Let's Do the CoC Right

On Sat, 23 Jan 2016 20:12:15 + Geoff Winkless wrote: > On 23 January 2016 at 18:07, David E. Wheeler > wrote: > > On Jan 22, 2016, at 6:14 PM, Joshua D. Drake > > wrote: > >> A Code of Conduct should protect all, equally and without bias. > > > > Says someone who requires no protection

Re: [GENERAL] Let's Do the CoC Right

On 23 January 2016 at 18:07, David E. Wheeler wrote: > On Jan 22, 2016, at 6:14 PM, Joshua D. Drake wrote: >> A Code of Conduct should protect all, equally and without bias. > > Says someone who requires no protection at all. I must object to the repeated assertions that certain people in this c

Re: [GENERAL] Let's Do the CoC Right

On 01/23/2016 10:07 AM, David E. Wheeler wrote: On Jan 22, 2016, at 6:14 PM, Joshua D. Drake wrote: You can not violate one part of the CoC and use the other part as the reason. You say, that, and yet someone will. Think about law: if laws contradict each other, a person accused of violatin

Re: [GENERAL] Let's Do the CoC Right

On Jan 22, 2016, at 6:14 PM, Joshua D. Drake wrote: > You can not violate one part of the CoC and use the other part as the reason. You say, that, and yet someone will. Think about law: if laws contradict each other, a person accused of violating one law will use the other in their defense. >

Re: [GENERAL] Let's Do the CoC Right

On 22 January 2016 at 23:31, David E. Wheeler wrote: > On Jan 22, 2016, at 3:15 PM, Kevin Grittner wrote: > >> I do wonder what it is that made you terrified of a shitstorm, and >> what it is that you're hoping for that you don't feel is already >> present. > > Regina linked to some shitstorms in

Re: [GENERAL] 9.5 new features

http://www.postgresql.org/docs/9.5/interactive/brin-intro.html 62.1. Introduction ... "A block range is a group of pages that are physically adjacent in the table; for each block range, some summary info is stored by the index." >From the above, may I presume that it is best to cluster (or sort),

Re: [GENERAL] Building PostgreSQL 9.6devel sources with Microsoft Visual C++ 2015?

On Fri, Jan 22, 2016 at 9:06 PM, Yury Zhuravlev wrote: > Please look at the new patch. It is filled with black magic, but it looks > still more true. > He agreed with the internal API. +__crt_locale_data_public* public_loct = __acrt_get_locale_data_prefix(loct); Where did you get that? --

Re: [GENERAL] Connecting to SQL Server from Windows using FDW

> On 23 January 2016 at 04:40, John J. Turner wrote: > On Jan 22, 2016, at 1:05 PM, ivo silvestre wrote: > > > I need to create a linked server between 2 Windows servers. In one I've > > PostgreSQL with admin privileges and in the other MS SQL with only read > > access. > > > > I need to creat

Re: [GENERAL] 9.5 new features

Sounds like a great feature. How can it be tested? I am particularly thinking of window servers and effect of this on a live system and any performance issues. It is an exciting feature. Thanks guys. -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-gener

Re: [GENERAL] 9.5 new features

On 23 January 2016 at 22:41, Vik Fearing wrote: > On 01/23/2016 10:28 AM, John R Pierce wrote: >> anyways, yeah, BRIN sounds very cool for very large tables with >> relatively stable data. > > I have found it particularly efficient when the BRIN index contains all > columns of the table. Just usi

Re: [GENERAL] 9.5 new features

On 01/23/2016 10:28 AM, John R Pierce wrote: > On 1/23/2016 12:35 AM, Vik Fearing wrote: >>> >ok, but it doesn't deal with our use case of needing to bulk delete a 6 >> I can't really parse the end of that sentence, but you are correct that >> BRIN does not help at all with partition dropping. Thi

Re: [GENERAL] long transfer time for binary data

On Fri, 22 Jan 2016 22:05:24 +0100, Johannes wrote: >Thanks for explanation. Im writing a client software in java/jdbc. Most >images are in jpeg format. Some have high quality, most medium. Unfortunately I'm not terribly conversant in Java ... I can read/understand it, but I rarely write any.

Re: [GENERAL] 9.5 new features

On 1/23/2016 12:35 AM, Vik Fearing wrote: >ok, but it doesn't deal with our use case of needing to bulk delete a 6 I can't really parse the end of that sentence, but you are correct that BRIN does not help at all with partition dropping. Think of it more as a Seq Scan optimization. yeah, it w

Re: [GENERAL] Connecting to SQL Server from Windows using FDW

Hi John, Thanks, but I already saw that link. The problem is to installing the tds_fwd extension on postgres. And I don't know how to (never tried) compile it... What comes with postgres by default is the postgres fdw , that allow t

Re: [GENERAL] Let's Do the CoC Right

On Fri, Jan 22, 2016 at 6:25 AM, David E. Wheeler wrote: > Fellow PostgreSQLers, > > I can’t help that there are a whole lot of white guys working on this > document, with very little feedback from the people who it’s likely to > benefit (only exception I spotted in a quick scan was Regina; sorry

Re: [GENERAL] 9.5 new features

On 01/23/2016 04:42 AM, John R Pierce wrote: > On 1/22/2016 7:13 PM, David Rowley wrote: >> BRIN can be seen as a form of "automatic partitioning", and I have >> seen it described as such in documents relating to the BRIN project, >> so perhaps that description has made its way further afield and t