Re: [Fwd: Help Me]

> I'm Korean. and I can't speak English well.
> I want to know PostgreSQL 6.5.3 's int8(array)
> My System is Redhat 6.1, Pentium.
> and I make array int8 data type.
> so I make int8 by ./contrib/int8 package.

int8 is now a built-in type, but...

> create table lr(val int8[][][]);
> ERROR: Unable to locate type name '_int8' in catalog
> Why ERROR: Unable to locate type name '_int8' in catalog
> but Not use array ---> Ok.

It looks like you have uncovered a bug in Postgres; there is no
catalog entry for the int8 array type. It should be fixed in the next
release.

I am sending you a patch, but my Postgres installation is torn apart
at the moment so it is not tested!! Perhaps one of the other
developers will be able to test and commit a patch to fix this problem
sooner than I.

Thanks for the report, and sorry that it currently does not work for
you.

The patch should be applied to the source code as follows:

1) cd src/include/catalog
2) patch < pg_type.h.patch
3) cd ../.. # (to src directory)
4) make clean
5) make install
6) rm -rf ../data # or wherever your postgres data directory is
7) initdb
8) restart postmaster

Good luck.

- Thomas

--
Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California