Re: [GENERAL] problem with PostgreSQL 6.5 on Linux

On Fri, 25 Jun 1999, Dan Wilson wrote:

> I ran into the same problem and it turned out to be an outdated version of
> psql.  Check your path to see if you are accessing the correct version of
> psql, pg_dump etc..

it is; ive made sure of that.  stripped all the permissions off of the
entire 6.4.2 install tree, in fact.

manually cat'ing $PGDATA/PG_VERSION shows that its indeed "6.4" instead of
"6.5".  i can manually echo 6.5 >$PGDATA/PG_VERSION, fixing the connection
problem, but i more concerned with why this is occurring.

as a sidenote, 'initdb' doesnt appear to be creating the proper pg_*
tables; pg_user doesnt exist.  im starting to think the compile went
bad...

there also seems to be an ongoing problem with psql and importing TEXT
fields via COPY.  i can import a relatively large (~490k entries ) table
w/o text fields just fine, but importing an 11k entry table _with_ text
entries fails with a buffer overflow.  this has happened since pgsql 6.3.2

---
Howie <caffeine@toodarkpark.org>   URL: http://www.toodarkpark.org
"The distance between insanity and genius is measured only by success."