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(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