Re: Operators and schemas

Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> I had imagined that pg_dump would emit commands such as this:

> CREATE SCHEMA foo
> CREATE TABLE bar ( ... )
> CREATE otherthings
> ;

> which is how I read the SQL standard. Are there plans to implement the
> CREATE SCHEMA command that way? I think I recall someone from Toronto
> mentioning something along these lines.

We have portions of that now, but I don't think there is any serious
intent to support *all* Postgres CREATE statements inside CREATE SCHEMA.
Because there are no semicolons in there, allowing random statements in
CREATE SCHEMA tends to force promotion of keywords to full-reserved
status (so you can tell where each sub-statement starts). My
inclination is to allow the minimum necessary for SQL spec compliance.

(Fernando, your thoughts here?)

>> Given the present semantics of
>> search_path, that will imply an implicit search of pg_catalog before
>> foo.

> Interesting ... Is that only temporary? (since you say "present"
> semantics)

Only meant to imply "it hasn't been seriously reviewed, so someone
might have a better idea". At the moment I'm happy with it.

regards, tom lane