Re: [GENERAL] *Old* PostgreSQL version

Bruce Momjian writes:

> > database_name=> select version();
> > WARN:parser: Syntax error at or near "version"
> >
> > What else can I do? I can see from the dates of the files that it was
> > installed sometime in mid-1997. What else can I use to find the
> > version?
>
> That's a good one. There is a data/PG_VERSION file in the install
> directory that should contain the version, though there was one release
> where we forgot to update that. That may help. I assume you don't have
> the source code, because the HISTORY file always has the version at the
> top of the file.

Yes, that did it! Thanks a lot. (6.1... Not *that* old after all. Or
is it?) Perhaps it needs to be added to that question in the FAQ or
something.

--
Alex Shnitman | http://www.debian.org
alexsh(at)hectic(dot)net, alexsh(at)linux(dot)org(dot)il +-----------------------
http://alexsh.hectic.net UIN 188956 PGP key on web page
E1 F2 7B 6C A0 31 80 28 63 B8 02 BA 65 C7 8B BA

Minds are like parachutes... they work best when open.