Thanks a lot for your suggestion. It will help me in taking the decision.
-Original Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 25, 2007 6:10 PM
To: Jyoti Seth
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Database synchronization
Jyoti Seth wrote:
> M
chester c young wrote:
http://www.postgresql.org/docs/8.2/interactive/plpgsql.html
I found the doc to be quite good.
I'd start there, and then, if you have problems, email again.
I'd read that before... but another re-read triggered a thought pattern
and I've got it working now - it's also
--- Paul Lambert <[EMAIL PROTECTED]> wrote:
> I have some triggers in an MS SQL server database which I need to
> copy
> across to a PG database. I've not yet done triggers in PG so I was
> hoping to get a little bit of a pointer on the first one as a place
> to
> start and work my way through
I have some triggers in an MS SQL server database which I need to copy
across to a PG database. I've not yet done triggers in PG so I was
hoping to get a little bit of a pointer on the first one as a place to
start and work my way through from there.
The trigger looks like thus:
CREATE TRIGGE
Jyoti Seth wrote:
My master database contains prices of some products that vary after few
hours and many other details that are also reqd in Db2 which doesn't change
that frequently. My slave database contains the details of queries sent by
the customers.
These queries are to find the price of th
My master database contains prices of some products that vary after few
hours and many other details that are also reqd in Db2 which doesn't change
that frequently. My slave database contains the details of queries sent by
the customers.
These queries are to find the price of the product and other
Try not to start a new thread (question) by replying to an old one - it
can mean some people don't see your question.
Jyoti Seth wrote:
Hi,
I have two postgres databases "Db1" and "Db2" on different linux servers.
"DB1" is my master server and its data updates very frequently.
My application
Hi,
I have two postgres databases "Db1" and "Db2" on different linux servers.
"DB1" is my master server and its data updates very frequently.
My application access DB2 database, which in turn requires data from Db1
database.
The same can be achieved in either of the following ways:
1. I can hav
