I have read that 8.5 will have replication, so is just a feature request.
regards
Omar Bettin
----- Original Message -----
From: "Robert Haas" <robertmhaas@gmail.com>
To: "Omar Bettin" <o.bettin@informaticaindustriale.it>
Cc: <pgsql-hackers@postgresql.org>
Sent: Thursday, February 25, 2010 11:22 PM
Subject: Re: [HACKERS] feature request
> On Thu, Feb 25, 2010 at 5:17 PM, Omar Bettin
> <o.bettin@informaticaindustriale.it> wrote:
>> ...could be
>> STORE WHERE [condition] FROM [table] INTO [database]
>
> That still doesn't work, because a PostgreSQL backend doesn't have any
> obvious way to access another database. You'd need to use dblink or
> something. Eventually (but not any time soon) it will probably be
> possible to do things like this, which would work for moving data
> between tables in the same database:
>
> WITH x AS (DELETE FROM ... RETURNING ...) INSERT INTO ... (...) SELECT
> ... FROM x
>
> Doing anything with some OTHER database is going to require a lot more
> infrastructure.
>
> ...Robert
