On Thu, Mar 29, 2012 at 2:39 PM, Jonathan Bartlett
<jonathan@newmedio.com> wrote:
> Tom -
>
> Your suggestion gives me an idea, and I'd like your opinion since I haven't
> done much with schemas.
>
> (1) Separate the datasets into different schemas
> (2) Use different schema names for different static data releases
> (3) For the *company*, we can use a schema search path that includes the
> next schema
> (4) For the *users*, they can use a schema search path that includes the
> released schema
>
> Then, I wouldn't have to modify any code, except to set the schema search
> path based on who was connecting.
>
> Does this sound reasonable?
It's pretty much what I was going to suggest.