Re: [BUGS] PSQL commands not backwards-compatible

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@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
> >
>
> ----
> Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
> Email: scrappy@hub.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@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