Re: [HACKERS] jsonb - jsonb operators

2016-01-18 Thread Glyn Astill
On Mon, 18/1/16, Tom Lane wrote: Subject: Re: [HACKERS] jsonb - jsonb operators To: "Dmitry Dolgov" <9erthali...@gmail.com> Cc: "Glyn Astill" , "Merlin Moncure" , "pgsql-hackers@postgresql.org" D

Re: [HACKERS] jsonb - jsonb operators

2016-01-15 Thread Glyn Astill
- Original Message - > From: Merlin Moncure > To: Glyn Astill > Cc: "pgsql-hackers@postgresql.org" > Sent: Friday, 15 January 2016, 14:50 > Subject: Re: [HACKERS] jsonb - jsonb operators > > On Fri, Jan 15, 2016 at 7:43 AM, Glyn Astill > wro

[HACKERS] jsonb - jsonb operators

2016-01-15 Thread Glyn Astill
Hi all, I was just looking through the new jsonb operators in the 9.5 release, and was wondering if there's any future intention to add a delete operator that removes element/pair matches? I.e. some sort of top-level "jsonb - jsonb" operator, e.g. # select '{"a":1, "b":2}'::jsonb - '{"b":2,

Re: [HACKERS] Triggers on transaction?

2015-05-27 Thread Glyn Astill
> From: Andreas Joseph Krogh >To: pgsql-hackers@postgresql.org >Sent: Wednesday, 27 May 2015, 13:55 >Subject: Re: [HACKERS] Triggers on transaction? > > >På onsdag 27. mai 2015 kl. 12:42:29, skrev Marko Tiikkaja : >On 5/27/15 12:39 PM, Jordan Gigov wrote: >>> I found myself in need of triggers

Re: [HACKERS] Merging postgresql.conf and postgresql.auto.conf

2015-01-14 Thread Glyn Astill
- Original Message - > From: Sawada Masahiko > To: Tom Lane > Cc: PostgreSQL-development > Sent: Wednesday, 14 January 2015, 16:09 > Subject: Re: [HACKERS] Merging postgresql.conf and postgresql.auto.conf > > On Thu, Jan 15, 2015 at 12:37 AM, Tom Lane wrote: >> Sawada Masahiko writ

Re: [HACKERS] Feature request: permissions change history for auditing

2009-11-30 Thread Glyn Astill
--- On Mon, 30/11/09, Thom Brown wrote: > As far as I am aware, there is no way to tell when a > user/role was granted permissions or had permissions > revoked, or who made these changes.  I'm wondering if > it would be useful for security auditing to maintain a > history of permissions changes o

Re: [HACKERS] [Slony1-general] ERROR: incompatible library

2008-11-13 Thread Glyn Astill
--- On Wed, 12/11/08, Tony Fernandez <[EMAIL PROTECTED]> wrote: > Date: Wednesday, 12 November, 2008, 10:52 PM > Hello lists, > > > > I am trying to run Slony on a Master Postgres 8.1.11 > replicating to a > Slave same version and 2nd Slave Postgres 8.3.4. > > I am getting the following err

[HACKERS] Problem with PgTcl auditing function on trigger

2008-01-04 Thread Glyn Astill
Hi people, I've tried posting on the general list about this, but I never get a reply, so I'm trying here. I have a function that is run each time an INSERT, DELETE or UPDATE happens on a row and log into an audit table. It is based on the info here: http://www.alberton.info/postgres

[HACKERS] Problem with PgTcl auditing function on trigger

2008-01-04 Thread Glyn Astill
Hi people, I've tried posting on the general list about this, but I never get a reply, so I'm trying here. I have a function that is run each time an INSERT, DELETE or UPDATE happens on a row and log into an audit table. It is based on the info here: http://www.alberton.info/postgresql_table_au

[HACKERS]

2008-01-03 Thread Glyn Astill
___ Support the World Aids Awareness campaign this month with Yahoo! For Good http://uk.promotions.yahoo.com/forgood/ ---(end of broadcast)--- TIP 5: don't forget to increase your