[Info-ingres] Column added to base table not in view

This is a discussion on [Info-ingres] Column added to base table not in view within the Ingres Database forums in Other Databases category; Why running the following script gives an error message E_US0836 line 1, Column 'c' not found in any specified table. ? --------------------------------- create table tmp00 (a i1, b i1); create view tmp00_vw as select * from tmp00; alter table tmp00 add column c i1; select c from tmp00_vw; rollback; \g...

Go Back   Database Forum > Other Databases > Ingres Database

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 08-02-2005, 06:23 AM
Default [Info-ingres] Column added to base table not in view

Why running the following script gives an error message
E_US0836 line 1, Column 'c' not found in any specified table.
?

---------------------------------
create table tmp00 (a i1, b i1);
create view tmp00_vw as select * from tmp00;

alter table tmp00 add column c i1;
select c from tmp00_vw;
rollback;
\g


Reply With Quote
  #2  
Old 08-03-2005, 09:52 AM
Default Re: Column added to base table not in view

This is why we do not use SELECT * in production code. It may or may
not be re-executed, depending wher it appears. You now know that a
VIEW is defined once with expanded column names.

Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 10:12 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Integrated by bbpixel2009 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.