Re: feature request

I have read that 8.5 will have replication, so is just a feature request.

regards
Omar Bettin

----- Original Message -----
From: "Robert Haas" <robertmhaas(at)gmail(dot)com>
To: "Omar Bettin" <o(dot)bettin(at)informaticaindustriale(dot)it>
Cc: <pgsql-hackers(at)postgresql(dot)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(dot)bettin(at)informaticaindustriale(dot)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