Skip site navigation (1) Skip section navigation (2)

VIEWS

From: "Markus Feier" <mfeier(at)prologon(dot)ch>
To: "Postgres Bugs" <pgsql-bugs(at)postgresql(dot)org>
Subject: VIEWS
Date: 2004-09-22 09:01:50
Message-ID: NCBBKMKJPKLKIHOKLPADGENEEGAA.mfeier@prologon.ch (view raw or flat)
Thread:
Lists: 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(at)prologon(dot)ch



Responses

  • Re: VIEWS at 2004-09-24 14:27:49 from Stephan Szabo

pgsql-bugs by date

Next:From: PostgreSQL Bugs ListDate: 2004-09-22 14:31:13
Subject: BUG #1265: sorting by (ORDER BY) result of an operation for names assigned by AS does not work
Previous:From: Jed Nicolau FilhoDate: 2004-09-22 01:00:54
Subject: Strange behavior

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group