Skip site navigation (1) Skip section navigation (2)

Re: SQL/MED compatible connection manager

From: Martin Pihlak <martin(dot)pihlak(at)gmail(dot)com>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: Martin Pihlak <martin(dot)pihlak(at)gmail(dot)com>, "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
Subject: Re: SQL/MED compatible connection manager
Date: 2008-10-30 08:41:28
Message-ID: 49097338.2070700@gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
> I have put together a draft that describes a possible implementation:
> http://wiki.postgresql.org/wiki/SqlMedConnectionManager
> 

I'll update this with an experimental patch. This implements:
* System catalogs for FDW, SERVER and USER MAPPING
* regserver data type for servers (convert from text to oid etc).
* FDW placeholders as shared libraries -- currently provides dummy
  and pgsql wrappers.
* Connection lookup via FDW.
* SQL interface to the lookup function.

There is an example of how all this works at:
http://wiki.postgresql.org/wiki/SqlMedConnectionManager#Current_implementation

I was hoping to get the internal features done by the start of November
Commitfest. But right now this seems unlikely. Nevertheless, I'm all ears
for suggestions and criticism.

PS. Jonah, does this somehow coincide with your approach to FDW-s?

regards,
Martin


Attachment: connection-manager.patch.gz
Description: application/x-gzip (9.4 KB)

In response to

Responses

pgsql-hackers by date

Next:From: Hans-Jürgen SchönigDate: 2008-10-30 09:47:30
Subject: Re: Multi CPU Queries - Feedback and/or suggestions wanted!
Previous:From: Heikki LinnakangasDate: 2008-10-30 08:40:05
Subject: Re: Updating FSM on recovery

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group