[GENERAL] Identify primary key in simple/updatable view

Now that PostgreSQL has updatable views, users (of LibreOffice / native PostgreSQL drivers) want to use them... LibreOffice needs a primary key to "locate" updates (that is, construct the WHERE clause of an UPDATE or DELETE). How can the driver automatically identify the view columns that correspo

Re: [GENERAL] Does the current user have UPDATE privilege on FOO?

On Mon, Feb 27, 2012 at 12:11:23PM -0600, Mike Blackwell wrote: > On Mon, Feb 27, 2012 at 11:00, Lionel Elie Mamane wrote: >> I'm trying to understand the "clean" way to determine whether the >> current role has UPDATE (or SELECT or DELETE or UPDATE) privileges on

[GENERAL] Does the current user have UPDATE privilege on FOO?

Hi, I'm trying to understand the "clean" way to determine whether the current role has UPDATE (or SELECT or DELETE or UPDATE) privileges on a specific table (or column). If I can do it in a way that is portable across different DBMSs, even better :) I went through several iterations, 'CUR_USER' b