Skip site navigation (1) Skip section navigation (2)

Re: [BUGS] PSQL commands not backwards-compatible

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
Cc: josh(at)agliodbs(dot)com,PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [BUGS] PSQL commands not backwards-compatible
Date: 2005-08-31 02:40:31
Message-ID: 200508310240.j7V2eV301793@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-patches
Marc G. Fournier wrote:
> 
> Could this be back patched to the older versions as well?

Sure.

---------------------------------------------------------------------------


> 
> On Tue, 30 Aug 2005, Bruce Momjian wrote:
> 
> > Josh Berkus wrote:
> >> Tom,
> >>
> >>> They've been broken on a fairly regular basis in past releases.
> >>> Certainly 7.3 broke every single one because of the addition of
> >>> schema syntax ...
> >>
> >> Yeah, and we warned people about it, as I recall.   Also, we had about 25x
> >> less users then.   I think we should put something in the release notes:
> >>
> >> WARNING: 8.1's "psql" is not completely backwards-compatible with previous
> >> versions of PostgreSQL.
> >
> > Here is a patch that will print out (in interactive mode only) a warning
> > message if a newer client connects to an older major numbered server.
> >
> > --
> >  Bruce Momjian                        |  http://candle.pha.pa.us
> >  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
> >  +  If your life is a hard drive,     |  13 Roberts Road
> >  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
> >
> 
> ----
> Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
> Email: scrappy(at)hub(dot)org           Yahoo!: yscrappy              ICQ: 7615664
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-08-31 03:03:40
Subject: Re: PSQL commands not backwards-compatible
Previous:From: Marc G. FournierDate: 2005-08-31 02:36:51
Subject: Re: [BUGS] PSQL commands not backwards-compatible

pgsql-patches by date

Next:From: Tom LaneDate: 2005-08-31 03:03:40
Subject: Re: PSQL commands not backwards-compatible
Previous:From: Marc G. FournierDate: 2005-08-31 02:36:51
Subject: Re: [BUGS] PSQL commands not backwards-compatible

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group