Peter Eisentraut <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org