Postgres Pro
Downloads
Home   >   mailing lists

Re: information_schema.columns.column_default filtered based on user - Mailing list pgsql-general

From Tom Lane
Subject Re: information_schema.columns.column_default filtered based on user
Date
Msg-id 5159.1139101291@sss.pgh.pa.us
Whole thread Raw
In response to information_schema.columns.column_default filtered based on user  ("George Pavlov" <gpavlov@mynewplace.com>)
List pgsql-general
Tree view 
"George Pavlov" <gpavlov@mynewplace.com> writes:
> Looking at the information_schema.columns view I have been wondering why
> it only shows the column_default for columns in tables owned by the
> current user?

Because that's what the SQL99 spec says it should do.

The SQL2003 spec seems to have a looser definition, but we haven't
gotten around to trying to make information_schema follow SQL2003
instead of SQL99 ...

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error with temporary tables
Next
From: "James Harper"
Date:
Subject: plpgsql direct from C?