Re: RFD: schemas and different kinds of Postgres objects
От | Peter Eisentraut |
---|---|
Тема | Re: RFD: schemas and different kinds of Postgres objects |
Дата | |
Msg-id | Pine.LNX.4.30.0201221816130.686-100000@peter.localdomain обсуждение исходный текст |
Ответ на | Re: RFD: schemas and different kinds of Postgres objects (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: RFD: schemas and different kinds of Postgres objects
|
Список | pgsql-hackers |
Tom Lane writes: > I don't buy that premise. It's true that SQL92 equates ownership of a > schema with ownership of the objects therein, but AFAICS we have no hope > of being forward-compatible with existing database setups (wherein there > can be multiple tables of different ownership all in a single namespace) > if we don't allow varying ownership within a schema. We could have a Boolean knob that says "if you don't find the object in the default schema, search all other schemas". That should provide all the backward compatibility we need. Moreover, I figure if we do it that way, the whole schema implementation reduces itself mostly to parser work, no complicated system catalog changes, no complex overhaul of the privilege system -- at least initially. -- Peter Eisentraut peter_e@gmx.net
В списке pgsql-hackers по дате отправления: