[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

[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'

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 lio...@mamane.lu 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 a specific table