if (SQLCODE != 0) { sprintf(rMsg,"ERROR: ERROR on SELError Unknown type 'oid8'

Started by Paul Hardimanover 25 years ago2 messagesgeneral
Jump to latest
#1Paul Hardiman
hardiman@hardiman.com

Hi,
using postgres 7.02 linux 2.2.13-4mdk. I built postgres with perl and
odbc turn on. No other options.
The location /opt/postgres is newly created and owned by postgres.

when running initdb -d, I get the following excerpt:
<excerpt>
Running with debug mode on.
initdb: Using /usr/lib/pgsql/local1_template1.bki.source as input to
create the template database.
initdb: Using /usr/lib/pgsql/global1.bki.source as input to create the
global classes.
initdb: Using /usr/lib/pgsql/pg_hba.conf.sample as default
authentication control file.
This database system will be initialized with username "postgres".
This user will own all the data files and must also own the server
process.

Creating database system directory /opt/postgres/data
Creating database system directory /opt/postgres/data/base
Creating database XLOG directory /opt/postgres/data/pg_xlog
Creating template database in /opt/postgres/data/base/template1
Running: /usr/local/pgsql/bin/postgres -boot -x -C -F
-D/opt/postgres/data -d template1
<proname name>
<proowner int4>
<prolang oid>
<proisinh bool>
<proistrusted bool>
<proiscachable bool>
<pronargs int2>
<proretset bool>
<prorettype oid>
bootstrap.c: External Type: oid8
ERROR: Error: unknown type 'oid8'.
</excerpt>
I have no idea on how to proceed.

I appreciate any assist.

--
Regards,
Paul Hardiman
InterMedia, Inc (Colorado)
Informations Systems Consulting
303-581-0606, Fax 581-0506, hardiman@hardiman.com

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Paul Hardiman (#1)
Re: if (SQLCODE != 0) { sprintf(rMsg, "ERROR: ERROR on SELError Unknown type 'oid8'

Paul Hardiman <hardiman@hardiman.com> writes:

[ initdb fails with ]
ERROR: Error: unknown type 'oid8'.

Someone else ran into that just a few days ago. Looks to me like you're
picking up old library files (*.bki files) from a 6.5 or older
installation, instead of the ones that go with 7.0. Check your
PGLIB setting.

regards, tom lane