Re: backwards-compat problem?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
Cc: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: backwards-compat problem?
Date: 2003-08-19 03:00:19
Message-ID: 19401.1061262019@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-08-19 03:26:20 Re: backwards-compat problem?
Previous Message Rod Taylor 2003-08-19 02:07:45 Re: Qualified tables in error messages