Christopher Kings-Lynne wrote: > > > I really don't buy this argument; it seems exactly comparable to > > arguing that the notion of current directory in Unix is evil, and > > that users should be forced to specify absolute paths to every > > file that they reference. > > You know, I'm kinda surprised that the spec doesn't define a CURRENT_SCHEMA > variable you can query??? >
Maybe because it would be the same as CURRENT_USER. For the standard, the schema name used (implied) to qualify objects outside a CREATE SCHEMA statement is a schema name with the SQL-session user id. Except for functions and UDTs where each schema has a SQL-path for searching those (the implied schema must always be in it though). There must be an implementation-defined default for this SQL-path (but the implied schema must also be in it). -- Fernando Nasser Red Hat Canada Ltd. E-Mail: [EMAIL PROTECTED] 2323 Yonge Street, Suite #300 Toronto, Ontario M4P 2C9 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
