Re: Views- Advantages and Disadvantages - Mailing list pgsql-general

From Dann Corbit
Subject Re: Views- Advantages and Disadvantages
Date
Msg-id D425483C2C5C9F49B5B7A41F894415470100063F@postal.corporate.connx.com
Whole thread Raw
In response to Re: Views- Advantages and Disadvantages  ("Ashish Karalkar" <ashish.karalkar@info-spectrum.com>)
Responses Re: Views- Advantages and Disadvantages
Re: Views- Advantages and Disadvantages
Re: Views- Advantages and Disadvantages
List pgsql-general
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
> owner@postgresql.org] On Behalf Of Ashish Karalkar
> Sent: Wednesday, May 09, 2007 1:36 AM
> To: Andrej Ricnik-Bay; Ron Johnson
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Views- Advantages and Disadvantages
>
> Thanks All for your replies,
>
> But then dont we have any disadvantage of using View???

Views can hide important information from the optimizer (especially
index information).


pgsql-general by date:

Previous
From: "Lou O'Quin"
Date:
Subject: re Referential Integrity Flash Tutorial
Next
From: "Marcelo de Moraes Serpa"
Date:
Subject: Re: Audit-trail engine: getting the application's layer user_id