Menu
▾
▴
#14 Schema support
Add a concept of SCHEMA. Unique identifier of a relvar (both base and virtual) becomes SCHEMANAME+RELVARNAME (so same relvar name can appear in >1 schema, each identifies a different relvar). Language grammar extended to allow relvar references to consist of <schemaname>.<relvarname> with the <schemaname>. part optional. Connection machinery extended to include mention of a default schema, which will be used to resolve "blank" relvar references, ie.e. that do not include the schema portion. The search will be done ONLY in the default schema, so no resolution even if the "blank" relvar name happens to be unique across schemas. For backward compatibility however, a wildcard value "any schema" MUST be supported in the connection machinery which will effectively trigger such "search across all schemas" resolution.</schemaname></relvarname></schemaname>
