Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Joe
> Sent: 27 June 2006 15:15
> To: Andrew Sullivan
> Cc: pgsql-sql@postgresql.org
> Subject: Re: Fwd: [SQL] Start up question about triggers
>
> Andrew Sullivan wrote:
> > On Tue, Ju
Richard Broersma Jr wrote:
> I thought that Mammoth replicator might support synchronous masters
> but it appears to be an Asynchronous system like Slony.
> http://www.commandprompt.com/products/mammothreplicator
You are right, Mammoth Replicator is asynchronous single master, just
like Slony.
-
> > Actually man I do need to be able to write to both databases, and keep them
> > synchronized, and all this because of the recurring xenofobia for technology
>
> Then sorry, but this can't be done out of the box by anything. You
> have all manner of race conditions here.
Doesn't PGcluster al
On Tue, Jun 27, 2006 at 08:14:34AM -0400, Joe wrote:
>
> But with file-based log shipping (see
> http://linuxfinances.info/info/logshipping.html) one could write a Java
> app to control when the updates are applied.
Well, sure. I mean, if you decide first, "I'll use Java," and then
start askin
On Tue, Jun 27, 2006 at 02:48:38PM +0300, Forums @ Existanze wrote:
> Hello again andrew,
>
> Actually man I do need to be able to write to both databases, and keep them
> synchronized, and all this because of the recurring xenofobia for technology
Then sorry, but this can't be done out of the bo
Andrew Sullivan wrote:
On Tue, Jun 27, 2006 at 11:16:17AM +0300, Forums @ Existanze wrote:
I looked into slony, I have a question though, how would I go about
controlling slony via a jdbc driver? See this whole problem has arisen
because for some reason my client wants to keep to separate databa
Of Andrew Sullivan
> Sent: 27 June 2006 14:40
> To: pgsql-sql@postgresql.org
> Subject: Re: Fwd: [SQL] Start up question about triggers
>
> On Tue, Jun 27, 2006 at 11:16:17AM +0300, Forums @ Existanze wrote:
> >
> > I looked into slony, I have a question though, how woul
On Tue, Jun 27, 2006 at 11:16:17AM +0300, Forums @ Existanze wrote:
>
> I looked into slony, I have a question though, how would I go about
> controlling slony via a jdbc driver? See this whole problem has arisen
> because for some reason my client wants to keep to separate databases in two
> sepa
age-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Sullivan
> Sent: 26 June 2006 17:43
> To: pgsql-sql@postgresql.org
> Subject: Re: Fwd: [SQL] Start up question about triggers
>
> On Mon, Jun 26, 2006 at 04:59:26PM +0300, Forums @ Existanze wrote:
>
On Mon, Jun 26, 2006 at 10:38:06AM -0500, Scott Marlowe wrote:
> I bet it would be possible to hack pgpool to do this. Just have it
> shoot all the queries that come in to it at the normal database, AND at
> a text file or something like that.
Now you're back to the same problem: it doesn't tell
On Mon, 2006-06-26 at 08:59, Forums @ Existanze wrote:
> Hello again,
>
> The problem is not tracking WHAT changed, this can be done, as we have
> discussed in this thread, the problem is how to replicate the necessary
> commands that will alter a mirror database to reflect what has been changed,
On Mon, Jun 26, 2006 at 04:59:26PM +0300, Forums @ Existanze wrote:
> Hello again,
>
> The problem is not tracking WHAT changed, this can be done, as we have
> discussed in this thread, the problem is how to replicate the necessary
> commands that will alter a mirror database to reflect what has b
> The problem is not tracking WHAT changed, this can be done, as we have
> discussed in this thread, the problem is how to replicate the necessary
> commands that will alter a mirror database to reflect what has been changed,
> sequencially and in the order that it has occurred.
If your finial goa
Best Regards,
Fotis
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Sullivan
> Sent: 26 June 2006 13:43
> To: pgsql-sql@postgresql.org
> Subject: Re: Fwd: [SQL] Start up question about triggers
>
> On Fri, Jun 23, 2006 at 10:29:3
On Fri, Jun 23, 2006 at 10:29:33PM -0500, Aaron Bono wrote:
>
> What I really cannot find is a way to _dynamically_ in the trigger ask what
> COLUMNS are in OLD and NEW. If we had:
All of the columns, of course. When the tuple is UPDATEd, even if
you did not mention some columns in your UPDATE,
This is why I was searching for good meta data.Here is a thought. If your trigger has the OLD and NEW, is there a way to get a list of fields from OLD and NEW? If TG_RELNAME is the name of the table, could you just ask PostgreSQL what the columns are in that table, iterate through those columns,
Andrew Sullivan <[EMAIL PROTECTED]> writes:
> On Fri, Jun 23, 2006 at 06:48:49PM +0300, Forums @ Existanze wrote:
>> Then there exist a TG_QUERY parameter that we could use to get the actual
>> query ran by a user, so if I ran the imaginary query
> Which "actual query"? By the time the trigger fi
On Fri, Jun 23, 2006 at 06:48:49PM +0300, Forums @ Existanze wrote:
>
> Then there exist a TG_QUERY parameter that we could use to get the actual
> query ran by a user, so if I ran the imaginary query
Which "actual query"? By the time the trigger fires, the query might
already have been rewritte
D]
> [mailto:[EMAIL PROTECTED] On Behalf Of Forums @
> Existanze
> Sent: 23 June 2006 18:49
> To: pgsql-sql@postgresql.org
> Subject: Re: Fwd: [SQL] Start up question about triggers
>
> Hello again,
>
> First of all thank you all for your effort in helping me
> solv
s
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of George Weaver
> Sent: 23 June 2006 15:38
> To: Forums @ Existanze
> Cc: pgsql-sql@postgresql.org
> Subject: Re: Fwd: [SQL] Start up question about triggers
>
> Hi Fotis,
&
> Im really interested in the part where you say "generic trigger" can you
> give me some tips? As to how I will go about that? I had already read the
> links that Richard gave, I new I could get the values like that. So right
> now I will have to create a trigger for each of my tables to create th
lumns).
Regards,
George
- Original Message -
From: "Forums @ Existanze" <[EMAIL PROTECTED]>
To:
Sent: Friday, June 23, 2006 2:15 AM
Subject: Re: Fwd: [SQL] Start up question about triggers
Hello again aaron,
Im really interested in the part where you say "generi
pgsql-sql@postgresql.org
> Subject: Re: Fwd: [SQL] Start up question about triggers
>
> > I did some research and can't even find a way to get meta
> data in a trigger.
> >
> > In a trigger, is there a way to inspect OLD and NEW to see what
> > columns are
> I did some research and can't even find a way to get meta data in a trigger.
>
> In a trigger, is there a way to inspect OLD and NEW to see what columns are
> there and see what has changed? If so, you may not be able to grab the
> actual query but you could create a generic trigger that recons
I did some research and can't even find a way to get meta data in a trigger.In a trigger, is there a way to inspect OLD and NEW to see what columns are there and see what has changed? If so, you may not be able to grab the actual query but you could create a generic trigger that reconstructs a pos
c: pgsql-sql@postgresql.orgSubject: Re: [SQL]
Start up question about triggers
Why not just create a history table and have the trigger copy the
data out of the table into the history table with a time stamp of the
change. Then you don't need the query.For exampleTable
A
D]] On Behalf Of Forums @
ExistanzeSent: 22 June 2006 12:19To:
pgsql-sql@postgresql.orgSubject: [SQL] Start up question about
triggers
Hello
all,
I know that this
question may be really simple, but I have decided to ask here due to fact that
I don't know how to s
PROTECTED] On Behalf Of Forums @
ExistanzeSent: 22 June 2006 12:19To:
pgsql-sql@postgresql.orgSubject: [SQL] Start up question about
triggers
Hello
all,
I know that this
question may be really simple, but I have decided to ask here due to fact that
I don't know how to search f
Hello
all,
I know that this
question may be really simple, but I have decided to ask here due to fact that I
don't know how to search for this on google or on the docs.
I created a trigger
fuction which updates a specific row in some table A. Is it possible to retain
the query that was
29 matches
Mail list logo
