On Tue, 2003-04-15 at 18:43, Rob Butler wrote:
> Hello all,
>
> New to the Hackers list, but long time lurker on the archives. Also a member of the Postgres-r list. Just thought I
wouldjoin in now to give my opinions on this thread.
>
> > One of the features that PostgreSql must have, IMHO, is support for
> > cross-db operations (queries, updates, deletes, inserts). 2PC and
> > cross-server stuff would be nice but it's not as important as simple
> > cross -db operations across databases on the same server. All major
> > comercial RDBMS (and even mySql!) support this but for Postgres. Sad.
>
> I disagree, The cross-db operations would indeed be very nice to
> have, but you COULD make things work across DB's from within your
> application code if Postgres supported 2PC. Granted this would not be
> the best, but it could be done.
In any case, we effectively have the equivalent of MySQL's
cross-database access in schemas, which MySQL does not have. So rather
than treating it as a problem we should just advertise it as a
terminological difference.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
======================================== "And they questioned Him, saying "...Is it lawful for us to pay taxes
toCaesar, or not? ...And He said to them "...render to Caesar the things that are Caesar's, and to God the
thingsthat are God's." Luke 20:21,22,25