___
I see what fails:
SELECT Oid FROM pg_index i WHERE i.indisprimary AND i.indrelid =
2178456572
I tried this query with quotes and it works!
( SELECT Oid FROM pg_index i WHERE i.indisprimary AND i.indrelid =
'2178456572')
It looks the same as all the problems we have with types
when doi
hi all,
we currently experience an original problem
on a production server with a postgresql 7.1.3
( a bit old, I know :\ )
We just want to know if somebody experienced this problem:
the error message :
"ERROR: Unable to locate type oid 0 in catalog"
I know that such a type can't exists as the ty
hi,
it seems you use the /usr/bin/pg_dumpall featured by the redhat default
install
verify this with "which pg_dumpall"
(rpm -ql postgresql to see all the files of this package)
you upgraded from sources didn't you ?
your fresh new install has the default prefix /usr/local (redhat uses /usr)
2