Re: Schema's versus tablespace

OK, that's cleared, thanks,

Now another question related to this. In 7.4.8 I have a schema with the
following authorization:

CREATE SCHEMA adeuxproductie
  AUTHORIZATION postgres;
GRANT ALL ON SCHEMA adeuxproductie TO postgres;
GRANT ALL ON SCHEMA adeuxproductie TO GROUP adeuxproductie;
COMMENT ON SCHEMA adeuxproductie IS 'Standard production schema';

Now when I try to access the tables/views in the schema as a user that is NOT
a member of the group adeuxproductie, I expect it to fail. However, access is
granted as if there is no authorization specified.

Is this a bug, or do I misunderstand something?

Cheers,
Dick

On Tuesday 28 March 2006 09:48, Martijn van Oosterhout wrote:
> On Tue, Mar 28, 2006 at 09:41:46AM +0200, Dick Kniep wrote:
> > Hi list,
> >
> > We have developed a system that is running as an ASP application,
> > currently we are using Postgresql 7.4. For every customer we have a
> > separate schema, and this works OK. Now in version 8, tablespaces were
> > introduced. This summer we are planning to migrate to version 8.1.
> > Question is if there are advantages to use tablespaces instead of
> > schema's?
>
> Schemas related to how your tables are logically divided up.
> Tablespaces are about where the tables are actually stored on disk. As
> such they have nothing to do with eachother. You can mix and match as
> you please.
>
> Have a nice day,