RE: Big 7.1 open items - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject RE: Big 7.1 open items
Date
Msg-id 000001bfdca2$82fd1520$2801007e@tpf.co.jp
Whole thread Raw
In response to Re: Big 7.1 open items  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
> -----Original Message-----
> From: Peter Eisentraut
>
> Tom Lane writes:
>
> > In my mind the point of the "database" concept is to provide a domain
> > within which custom datatypes and functions are available.
>

AFAIK few users understand it and many users have wondered
why we couldn't issue cross "database" queries.

> Quoth SQL99:
>
> "A user-defined type is a schema object"
>
> "An SQL-invoked routine is an element of an SQL-schema"
>
> I have yet to see anything in SQL that's a per-catalog object. Some things
> are global, like users, but everything else is per-schema.
>

So why is system catalog needed per "database" ?

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: NOTICES about portals
Next
From: Chris Bitmead
Date:
Subject: Re: Big 7.1 open items