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


Tue, 19 Aug 2003 09:54:06 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
backwards-compat problem?
"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

Mon, 18 Aug 2003 23:00:19 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: 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?
>
> 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


Tue, 19 Aug 2003 11:26:20 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: backwards-compat problem? 
"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

Mon, 18 Aug 2003 23:28:52 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: backwards-compat problem? 

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, Pennsylvania 19073

Mon, 25 Aug 2003 23:52:27 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: backwards-compat problem?