Re: [HACKERS] Withdraw PL/Proxy from commitfest

David Fetter wrote: > DBI's DBD::Excel > is a more extreme example of this kind of thing. You can get connect > strings that look like this: > > my $hDb = DBI->connect( > "DBI:Excel:file=dbdtest.xls", > undef, > undef, > {

Re: [HACKERS] Withdraw PL/Proxy from commitfest

On Wed, Oct 22, 2008 at 11:02:34AM +0300, Martin Pihlak wrote: > Hannu Krosing wrote: > >> It is cleverly hidden. The CREATE SERVER and CREATE USER MAPPING take > >> generic options (list of key/value pairs). These can be used for > >> defining the actual connection to the remote server. > > > > A

Re: [HACKERS] Withdraw PL/Proxy from commitfest

Hannu Krosing wrote: >> It is cleverly hidden. The CREATE SERVER and CREATE USER MAPPING take >> generic options (list of key/value pairs). These can be used for >> defining the actual connection to the remote server. > > Are you sure this is how it is intended to be done ? > Yes. > In pl/proxy

Re: [HACKERS] Withdraw PL/Proxy from commitfest

On Tue, 2008-10-21 at 21:05 +0300, Martin Pihlak wrote: > Hannu Krosing wrote: > > > In my brief reading of SQL-MED spec I could only find info on defining > > FOREIGN SERVER and FOREIGN-DATA WRAPPER and nowhere in these could one > > define connection parameters like username and password. > > I

Re: [HACKERS] Withdraw PL/Proxy from commitfest

Hannu Krosing wrote: > In my brief reading of SQL-MED spec I could only find info on defining > FOREIGN SERVER and FOREIGN-DATA WRAPPER and nowhere in these could one > define connection parameters like username and password. It is cleverly hidden. The CREATE SERVER and CREATE USER MAPPING take g

Re: [HACKERS] Withdraw PL/Proxy from commitfest

On Fri, 2008-09-05 at 15:39 +0300, Marko Kreen wrote: > In the previous discussion there was mentioned that Postgres should > move to the SQL-MED direction in remote connection handling. > > SQL-MED specifies that connections should have names and referenced > everywhere using names. Where did yo

Re: [HACKERS] Withdraw PL/Proxy from commitfest

On Fri, 2008-09-05 at 15:39 +0300, Marko Kreen wrote: > There was a attempt to paint the .pgpass based password handling > insecure because dblink makes the file world-readable. I still > fail to see how this any way points to flaws of the scheme... Hot Standby will probably need to conne

Re: [HACKERS] Withdraw PL/Proxy from commitfest

On Fri, 2008-09-05 at 19:37 +0300, Heikki Linnakangas wrote: > So, you'll implement the part of SQL-MED that deals with specifying > remote connections, e.g something like "CREATE CONNECTION" (no, I > haven't looked at what the syntax actually is)? Why have you started top-posting in your repli

Re: [HACKERS] Withdraw PL/Proxy from commitfest

On Fri, Sep 5, 2008 at 7:37 PM, Heikki Linnakangas < [EMAIL PROTECTED]> wrote: > So, you'll implement the part of SQL-MED that deals with specifying remote > connections, e.g something like "CREATE CONNECTION" (no, I haven't looked at > what the syntax actually is)? > > Yeah, that sounds like a go

Re: [HACKERS] Withdraw PL/Proxy from commitfest

So, you'll implement the part of SQL-MED that deals with specifying remote connections, e.g something like "CREATE CONNECTION" (no, I haven't looked at what the syntax actually is)? Yeah, that sounds like a good idea. We should get that into core, and modify contrib/dblink to use it as well. I

[HACKERS] Withdraw PL/Proxy from commitfest

In the previous discussion there was mentioned that Postgres should move to the SQL-MED direction in remote connection handling. SQL-MED specifies that connections should have names and referenced everywhere using names. PL/Proxy currently does not conform to that standard - it uses connection st