Re: insert statements

From: "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at>
To: "Fernando Nasser" <fnasser(at)redhat(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Vince Vielhaber" <vev(at)michvhf(dot)com>, "Thomas Lockhart" <thomas(at)fourpalms(dot)org>, "Rod Taylor" <rbt(at)zort(dot)ca>, "Peter Eisentraut" <peter_e(at)gmx(dot)net>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: insert statements
Date: 2002-03-18 18:49:45
Message-ID: 46C15C39FEB2C44BA555E356FBCD6FA4961D88@m0114.s-mxs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


>>
>> I'd want it to error out on "INSERT foo (bar.col)", though ;-)
>>
>
> And on "INSERT foo (bar.foo.col)" as well.

Why accept above at all ? Seems much too error prone, I would eighter
accept table with schema or without schema, mixing both cases seems
unnecessarily confusing and error prone to me.

If at all, I would allow:
INSERT bar.foo (bar.foo.col)
INSERT foo (foo.col)

Would that be enough for the initial problem case ?

Andreas

Browse pgsql-hackers by date

  From Date Subject
Next Message Luis Alberto Amigo Navarro 2002-03-18 18:58:45 Re: postgres is not using tas
Previous Message Luis Alberto Amigo Navarro 2002-03-18 18:32:59 Re: postgres is not using tas