Обсуждение: backwards-compat problem?
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? Chris
"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
> > 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. Can we ensue that this is listed in the release notes clearly then? Chris
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> Can we ensue that this is listed in the release notes clearly then?
Bruce hasn't made up the "incompatibilities to note" section yet,
but when he does, it should certainly be mentioned.
regards, tom lane
Got it. --------------------------------------------------------------------------- Tom Lane wrote: > "Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes: > > Can we ensue that this is listed in the release notes clearly then? > > Bruce hasn't made up the "incompatibilities to note" section yet, > but when he does, it should certainly be mentioned. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania19073