Re: Transactions in different DB

Поиск
Список
Период
Сортировка
От Tino Wildenhain
Тема Re: Transactions in different DB
Дата
Msg-id 1100697365.8902.11.camel@sabrina.peacock.de
обсуждение исходный текст
Ответ на Transactions in different DB  ("Stefano Farina" <sfarina.stagedse@akhela.com>)
Список pgsql-general
Hi,

Am Dienstag, den 16.11.2004, 11:22 +0100 schrieb Stefano Farina:
> Hi all
> I have to develop an embedded database using memory FLASH and memory
> RAM
> Some tables must be saved in RAM and some tables in FLASH ( RAM and
> FLASH are two different mounted directories in the file system).
> I saw it's possible to save different databases in different
> directories with CREATE DATABASE options.
>
> It's possible to save only some tables in different directories??

With 8.0 its possible. With pre 8.0 it would involve manual work
(linking) and you are restricted when you recreate tables and indices.

> If I want to work with two different databases, it's possible to do  a
> single transaction on two different databases ??

No. You might be able to simulate it with dblink, but generally no.

Regards
Tino


В списке pgsql-general по дате отправления:

Предыдущее
От: "Alejandro D. Burne"
Дата:
Сообщение: Re: Fwd: Problem installing Postgresql on MDK10.0
Следующее
От: Timothy Perrigo
Дата:
Сообщение: error querying temp table in plpgsql function