Tony Marston wrote: > I have searched through the SQL 2003 standard and can find no such > restriction. In the volume titled "Information and Definition Schemas > (SQL/Schemata)" in section 5.20 (INORMATON_SCHEMA.COLUMNS view) it > states the following under the heading "Function": > > "Identify the columns of tables defined in this catalog that are > accessible to a given user or role."
The information schema currently follows SQL 1999. Interestingly, the requirement to "blank out" the column defaults of non-owned tables was apparently dropped in SQL 2003. Clearly, we need to review the information schema for SQL 2003 conformance. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
