Re: Operators and schemas
От | Peter Eisentraut |
---|---|
Тема | Re: Operators and schemas |
Дата | |
Msg-id | Pine.LNX.4.30.0204152154190.834-100000@peter.localdomain обсуждение исходный текст |
Ответ на | Re: Operators and schemas (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Operators and schemas
|
Список | pgsql-hackers |
Tom Lane writes: > What I'm now envisioning is that pg_dump will explicitly set > set search_path = 'foo'; > when dumping or reloading schema foo. 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. Obviously, this command style would be mostly equivalent to temporarily setting the search path. We'd also need alter schema, which SQL doesn't have. > 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) -- Peter Eisentraut peter_e@gmx.net
В списке pgsql-hackers по дате отправления: