On 11/29/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hello friends,
I have a view defined as:-
CREATE VIEW vivek_testview AS SELECT vivek_test.* , users.username AS name from
users, vivek_test where vivek_test.username=users.username;
Now, when I add a new column in vivek_test, I cant see the new column in the
view. Currently we have to drop the view and recreate it.
Is there a way that i can see the new column without dropping and recreating
the view ?
Thanks for reading this. Thanks for your replies in advance.
no, queries using * are expanded when the plan is created. for views,
the plan is created when you create the view (also the original query
string to create the view is not stored). however, you could however
create a function that returns setof record, because plans for
functions are created when they are first run in a session. this
isn't a perfect solution, but it might work for you.
merlin
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
