Postgres Pro
Downloads
Home   >   mailing lists

Thread: backwards-compat problem?

backwards-compat problem?

From
"Christopher Kings-Lynne"
Date:
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

Re: backwards-compat problem?

From
Tom Lane
Date:
"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

Re: backwards-compat problem?

From
"Christopher Kings-Lynne"
Date:
> > 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

Re: backwards-compat problem?

From
Tom Lane
Date:
"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

Re: backwards-compat problem?

From
Bruce Momjian
Date:
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