Re: [HACKERS] strange behaviour of psql \e command

2016-01-01 Thread Neil Tiffin
> On Jan 1, 2016, at 11:14 AM, Tom Lane wrote: > > Oleg Bartunov writes: >> I noticed, that psql's \e command doesn't worked for me complaining 'error >> opening file'. I did research and found that following setting in joe's (if >> I choose editor as joe) configuraton causes the problem: >> -e

Re: [HACKERS] [patch] to build docs on Mac OS X El Capitan with MacPorts

2015-11-03 Thread Neil Tiffin
I should add that this was required for a postgres git build using MacPorts to supply dependencies and not a build of postgres using MacPorts. Neil > On Nov 3, 2015, at 8:11 AM, Robert Haas wrote: > > On Sun, Nov 1, 2015 at 8:41 AM, Neil Tiffin wrote: >> The attached patch

[HACKERS] [patch] to build docs on Mac OS X El Capitan with MacPorts

2015-11-01 Thread Neil Tiffin
The attached patch was required to get the docs to build on Mac OS X 10.11.1 (15B42) with MacPorts 2.3.4. After changing docbook.m4 ‘autoreconf’ has to be run. This patch does not include the new version of ‘configure' As explained in the devel documentation (J.2.6) the docs could be made to b

Re: [HACKERS] RFC: Remove contrib entirely

2015-06-05 Thread Neil Tiffin
> On Jun 4, 2015, at 3:11 PM, David E. Wheeler wrote: > > On Jun 4, 2015, at 11:53 AM, Neil Tiffin wrote: > >> I have looked at PGXN and would never install anything from it. Why? >> Because it is impossible to tell, without inside knowledge or a lot of wo

Re: [HACKERS] RFC: Remove contrib entirely

2015-06-04 Thread Neil Tiffin
> On Jun 4, 2015, at 10:55 AM, Jim Nasby wrote: > > Personally, I'd rather we publish a list of formally vetted and approved > versions of PGXN modules. There are many benefits to that, and the downside > of not having that stuff as part of make check would be overcome by the > explicit testi

Re: [HACKERS] pgaudit - an auditing extension for PostgreSQL

2015-02-18 Thread Neil Tiffin
Stephen, I meant it to go to the list, but hit the wrong button. > On Feb 17, 2015, at 7:01 PM, Stephen Frost wrote: > > Neil, > > I noticed that you email'd me directly on this reply. Not sure if you > intended to or not, but I'm fine with my response going to

Re: [HACKERS] pgaudit - an auditing extension for PostgreSQL

2015-02-17 Thread Neil Tiffin
> On Feb 17, 2015, at 3:40 AM, Yeb Havinga wrote: > > Hi list, > . . . . . > Auditing superuser access means auditing beyond the running database. > The superuser can dump a table, and pipe this data everywhere outside of > the auditing domain. I cannot begin to imagine the kind of security >

Re: [HACKERS] [pgsql-packagers] Palle Girgensohn's ICU patch

2014-11-26 Thread Neil Tiffin
On Nov 26, 2014, at 8:21 AM, Greg Stark wrote: > I find it hard to believe the original premise of this thread. We knew > there were some problems with OSX and FreeBSD but surely they can't be > completely broken? Ever tried to use Spotlight for searching (English) on the Mac, not completely b

Re: [HACKERS] PL/pgSQL 2

2014-09-02 Thread Neil Tiffin
On Sep 1, 2014, at 10:24 PM, Craig Ringer wrote: > On 09/02/2014 08:09 AM, Neil Tiffin wrote: >> Now I could use other languages as was suggested upstream. Lets see, I use >> R all the time, but R is not a first class language, not in core, and its >> slow. Python 3 woul

Re: [HACKERS] PL/pgSQL 2

2014-09-01 Thread Neil Tiffin
On Sep 1, 2014, at 10:45 AM, Tom Lane wrote: > What is actually being proposed, AFAICS, is a one-shot fix for a bunch > of unfortunate choices. That might be worth doing, but let's not fool > ourselves about whether it’s one-shot or not. Well, one shot every 18 years is not so bad. I am only

Re: [HACKERS] pgaudit - an auditing extension for PostgreSQL

2014-05-06 Thread Neil Tiffin
On May 4, 2014, at 5:27 PM, Stephen Frost wrote: > * Neil Tiffin (ne...@neiltiffin.com) wrote: >> On May 4, 2014, at 3:17 PM, Stephen Frost wrote: >>> Any system where there exists a role similar to 'superuser' in the PG >>> sense (a user who is equivilant

Re: [HACKERS] pgaudit - an auditing extension for PostgreSQL

2014-05-04 Thread Neil Tiffin
> something concrete and useful. Further comments inline. > > * Neil Tiffin (ne...@neiltiffin.com) wrote: >> In considering how this might apply to PostgreSQL, it seems that once formal >> auditing is turned on, basic non-changeable level of audit reporting should >>

Re: [HACKERS] pgaudit - an auditing extension for PostgreSQL

2014-05-04 Thread Neil Tiffin
On May 4, 2014, at 10:12 AM, Tom Lane wrote: > Stephen Frost writes: >> * Abhijit Menon-Sen (a...@2ndquadrant.com) wrote: >>> 1. I wish it were possible to prevent even the superuser from disabling >>> audit logging once it's enabled, so that if someone gained superuser >>> access without author

Re: [HACKERS] Deprecating RULES

2012-10-17 Thread Neil Tiffin
On Oct 17, 2012, at 4:45 PM, Daniel Farina wrote: > On Wed, Oct 17, 2012 at 1:12 PM, Josh Berkus wrote: >> On 10/17/12 12:57 PM, Daniel Farina wrote: >>> I'll have to register my disagreement then, in the special case where >>> a feature becomes so obscure that many people don't have a wide-spre

Re: [HACKERS] Darwin 1.4 (OS X 10.1) Broken Compile, Snapshot and

2001-10-05 Thread Neil Tiffin
il list. http://lists.apple.com/archives/darwin-development/2001/Sep/19.html has something like: simply add -flat_namespace to the LDFLAGS. And later on the same page are the patches to make it work. Neil Tiffin Chicago ---(end of broadcast)---

Re: [HACKERS] Darwin 1.4 (OS X 10.1) Broken Compile, Snapshot and

2001-10-05 Thread Neil Tiffin
At 9:41 AM -0400 10/5/01, Alex Avriette wrote: >I had a catastrophic crash on one of our webservers here and took the >opportunity to upgrade it. Unfortunately, after the upgrade, I am unable to >compile either 7.1.3 or the current snapshot of postgres. > >The error I get is rather opaque: > >/usr

Re: Proposal: [HACKERS] OID wraparound: summary and proposal

2001-08-07 Thread Neil Tiffin
At 11:22 AM -0400 8/7/01, Tom Lane wrote: >Neil Tiffin <[EMAIL PROTECTED]> writes: >> I have not even considered multiple database servers running >> different database, which is our design goal. In this case we would >> like to have a slimmed down (and blazingly

Re: Proposal: [HACKERS] OID wraparound: summary and proposal

2001-08-07 Thread Neil Tiffin
At 10:09 AM +0500 8/7/01, Hannu Krosing wrote: >Neil Tiffin wrote: >> >> I would just like to comment that for our project, GNU Enterprise, we >> use our own 128 bit object ID that is unique (UUID) for every row in >> all tables. >> >> It seems to

Re: Proposal: [HACKERS] OID wraparound: summary and proposal

2001-08-03 Thread Neil Tiffin
I would just like to comment that for our project, GNU Enterprise, we use our own 128 bit object ID that is unique (UUID) for every row in all tables. It seems to me, without having looked into it, that having both a PostgreSQL UID and our own 128 bit objectid (UUID) is redundant and slows t

[HACKERS] Regression failed Mac OSX

2001-04-04 Thread Neil Tiffin
Using current cvs version on Mac OS X 10.0 built with ./configure make made check test horology ... FAILED from the regression.diffs file Is this a problem or not? Neil Tiffin Chicago [localhost:src/test/regress] ntiffin% cat regression.diffs *** ./expected/horology.out Sun

[HACKERS] Problem Building on Mac OSX

2001-04-04 Thread Neil Tiffin
I am trying to build Mac OSX 10.0 from the current cvs. ./configure --with-perl --with-openssl --enable-syslog |& tee configure.logfile make |& tee Makefile.logfile Running Mkbootstrap for plperl () chmod 644 plperl.bs LD_RUN_PATH="" cc -o blib/arch/auto/plperl/plperl.bundle -bundle -unde