"Cherry Ann Alib" <alib.ch@g6v.cnt.ncos.nec.co.jp> writes:
> I am currently having a problen initializing database in HPUX11.0.
> creating template1 database in /home/calib/data/base/1... ERROR: invalid
> input syntax for type "oid": "select cast(($1 + $2) as timestamp with time
> zone)"
Hmm ... what Postgres version is this exactly? How did you
build/install it?
The problem looks like the contents of the postgres.bki initialization
script are either wrong or being incorrectly interpreted by the
bootstrap loading code (specifically, I'm thinking that it's gotten off
by one column in the contents of pg_proc, so that a value meant for the
prosrc column is being put into an adjacent OID column).
IIRC we have seen cases in the past where postgres.bki got mangled by
buggy versions of "sed" or "awk", since we rely on those programs to
generate postgres.bki from the source files. Not sure if that is your
problem here though.
regards, tom lane