Re: [SQL] MS-SQL<->Postgres sync

2006-07-10 Thread Forums @ Existanze
  We are looking for the exact thing but with two PostgreSQL databases   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin BednarSent: 10 July 2006 18:28To: pgsql-sql@postgresql.orgSubject: [SQL] MS-SQL<->Postgres sync Looking to keep 2 databases in s

[SQL] Custom Data Type Mapping JDBC

2006-07-07 Thread Forums @ Existanze
Hello all,   Let me explain the situation to the best of my knowledge. I am running postgres 8.1, and I read the documentation on CREATE TYPE, this could be extremely usefull for us at the moment. So I went ahead with this little test   CREATE TYPE boolean_date AS(     checked bool,     va

Re: Fwd: [SQL] Start up question about triggers

2006-07-03 Thread Forums @ Existanze
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

Re: Fwd: [SQL] Start up question about triggers

2006-06-27 Thread Forums @ Existanze
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

Re: Fwd: [SQL] Start up question about triggers

2006-06-27 Thread Forums @ Existanze
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: >

Re: Fwd: [SQL] Start up question about triggers

2006-06-26 Thread Forums @ Existanze
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, sequencially and in the order that it has occurred. I you can fi

Re: Fwd: [SQL] Start up question about triggers

2006-06-23 Thread Forums @ Existanze
fference between the theoretical method and the > ones already suggested is that I will still need "n" trigger > function for each of the "n" > tables, but only ONE auditing table. > > Would it be much nicer :-) > > Once again thank you very much for all your

Re: Fwd: [SQL] Start up question about triggers

2006-06-23 Thread Forums @ Existanze
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, &

Re: Fwd: [SQL] Start up question about triggers

2006-06-23 Thread Forums @ Existanze
Hello again aaron, 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 table

Re: [SQL] Start up question about triggers

2006-06-22 Thread Forums @ Existanze
this may not be achieving your goal.-Aaron Bono On 6/22/06, Forums @ Existanze <[EMAIL PROTECTED]> wrote: Sorry This is the complete message   Hello all,   I know that this question may be really simple, but I have decided to ask here

Re: [SQL] Start up question about triggers

2006-06-22 Thread Forums @ Existanze
Sorry This is the complete message   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 p

[SQL] Start up question about triggers

2006-06-22 Thread Forums @ Existanze
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