Re: [GENERAL] ERROR: Unable to locate type oid 0 in catalog...

2004-11-18 Thread frbn
___ 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

[GENERAL] ERROR: Unable to locate type oid 0 in catalog...

2004-11-18 Thread frbn
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

Re: [GENERAL] Pgsql 7.3.3 on redhat 7.2

2003-10-23 Thread frbn
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