By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,541 Members | 1,427 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,541 IT Pros & Developers. It's quick & easy.

Transactions in different DB

P: n/a
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??

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

Thanks

Stefano Farina
Nov 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Tue, 16 Nov 2004 11:22:27 +0100, Stefano Farina
<sf**************@akhela.com> wrote:

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??
Beginning with PostgreSQL 8.0, yes - this provides tablespaces.
If I want to work with two different databases, it's possible to do a
single transaction on two different databases ??


Not AFAIK, though contrib/dblink might be able to help you.

HTH

Ian Barwick
ba*****@gmail.com

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #2

P: n/a
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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.