Re: [GENERAL] Prevent new timeline during archive recovery

2008-12-18 Thread Jonatan Evald Buus
Cheers for the input Simon, please find a couple of thoughts / questions below /Jona On Thu, Dec 18, 2008 at 12:04 AM, Simon Riggs wrote: > > On Wed, 2008-12-17 at 17:54 +0100, Jonatan Evald Buus wrote: > > Greetings, > > We're currently developing an alternative to

[GENERAL] Prevent new timeline during archive recovery

2008-12-17 Thread Jonatan Evald Buus
Greetings, We're currently developing an alternative to pg_standby, internally named pg_ha. pg_ha uses Record Based Log Shipping fetched by the warm standby server at millisecond intervals and will automatically restore completed WAL files on the standby server to minimize the time required when re

[GENERAL] Fetch query which triggered a rule

2008-11-20 Thread Jonatan Evald Buus
Greetings, Is it possible to fetch the query which triggered a rule? I.e. suppose I create the following rule: CREATE RULE MyRule AS ON Select TO MyTable_Tbl DO INSTEAD process_query($sql); Where $sql represents the query which triggered the rule. Appreciate the input Cheers Jona

[GENERAL] row-level security (Dynamically rewrite queries)

2008-11-20 Thread Jonatan Evald Buus
Hi there, Is it possible to dynamically rewrite an SQL query for all operations (SELECT, INSERT, UPATE, DELETE etc.)? It seems that using RULES it's possible to replace one query with another, but can the actual query that was executed by retrieved so it can be dynamically modified? I.e. I'd like t