Re: dblink for 8.4 should work without user-mappings - Mailing list pgsql-hackers

From Takahiro Itagaki
Subject Re: dblink for 8.4 should work without user-mappings
Date
Msg-id 20100225094933.915C.52131E4D@oss.ntt.co.jp
Whole thread Raw
In response to Re: dblink for 8.4 should work without user-mappings  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Bruce Momjian <bruce@momjian.us> wrote:

> What happened to this patch?

It was rejected because SQL standard always requires an user mapping.
I agree about the decision, too.

> ---------------------------------------------------------------------------
> Itagaki Takahiro wrote:
> > contrib/dblink in 8.4 supports a server name by CREATE SERVER for connection
> > string, but it always requires an user-mapping (by CREATE USER MAPPING).
> > However, I think it should work user-mappings because it works when
> > the connection string is passed directly.
> > 
> > The attached patch adds 'missing_ok' parameter to GetUserMapping() and
> > made dblink to use it. There should be no additional security issues here
> > because dblink's original security check works even for server name mode.

Regards,
---
Takahiro Itagaki
NTT Open Source Software Center




pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: pg_stop_backup does not complete
Next
From: "Joshua D. Drake"
Date:
Subject: Re: pg_stop_backup does not complete