> 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@alumni.caltech.edu
South Pasadena, California*** pg_type.h.orig Mon Jan 3 08:27:36 2000
--- pg_type.h Wed Jan 12 15:40:40 2000
***************
*** 328,333 ****
--- 328,334 ----
DATA(insert OID = 1013 ( _oid8 PGUID -1 -1 f b t \054 0 30 array_in array_out array_in array_out i
_null_));
DATA(insert OID = 1014 ( _bpchar PGUID -1 -1 f b t \054 0 1042 array_in array_out array_in array_out i _null_
));
DATA(insert OID = 1015 ( _varchar PGUID -1 -1 f b t \054 0 1043 array_in array_out array_in array_out i _null_
));
+ DATA(insert OID = 1016 ( _int8 PGUID -1 -1 f b t \054 0 20 array_in array_out array_in array_out d
_null_));
DATA(insert OID = 1017 ( _point PGUID -1 -1 f b t \054 0 600 array_in array_out array_in array_out d _null_ ));
DATA(insert OID = 1018 ( _lseg PGUID -1 -1 f b t \054 0 601 array_in array_out array_in array_out d _null_
));
DATA(insert OID = 1019 ( _path PGUID -1 -1 f b t \054 0 602 array_in array_out array_in array_out d _null_
));