Lance J. Andersen wrote:
John Embretsen wrote:
Also, be aware of default schemas and implicit schema creation, a
common source of confusion. From FAQ 5.3 [1]:
"The current schema for any connection defaults to a schema
corresponding to the user name. If no user name is supplied then the
user name (and hence current schema) defaults to APP.
However even though the current schema is set to the user name, that
schema may not exist. A schema is only created by CREATE SCHEMA or
creating an object (table etc.) in that schema (this is implicit
schema creation)."
This point is key as I know until i did a deep dive based on what i saw
with the Netbeans explorer, i did not really think about the schema
getting created until the object for that user name (when create schema
was not used) occurs.
We should probably open a JIRA to clarify when the schema is created in
more explict detail
Yes, feel free to do so; I couldn't find anywhere in the manuals where the
details of implicit schema creation is explained. I wasn't really aware of these
details either until I noticed a related NetBeans issue:
http://www.netbeans.org/issues/show_bug.cgi?id=106047
--
John
