From the mail archives:
==============================================================================
Stephan Szabo On Tue, 22 May 2001, snpe wrote:
> Hello, I know that queries across multiple databases are in TODO list Does
it mean that
> databases can be on multiple servers (postmasters) and that
update,insert,delete across
> multiple databases are possible.
All the multiple database stuff is in the exotic features section, it's not here
now, and
probably won't be for a while unless someone steps up to do it.
TIP 4: Don't 'kill -9' the postmaster
==============================================================================
If this is still true, it's an area that could really use some improvement. SQL
Server and even
MySQL support this now, such that tables can be referenced as "mydb.mytable",
and columns can therefore
be referenced as "mydb.mytable.mycolumn". I wouldn't be surprised to see
performance take a hit in these kinds of queries though.
Dado Feigenblatt <dado%wildbrain.com@interlock.lexmark.com> on 08/10/2001
01:02:50 PM
To: pgsql-general%postgresql.org@interlock.lexmark.com
cc: (bcc: Wesley Sheldahl/Lex/Lexmark)
Subject: [GENERAL] Re: Returned mail: Service unavailable
Steve SAUTETNER wrote:
> Hello !
>
> I've got 2 databases. In the first i've got users described in a table
> (name, adress ..).
> In the second, i've got a table with products informations (id, price,
> owner
> ...).
> I must create a trigger in the second table on insert that verify that
> the
> product's owner exists in the first database.
>
> Anyone has an idea on how to do it ?
> (i can't merge the two databases)
>
> have a nice day !
>
Not very experienced on triggers mysefl, but if you're talking about two
tables in the same database,
that can be done and you'd be better off taking advice on how to
implement that from somebody other than me :)
But if you're *really* saying you have 2 *distinct* databases, then
you're out of luck :(.
Triggers can work across tables on the same DB, but not across DBs.
Am I wrong on this one?
--
Dado Feigenblatt Wild Brain, Inc.
Technical Director (415) 216-2053
dado@wildbrain.com San Francisco, CA.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
