Hello all,
First the explanation:
I have to databases, some_production and some_archive, those two databases
have an identical layout.
Now we need to implement that all insert and update queries should be replicated
to the some_archive database. Well, the question is how to do that?
I thought
On 10/09/2012 09:55 AM, Matthijs Möhlmann wrote:
Now we need to implement that all insert and update queries should be
replicated to the some_archive database. Well, the question is how to
do that?
Whatever you do, please don't roll your own. This is a solved problem.
If you plan on doing
Depending on what client side library you are using you could use the
RETURNING clause, see the docs:
http://www.postgresql.org/docs/8.2/static/sql-insert.html
Regards,
Ben
Jamie Deppeler [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi,
Have a quick question is possible to
Hi,
Have a quick question is possible to record a primary from a insert stament
eg
xprimary := insert into schema.table(.,.,.,.) VALUES ();
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Please say that again in English?
On 3/5/07, Jamie Deppeler [EMAIL PROTECTED] wrote:
Hi,
Have a quick question is possible to record a primary from a insert stament
eg
xprimary := insert into schema.table(.,.,.,.) VALUES ();
---(end of