9.2: Describing a security barrier view in psql

From: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: 9.2: Describing a security barrier view in psql
Date: 2012-09-03 09:17:26
Message-ID: CAEZATCWBaTd9ndKKUw96+T0DqfftF+zFhSpkK3T9YGvyVcCMAQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

Unless I'm missing something, it is not possible in psql to tell
whether a view has the security_barrier option. I think that this is
something that ought to be possible from psql, otherwise the new
feature is not visible.

This patch displays any reloptions for a view at the end, if \d+ is
used, in the same way as for tables.

Sorry if this is too late for 9.2. I really only just noticed this,
despite playing with security barrier views for a while.

Regards,
Dean

Attachment Content-Type Size
describe-view-options.patch application/octet-stream 705 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2012-09-03 10:14:58 Re: Is this non-volatile pointer access OK?
Previous Message Sergey Konoplev 2012-09-03 09:07:32 Re: [GENERAL] Multiple Slave Failover with PITR