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

> On Jan 12, 2016, at 7:50 AM, Vick Khera wrote: > > On Mon, Jan 11, 2016 at 6:55 PM, Steve Litt wrote: >> All because somebody just *had* to personally insult someone else, >> repeatedly, and nobody thought that was a bad thing, and when the >>

Re: [GENERAL] WIP: CoC

> On Jan 12, 2016, at 12:20 AM, Tom Lane wrote: > > [ 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

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

> On Jan 10, 2016, at 2:59 PM, Joshua D. Drake wrote: > > On 01/10/2016 10:44 AM, Regina Obe wrote: > >>> JD >> >> This may come as a big shock to many of you, but as a contributor >> I don't care if you are racist, sexist, transphobic or whatever as long as >> you >

Re: [GENERAL] PostgreSQL Developer Best Practices

On Aug 22, 2015, at 10:15 AM, Melvin Davidson melvin6...@gmail.com wrote: 6. Although it is legal to use the form column TYPE PRIMARY KEY, It is best to specify as a CONSTRAINT, that way YOU get to choose the name, otherwise postgres assigns a default name which may not be to your

Re: [GENERAL] PostgreSQL Developer Best Practices

On Aug 25, 2015, at 1:38 PM, Karsten Hilbert karsten.hilb...@gmx.net wrote: In most cases developers don’t care about index, unique, foreign key, or primary key names (from a coding standpoint) Until the day they’d like to write a reliable database change script. Not sure I understand.

Re: [GENERAL] Create Virtual Indexes on Postgres

On Feb 26, 2015, at 12:47 AM, Sreerama Manoj manoj.sreerama...@gmail.com wrote: Hi, I use Postgres 9.4 database.Now,I am optimizing the queries by using the results of explain and explain analyze,Sometimes I am creating Indexes to optimize them. But, I was not successful sometimes

Re: [GENERAL] Create Virtual Indexes on Postgres

and the execution time of query before actually creating that Index. Is there any provision to do that in Postgres (or) suggest any way to find that On Thu, Feb 26, 2015 at 7:09 PM, Neil Tiffin ne...@neiltiffin.com mailto:ne...@neiltiffin.com wrote: On Feb 26, 2015, at 12:47 AM, Sreerama Manoj

[GENERAL] Help with PostgreSQL 9.4 to expand jsonb int array into table with row numbers

Trying to wrap my head around postgresql 9.4 jsonb and would like some help figuring out how to do the following. Given the following example jsonb: ‘{“name1” : value1, “name2” : value2, “name3” : [int1, int2, int3] }’::jsonb AS table1.column1 Wanted: Return the “name3” array

Re: [GENERAL] Postgre SQL SHA-256 Compliance

On Sep 22, 2014, at 9:46 AM, Paul Jungwirth p...@illuminatedcomputing.com wrote: Can you confirm that your software is SHA-256 Compliant? Postgres's SSL certificate key live at the value of ssl_cert_file and ssl_key_file in your postgresql.conf. Why not point it at a SHA-256 certificate,

Re: [GENERAL] Offending My Tender Sensibilities -OR- OLTP on a Star Schema

On Feb 6, 2014, at 12:44 PM, Scott Marlowe scott.marl...@gmail.com wrote: Merlin, this reminds me of the quote from Mencken: For every complex problem there is an answer that is clear, simple, and wrong. Or as Niklaus Wirth said. ... complexity has and will maintain a strong fascination for

Re: [GENERAL] Why are stored procedures looked on so negatively?

On Jul 23, 2013, at 7:29 PM, Some Developer someukdevelo...@gmail.com wrote: I've done quite a bit of reading on stored procedures recently and the consensus seems to be that you shouldn't use them unless you really must. Application architecture is a specific software engineering discipline.

Re: [GENERAL] Postgres case insensitive searches

On Jun 29, 2013, at 11:24 AM, bhanu udaya udayabhanu1...@hotmail.com wrote: Upper and Lower functions are not right choice when the table is 2.5 million and where we also have heavy insert transactions. PostgreSQL and SQL Server are completely different. Rules that apply to SQL Server do

Re: [GENERAL] Supporting SQL/MED DATALINK

On Jan 9, 2012, at 5:07 AM, Alban Hertroys wrote: On 9 January 2012 09:56, Damiano ALBANI I believe DB2 is pretty much it in this area. For the record, it looks like MS SQL Server has some equivalent feature : FILESTREAM. And Oracle has BFILE. I've actually been thinking about how to

Re: [GENERAL] Installation woes via Macports on Mac OS X 10.7

On Oct 8, 2011, at 1:01 AM, Tom Lane wrote: =?iso-8859-1?Q?Ren=E9_Fournier?= renefourn...@gmail.com writes: I've tried installation 8.4 and 9.0 on two different machines, and at the end can't start Postgresql. Here's the basic story: No, you started it all right, because it's there in the

Re: [GENERAL] Mac OS X shared_buffers not same as postgresql.conf file

On Sep 24, 2011, at 4:21 PM, Guillaume Lelarge wrote: On Sat, 2011-09-24 at 14:43 -0500, Neil Tiffin wrote: On Sep 24, 2011, at 1:31 PM, Joe Conway wrote: On 09/23/2011 02:33 PM, Neil Tiffin wrote: I have shared_buffers in the config file set for 32 MB and pgAdmin reports a value of 32 MB

[GENERAL] Mac OS X shared_buffers not same as postgresql.conf file

Hello all, I am hoping someone can help me with 9.0.4 server on 8GB Mac w/Snow Leopard and shared_buffers configuration setting. I have shared_buffers in the config file set for 32 MB and pgAdmin reports a value of 32 MB, but pgAdmin also says the current value is 4096. Can anyone point

Re: [GENERAL] Mac OS X shared_buffers not same as postgresql.conf file

On Sep 24, 2011, at 1:31 PM, Joe Conway wrote: On 09/23/2011 02:33 PM, Neil Tiffin wrote: I have shared_buffers in the config file set for 32 MB and pgAdmin reports a value of 32 MB, but pgAdmin also says the current value is 4096. Can anyone point me to any docs about why the current value