Re: pgsql-interfaces-digest V1 #570

At 10:12 PM 12/2/99 -0500, you wrote:
>Date: Thu, 02 Dec 1999 12:59:31 -0500
>From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>Subject: Re: [INTERFACES] Data Migration
>
>"Ross J. Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu> writes:
> > This notation, db.table.field, does seem to be how other DBMSs do
> > it. I've been wondering, however, if our parser would have any trouble
> > with it, since in an identifier string token1.token2, token1 is no longer
> > guaranteed to be a table.
>
>The parser would indeed get confused, since multiple dots is an old and
>still-supported PostQUEL notation for some sort of function invocation
>(can't say that I fully understand it). I suppose we could rip that out
>without drawing too many complaints. However, parser problems would be
>the least of the worries in supporting multiple-database access within a
>single backend. We're talking about a major project here, and I'm not
>seeing value in it proportional to the work required. If you don't want
>to have multiple backend connections open in a client, why not refactor
>your database layout so that all the stuff you need is in one database?

It's been a while since I've done it, but IIRC Informix syntax is
table(dot)column(at)database, where database is basically an entry in a file
listing host, server & protocol, all of which you could specify one way or
another (I use Java/JDBC these days).

As for why more than one database, the answer to that is - some of us run
very large databases and are seriously looking at parallelising them in
segments across multiple different machines on the network. Currently, I
don't need back end support for this stuff - I'm using RMI instead and can
run queries on any JDBC compliant database on any machine I can see, in
their own thread. But I can see the uses for it in the engine; for example
I can't yet do a join across the databases directly in SQL. I used to be
able to do this (in theory) in Informix.

Peter Wiley