Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postgres development

Postgres development

From
"Brent Wood"
Date:
Hi all,

I'm interested in finding what would be involved on enhancing Postgres to allow queries run in one database in a
clusterto access & join with tables in other databases in the cluster, ie: cross database join support. 

This would be very useful, & depending on cost, I may be able to arrange for funds to cover this development.

Thanks,

  Brent Wood

Re: Postgres development

From
"Joshua D. Drake"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, 20 Mar 2008 16:51:57 +1300
"Brent Wood" <b.wood@niwa.co.nz> wrote:

> Hi all,
> 
> I'm interested in finding what would be involved on enhancing
> Postgres to allow queries run in one database in a cluster to access
> & join with tables in other databases in the cluster, ie: cross
> database join support.

pl/proxy?

> 
> This would be very useful, & depending on cost, I may be able to
> arrange for funds to cover this development.
> 
> Thanks,
> 
>   Brent Wood
> 


- -- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFH4eYiATb/zqfZUUQRAmG+AJ9jP7sSyMPZf83Rxl1b+mM6Vkr78QCgkdmC
MJwfvz1oWX+t2SAEfbg78Dc=
=zf2R
-----END PGP SIGNATURE-----

Re: Postgres development

From
Shane Ambler
Date:
Brent Wood wrote:
> Hi all,
>
> I'm interested in finding what would be involved on enhancing
> Postgres to allow queries run in one database in a cluster to access
> & join with tables in other databases in the cluster, ie: cross
> database join support.
>
> This would be very useful, & depending on cost, I may be able to
> arrange for funds to cover this development.
>
> Thanks,
>
> Brent Wood
>
A quick search for link at pgfoundry finds a few projects along these lines

http://pgfoundry.org/search/?type_of_search=soft&words=link&Search=Search

one or more of these could be worth having your assistance, or could be
a starting point for what you want to implement.


Is this something you want to get into the core or postgresql or would
you be ok with it being an external (or maybe contrib) addition? Are you
planning strictly pg to pg connections or the flexibility of any db for
the external target?


Being a part of SQL:2003 (SQL/MED) this could be something to be added
into the main postgresql code in a future version. And sticking to these
specs would help towards getting it included.

(There was talk about adding SQL/MED a few years ago but I don't know
what has been done on it)


--

Shane Ambler
pgSQL (at) Sheeky (dot) Biz

Get Sheeky @ http://Sheeky.Biz

Re: Postgres development

From
Robert Treat
Date:
On Wednesday 19 March 2008 23:51, Brent Wood wrote:
> Hi all,
>
> I'm interested in finding what would be involved on enhancing Postgres to
> allow queries run in one database in a cluster to access & join with tables
> in other databases in the cluster, ie: cross database join support.
>
> This would be very useful, & depending on cost, I may be able to arrange
> for funds to cover this development.
>

I'd suggest tracking down Neil Conway, and maybe David Fetter.  I know Neil
has been playing with something similar for 8.4, and David has been pestering
him about it pretty steady.

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL