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@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