Postgres Pro
Downloads
Home   >   mailing lists

Re: schema, view and role - Mailing list pgsql-general

From Gurjeet Singh
Subject Re: schema, view and role
Date
Msg-id 65937bea0903180919h56415490n3b4319c8374d3ede@mail.gmail.com
Whole thread Raw
In response to schema, view and role  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List pgsql-general
Tree view
On Wed, Mar 18, 2009 at 2:40 PM, Ivan Sergio Borgonovo <mail@webthatworks.it> wrote:
If the view is just an alias for the SQL as "text" and it is not
interpreted at creation time...

This assumption is wrong. A view is "compiled" at creation time, and the compiled version of the view is used in queries.

--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB      http://www.enterprisedb.com

Mail sent from my BlackLaptop device

pgsql-general by date:

Previous
From: Kynn Jones
Date:
Subject: DBD::Pg's $dbh->func( "/path/to/file", 'lo_import' ) fails silently
Next
From: Ron Mayer
Date:
Subject: Re: Maximum transaction rate