"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > You know how DEFAULT 'now' no longer works? Well, I have some old tables > that still have stuff like DEFAULT 'now' and DEFAULT 'today' in them and > they will be dumped with pg_dump using that default. Does that mean that > mean that when I reload into 7.4, my defaults will no longer work?
You can do the ALTER TABLE SET DEFAULT now, or after you load into 7.4, but you'll have to fix it sooner or later. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org