Re: RFD: schemas and different kinds of Postgres objects

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: RFD: schemas and different kinds of Postgres objects
Date: 2002-01-23 01:52:14
Message-ID: Pine.LNX.4.30.0201222042400.686-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane writes:

> I really don't see what's wrong with building a namespace mechanism
> that is orthogonal to ownership and then using that to implement what
> SQL92 wants. I think this will be cleaner, simpler, and more flexible
> than trying to equate ownership with namespace.

OK, I can accept that. But then I want to get back at my original point,
namely that all database objects (except users and groups) should be in
schemas. This is also cleaner, simpler, and more flexible. There is
clearly demand for schema-local functions. So I think that designing this
system from the premise that a schema-qualified operator call will look
strange is the wrong end to start at.

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-01-23 02:30:15 Re: TODO item question
Previous Message Mike Mascari 2002-01-23 01:15:29 Re: RFD: schemas and different kinds of Postgres objects