VIEWS - Mailing list pgsql-bugs

From Markus Feier
Subject VIEWS
Date
Msg-id NCBBKMKJPKLKIHOKLPADGENEEGAA.mfeier@prologon.ch
Whole thread Raw
Responses Re: VIEWS  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-bugs
Dear Sirs

I encountered a minor Postgres problem using VIEW:

Creating a View like
CREATE VIEW SELECT * FROM table1
works perfecly

As soon as we enlarge table1 by new Attributes, they will not show up in the
VIEV
The VIEW will need to be deleted and recreated.

This behaviuor may not be considered to be a Bug but it is annoying and it
conflicts with the
assumption, that a VIEW does not execute any operation on a Database.

Thanks for listening to my input.

Prologon AG
M. Feier
mfeier@prologon.ch

pgsql-bugs by date:

Previous
From: "Monte Hansen"
Date:
Subject: Failed install postgresql-8.0-beta2-dev3.msi
Next
From: Sean Chittenden
Date:
Subject: CREATE DATABASE OWNER not propagating to child objects?