Re: default values for views
От
Tom Lane
Тема
Re: default values for views
Дата
Msg-id
6203.1018909483@sss.pgh.pa.us
Ответ на
default values for views (Neil Conway)
Список
Дерево обсуждения
default values for views Neil Conway <nconway@klamath.dyndns.org>
Re: default values for views Bruce Momjian <pgman@candle.pha.pa.us>
Re: default values for views Neil Conway <nconway@klamath.dyndns.org>
Re: default values for views Bruce Momjian <pgman@candle.pha.pa.us>
Re: default values for views Tom Lane <tgl@sss.pgh.pa.us>
Re: default values for views Bruce Momjian <pgman@candle.pha.pa.us>
Re: default values for views Tom Lane <tgl@sss.pgh.pa.us>
Re: default values for views Neil Conway <nconway@klamath.dyndns.org>
Re: default values for views Neil Conway <nconway@klamath.dyndns.org>
Re: default values for views Bruce Momjian <pgman@candle.pha.pa.us>
Re: default values for views Bruce Momjian <pgman@candle.pha.pa.us>
Re: default values for views Tom Lane <tgl@sss.pgh.pa.us>
Neil Conway writes: + if (tblinfo[i].adef_expr[j] != NULL && tblinfo[i].inhAttrDef[j] == 0) + appendPQExpBuffer(q, "ALTER TABLE %s ALTER COLUMN %s SET DEFAULT %s;\n", + tblinfo[i].relname, tblinfo[i].attnames[j], + tblinfo[i].adef_expr[j]); I think you need some fmtId calls here, else it will fail on mixed-case names and suchlike. regards, tom lane
В списке pgsql-patches по дате отправления
