From: | Zoltan Boszormenyi <zb(at)cybertec(dot)at> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: Behavior of GENERATED columns per SQL2003 |
Date: | 2007-05-10 08:57:23 |
Message-ID: | 4642DE73.4040809@cybertec.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Zoltan Boszormenyi írta:
> The quoted SIGMOD paper mentioned that specifying a value
> for a generated column should raise an error in INSERT but
> this behaviour is not mentioned by the standard.
I found it now, I haven't read hard enough before.
SQL:2003, section 14.8, syntax rules:
10) If <contextually typed table value constructor> CTTVC is specified,
then every <contextually typed row
value constructor element> simply contained in CTTVC whose
positionally corresponding <column name>
in <insert column list> references a column of which some underlying
column is a generated column shall
be a <default specification>.
So, I can only omit the generated column or specify DEFAULT.
Anything else should raise an error. Should it be done in analyze.c
or in rewriteHandler.c?
--
----------------------------------
Zoltán Böszörményi
Cybertec Geschwinde & Schönig GmbH
http://www.postgresql.at/
From | Date | Subject | |
---|---|---|---|
Next Message | Valentine Gogichashvili | 2007-05-10 09:07:17 | Re: [PERFORM] Cannot make GIN intarray index be used by the planner |
Previous Message | Zoltan Boszormenyi | 2007-05-10 07:22:04 | Re: Behavior of GENERATED columns per SQL2003 |