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 would join 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.

Also, if you want to start doing cross-db operations you will need 2PC to support this.  While 2PC may not be needed to support cross-db operations on two db's on the same server, it would definetly be needed to do cross-db operations with db's on two separate servers.  Why limit the cross-db operations only to db's on the same server?

Later
Rob


Tue, 15 Apr 2003 13:43:58 -0400
Rob Butler <robert.butler5@verizon.net>
Re: Are we losing momentum?
--- Rob Butler <robert.butler5@verizon.net> wrote:
> 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.

Sure, anything could be done given time and money. OTOH, why would one
want to hand-code joins between tables in different dbs, configure
multiple connection pools, etc when all that can be avoided with a
RDBMS that supports cross-db operations? And since mySql supports
cross-db ops now, mySql could become a very intersting option when they
implement all the features they promissed for version 5.0

> Also, if you want to start doing cross-db operations you will need
> 2PC to support this.  While 2PC may not be needed to support cross-db
> operations on two db's on the same server, it would definetly be
> needed to do cross-db operations with db's on two separate servers.
> Why limit the cross-db operations only to db's on the same server?

I'm not saying Postgres has to limit itself to cross-db ops on the same
server only. However, if it's much simpler to implement then why not
start there? Cross-db ops have been on the Postgres TODO list for
several years now and, AFAICT, it does not appear that they will be
available any time soon. Thanks





__________________________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo
http://search.yahoo.com


Tue, 15 Apr 2003 12:11:47 -0700 (PDT)
ow <oneway_111@yahoo.com>
Re: Are we losing momentum?
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 would join 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 to Caesar, or not? ...And He said to 
      them "...render to Caesar the things that are  
      Caesar's, and to God the things that are God's."      
                      Luke 20:21,22,25 


15 Apr 2003 20:20:22 +0100
Oliver Elphick <olly@lfix.co.uk>
Re: Are we losing momentum?