Re: dblink for 8.4 should work without user-mappings

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