Andrew Dunstan wrote: > Bruce Momjian wrote: > > Andrew Dunstan wrote: > > > >> Bruce Momjian wrote: > >> > >>> Keep in mind all contrib loads into public, and I don't remember any > >>> namespace conflict issues in the past. > >>> > >>> > >> That is beside the point. Of course there haven't been conflicts - > >> precisely because a single group controls the whole lot. What I said was > >> that we should behave as sane third party extension authors would, > >> namely to use their own namespace to protect themselves from conflicts > >> with other unknown extensions. It's called setting a good example or > >> eating your own dog food. > >> > > > > The problem I see controlling per-user search_path if +10 extensions are > > instlalled, and you want them always to be available by default. > > > > This suggests maybe we need to look at beefing up a few things. For > example, an alias facility that provided a name in schema X for things > in schema Y would help lots here. (You want everything visible? Just > alias it in public.) ISTR such things in DB2, although it's now many > years since I laid hands on it, so my memory could well be very faulty.
I think that is SYNONYM. > Also, ability to append to the search path rather than just set it could > help, as might ability to add names of non-existent schemas (which would > be ignored at run time when found not to exist). Agreed. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly