On Thu, Jun 19, 2003 at 09:52:14AM -0400, Rod Taylor wrote: > On Thu, 2003-06-19 at 09:40, Tom Lane wrote:
> Do we want them to? If we don't mind them being executed, it is far > easier to: > > - alter table structure > - Add all new constraints (without confirming their correctness at that > time) > - update table contents via an SPI call to UPDATE WHERE <column> IS NULL Sorry, I haven't read the spec, but what happens when there is a default value already and it's not NULL? Are tuples where column = default updated? Are tuples where column IS NULL updated? -- Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) Y dijo Dios: "Que sea Satanás, para que la gente no me culpe de todo a mí." "Y que hayan abogados, para que la gente no culpe de todo a Satanás" ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend