Re: when does CREATE VIEW not create a view?

From: "Mark Hollomon" <mhh(at)nortelnetworks(dot)com>
To: Brook Milligan <brook(at)biology(dot)nmsu(dot)edu>
Cc: pgsql-hackers(at)hub(dot)org
Subject: Re: when does CREATE VIEW not create a view?
Date: 2000-08-22 19:10:19
Message-ID: 39A2D01B.59CBDE34@americasm01.nt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Brook Milligan wrote:
>
> It seems that the problem is with the word "english" as part of the
> view name. Variants of the name that lack it (e.g., replacing xxx
> above with eng, englih, etc.) seem to work fine, but variants that
> include it (e.g., replacing xxx with english, eenglish, englishh)
> suffer as above.
>
> The problem also seems to occur if xxx is replaced by british,
> imperial, and american. I haven't tried other location names, but
> there seems to be a trend.

This is probably wrong, but could it be the length of the name?

Try replacing 'english' with some other seven letters e.g.
precipitation_abdefgh_verify
--

Mark Hollomon
mhh(at)nortelnetworks(dot)com
ESN 451-9008 (302)454-9008

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ross J. Reedstrom 2000-08-22 19:34:31 Re: Re: [GENERAL] +/- Inf for float8's
Previous Message Jeffrey A. Rhines 2000-08-22 19:06:09 Re: [Solved] SQL Server to PostgreSQL

Browse pgsql-patches by date

  From Date Subject
Next Message Ross J. Reedstrom 2000-08-22 20:16:01 Re: when does CREATE VIEW not create a view?
Previous Message Brook Milligan 2000-08-22 18:55:29 Re: when does CREATE VIEW not create a view?