brave new
world of SAS and Blackbox type applications Maybe 32 years as a
database programmer is just too long.
Thanks
Andrew
On Wed, 13 Jun 2018 at 14:12 Adrian Klaver
wrote:
> On 06/12/2018 08:25 PM, David G. Johnston wrote:
> > On Tuesday, June 12, 2018, Andre
Ok, thanks. will try
On Wed, 13 Jun 2018 at 13:25 David G. Johnston
wrote:
> On Tuesday, June 12, 2018, Andrew Bartley wrote:
>
>> On Wed, 13 Jun 2018 at 12:43 Laurenz Albe
>> wrote:
>>
>
>>> log_min_duration_statement = 0
>>>
>> [...]
On Wed, 13 Jun 2018 at 12:43 Laurenz Albe wrote:
> Andrew Bartley wrote:
> > Can someone please tell me how to log the values being inserted in this
> example..
> >
> > 2018-06-12 22:31:49 UTC-5b2049d4.434ac-STATEMENT: insert into
> "api_consumers" ("c
ions and combinations.
Thanks
Andrew Bartley
financial, and used only
very rarely, and only for analysis of access and performance in a batch
setting. Also certainly not via a trigger, as we don't want the logging
bound to the transaction.
On Fri, 25 May 2018 at 07:17 David G. Johnston
wrote:
> On Thursday, May 24, 2018, Andrew
Sorry that should be a "vacuum full freeze"... not just a "vacuum freeze"
On Fri, 25 May 2018 at 07:07 Andrew Bartley wrote:
> Hi,
>
> The two main techniques we use are.
>
> 1. Create a script to pass the -t param to pg_dump to exclude the log
> tables.
Hi,
The two main techniques we use are.
1. Create a script to pass the -t param to pg_dump to exclude the log
tables. The idea here is to backup the rest of your DB to one backup
regime and the log tables to another. We set it up so at the end of the day
the current log table is backed up and lo
Sorry Roles
On Fri, 2 Feb 2018 at 08:29 Rob Sargent wrote:
>
>
> On 02/01/2018 02:22 PM, Andrew Bartley wrote:
> > Hi all,
> >
> > I am trying to work out a way to create a roll/user that can only
> > execute one particular function and nothing else. The
Hi all,
I am trying to work out a way to create a roll/user that can only execute
one particular function and nothing else. The particular function has been
created with "SECURITY DEFINER".
Regards
Andrew Bartley
