AW: New SQL Datatype RECURRINGCHAR - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: New SQL Datatype RECURRINGCHAR
Date
Msg-id 11C1E6749A55D411A9670001FA68796336836D@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
List pgsql-hackers
 
> My feeling is that the restrictions are stringent enough to eliminate
> most of the interesting uses of views, and hence an automatic rule
> creation feature is not nearly as useful/important as it appears at
> first glance.

The most prominent of the "interesting uses" probably beeing when the views
are part of the authorization system, since views are the only standardized
mechanism to restrict access at the row level. Imho not to be neglected.
(user xxx is only allowed to manipulate rows that belong to his department,
so he is only granted access to a view, not the main table)

Andreas


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: ADD CONSTRAINT behaviour question
Next
From: Mathijs Brands
Date:
Subject: Re: Solaris source code