Brook,
This smells like a identifier length limit problem to me. Let's see:
precipitation_english_verify is 29 characters, default NAMEDATALEN is
32. Creating a view creates a table, and attaches a SELCT DO INSTEAD
rule to it, named _RET<tablename>, so that tacks 4 characters on, giving
us 29+4 = 33, bingo, rule doesn't get made. All your other attemps were
longer, except for xxx. You'll find that replacing english with xxxxxxx
won't work, either (and it's not the vchip).
Sounds like a missing error check, or truncation, in the CREATE VIEW
rule generation code.
Ross
On Tue, Aug 22, 2000 at 12:40:21PM -0600, Brook Milligan wrote:
> I am trying to create a view and have run across a, to me, bizarre
> occurance. One CREATE VIEW statement creates the view fine; changing
> the name of the view and repeating the same statement does not. This
> has nothing to do with conflicting names as appropriate DROP commands
> are issued first.
>
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005