Greg Stark <[EMAIL PROTECTED]> writes:
> Uhm, doesn't the spec have anything to say about this?
> I mean, the view sure looks like standard SQL on its face.
Well, you might read the spec as requiring the view column to have
datatype CHAR(n) where n is the length of the unknown literal.
I see in S
On Fri, 2003-10-03 at 00:50, Greg Stark wrote:
>
> Tom Lane <[EMAIL PROTECTED]> writes:
>
> > >> I'd almost argue that we should change this message to an error
> >
> > > I agree.
> >
> > Motion proposed and seconded; any objections out there?
>
> Uhm, doesn't the spec have anything to say abo
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
>>> I'd almost argue that we should change this message to an error
>>
>> I agree.
> Except that it would totally break backwards-compatibility?
Well, that's a possible problem. How many such views do you think are
out there, given the existen
Tom Lane <[EMAIL PROTECTED]> writes:
> >> I'd almost argue that we should change this message to an error
>
> > I agree.
>
> Motion proposed and seconded; any objections out there?
Uhm, doesn't the spec have anything to say about this?
I mean, the view sure looks like standard SQL on its face
nconway=# create view baz (a,b) as select 'hello', 'world';
WARNING: column "a" has type "unknown"
DETAIL: Proceeding with relation creation anyway.
It's always done that, although the spelling of the notice has
varied over the years.
I'd almost argue that we should change this message to an er
Neil Conway <[EMAIL PROTECTED]> writes:
> On Thu, 2003-10-02 at 10:16, Tom Lane wrote:
>> Neil Conway <[EMAIL PROTECTED]> writes:
>>> nconway=# create view baz (a,b) as select 'hello', 'world';
>>> WARNING: column "a" has type "unknown"
>>> DETAIL: Proceeding with relation creation anyway.
>> I'
On Thu, 2003-10-02 at 10:16, Tom Lane wrote:
> Neil Conway <[EMAIL PROTECTED]> writes:
> > nconway=# create view baz (a,b) as select 'hello', 'world';
> > WARNING: column "a" has type "unknown"
> > DETAIL: Proceeding with relation creation anyway.
>
> It's always done that, although the spelling
Neil Conway <[EMAIL PROTECTED]> writes:
> Is this a bug?
> nconway=# create view baz (a,b) as select 'hello', 'world';
> WARNING: column "a" has type "unknown"
> DETAIL: Proceeding with relation creation anyway.
It's always done that, although the spelling of the notice has
varied over the year
On Thu, 2003-10-02 at 08:40, Greg Stark wrote:
> Neil Conway <[EMAIL PROTECTED]> writes:
>
> > Is this a bug?
> >
> > (using CVS code from yesterday)
> >
> > nconway=# create view baz (a,b) as select 'hello', 'world';
> > WARNING: column "a" has type "unknown"
> > DETAIL: Proceeding with relat
Neil Conway <[EMAIL PROTECTED]> writes:
> Is this a bug?
>
> (using CVS code from yesterday)
>
> nconway=# create view baz (a,b) as select 'hello', 'world';
> WARNING: column "a" has type "unknown"
> DETAIL: Proceeding with relation creation anyway.
> WARNING: column "b" has type "unknown"
>
10 matches
Mail list logo
