Re: Questions and experiences writing a Foreign Data Wrapper - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Questions and experiences writing a Foreign Data Wrapper
Date
Msg-id 2426.1311432156@sss.pgh.pa.us
Whole thread Raw
In response to Re: Questions and experiences writing a Foreign Data Wrapper  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: Questions and experiences writing a Foreign Data Wrapper
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> What does the standard say?

Well, there is not a statement in so many words that you have to have a
relevant USER MAPPING to use a foreign table.  But the spec does specify
that an FDW's ConnectServer function takes a UserHandle as one input
parameter and should throw an exception if that handle isn't valid.
And as far as I can tell a UserHandle can only be created from a
relevant USER MAPPING entry.  So I think the behavior I'm arguing for
would emerge from an FDW that was built using the spec-defined API.
We only have an opportunity to argue about it because we chose to
invent our own FDW API.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Problem with pg_upgrade's directory write check on Windows
Next
From: Andrew Dunstan
Date:
Subject: Re: Questions and experiences writing a Foreign Data Wrapper