From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Shigeru HANADA <hanada(at)metrosystems(dot)co(dot)jp> |
Cc: | Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: SQL/MED - core functionality |
Date: | 2010-12-14 13:15:32 |
Message-ID: | 1292332532.18176.6.camel@vanquo.pezone.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On mån, 2010-12-13 at 14:45 +0900, Shigeru HANADA wrote:
> Simple FDWs such as File FDW might not have concept of "user" on
> remote side. In such case, it would be enough to control access
> privilege per local user with GRANT/REVOKE SELECT statement.
Right. But it depends on the implementation. You could, for example,
imagine a "userdir" FDW that reads from users' home directories.
> To allow omitting column definitions for that purpose, a way to create
> ero-column tables would have to be provided. New syntax which allows
> FDWs to determine column definition would be necessary.
>
> ex)
> -- Create foo from the remote table foo on the server bar
> CREATE FOREIGN TABLE foo SERVER bar;
> -- Create zero-column table foo
> CREATE FOREIGN TABLE foo () SERVER bar;
That syntax seems pretty obvious.
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2010-12-14 14:01:12 | Re: CommitFest wrap-up |
Previous Message | Florian Pflug | 2010-12-14 12:51:14 | Re: CommitFest wrap-up |