"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> 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