On Tue, Jul 08, 2008 at 06:22:23PM +0300, Heikki Linnakangas wrote: > Simon Riggs wrote: >> SQL, in text form, is the interface to other databases. You can't >> pass half a plan tree to Oracle, especially not a PostgreSQL plan >> tree. It has to be text if you wish to send a query to another >> RDBMS, or another version of PostgreSQL. > > Oh, I see. Agreed. > > Though note that there's big differences in SQL dialects, so a > one-size-fits-all approach to generating SQL to be executed in the > remote database won't work. (not that I think anyone has suggested > that) > >> So if I understand you, you want to pass the partial plan tree and >> then have a plugin construct the SQL text. > > Exactly. > >> Maybe you thought I meant internal interfaces should be in text? > > Yeah, that's exactly what I thought you meant. > >> No, that would be bizarre. I meant we should not attempt to pass >> partial plan trees outside of the database, since that would limit >> the feature to only working with the same version of PostgreSQL >> database. > > Agreed. I'm glad we're on the same page now.
Everybody's weighed in on this thread except the guy who's actually doing the work. Jan? Cheers, David. -- David Fetter <[EMAIL PROTECTED]> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: [EMAIL PROTECTED] Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers