Обсуждение: postgres 6.5 error
I've installed postgresql 6.4.2 onto linuxppc systems several times before without problems. I have recently installed the newly released linuxppc-R5 release, which includes an rpm for 6.5-0beta1. I was able to run initdb just fine. then started the postmaster. ran createdb o.k. then loaded up a table with psql -e dbname < dbname.sql this ran fine as well. But when I try to psql dbname followed by a \d dbname I get the following error: ERROR: typeidTypeRelid: Invalid type - oid = 0 Any suggestions ? Kevin -------------------------------------------------------------------- Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103 VP/Mac Tech | 333 Texas St #175 | FAX:318.221.6612 kheflin@shreve.net | Shreveport, LA 71101 | http://www.shreve.net --------------------------------------------------------------------
yep. beta... On Sun, 20 Jun 1999, Kevin Heflin wrote: > > I've installed postgresql 6.4.2 onto linuxppc systems several times before > without problems. I have recently installed the newly released linuxppc-R5 > release, which includes an rpm for 6.5-0beta1. I was able to run initdb > just fine. then started the postmaster. ran createdb o.k. then loaded up a > table with psql -e dbname < dbname.sql > this ran fine as well. > But when I try to psql dbname followed by a \d dbname I get the following > error: > > ERROR: typeidTypeRelid: Invalid type - oid = 0 > > Any suggestions ? > > Kevin > > -------------------------------------------------------------------- > Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103 > VP/Mac Tech | 333 Texas St #175 | FAX:318.221.6612 > kheflin@shreve.net | Shreveport, LA 71101 | http://www.shreve.net > -------------------------------------------------------------------- > > >
On Sun, 20 Jun 1999, Marcin Grondecki wrote: > > yep. > beta... So I've removed the beta1 rpm from my system, and installed from source the 6.5 final relase.. still get the same error when I try to do \d dbname Inserts and selects seem to work o.k. this has been only error I've come across, but haven't tried putting this system through much yet. > > On Sun, 20 Jun 1999, Kevin Heflin wrote: > > > > > I've installed postgresql 6.4.2 onto linuxppc systems several times before > > without problems. I have recently installed the newly released linuxppc-R5 > > release, which includes an rpm for 6.5-0beta1. I was able to run initdb > > just fine. then started the postmaster. ran createdb o.k. then loaded up a > > table with psql -e dbname < dbname.sql > > this ran fine as well. > > But when I try to psql dbname followed by a \d dbname I get the following > > error: > > > > ERROR: typeidTypeRelid: Invalid type - oid = 0 > > > > Any suggestions ? > > > > Kevin > > > > -------------------------------------------------------------------- > > Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103 > > VP/Mac Tech | 333 Texas St #175 | FAX:318.221.6612 > > kheflin@shreve.net | Shreveport, LA 71101 | http://www.shreve.net > > -------------------------------------------------------------------- > > > > > > > -------------------------------------------------------------------- Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103 VP/Mac Tech | 333 Texas St #175 | FAX:318.221.6612 kheflin@shreve.net | Shreveport, LA 71101 | http://www.shreve.net --------------------------------------------------------------------
I've no problems with using /d <table_name> syntax. Mail structure od this table (cut it from your db.out) - if would be helpfull to determine problem. On Sun, 20 Jun 1999, Kevin Heflin wrote: > On Sun, 20 Jun 1999, Marcin Grondecki wrote: > > > > > yep. > > beta... > > > So I've removed the beta1 rpm from my system, and installed from source > the 6.5 final relase.. still get the same error when I try to do \d dbname > > Inserts and selects seem to work o.k. this has been only error I've come > across, but haven't tried putting this system through much yet. > > > > > > > > > > On Sun, 20 Jun 1999, Kevin Heflin wrote: > > > > > > > > I've installed postgresql 6.4.2 onto linuxppc systems several times before > > > without problems. I have recently installed the newly released linuxppc-R5 > > > release, which includes an rpm for 6.5-0beta1. I was able to run initdb > > > just fine. then started the postmaster. ran createdb o.k. then loaded up a > > > table with psql -e dbname < dbname.sql > > > this ran fine as well. > > > But when I try to psql dbname followed by a \d dbname I get the following > > > error: > > > > > > ERROR: typeidTypeRelid: Invalid type - oid = 0 > > > > > > Any suggestions ? > > > > > > Kevin > > > > > > -------------------------------------------------------------------- > > > Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103 > > > VP/Mac Tech | 333 Texas St #175 | FAX:318.221.6612 > > > kheflin@shreve.net | Shreveport, LA 71101 | http://www.shreve.net > > > -------------------------------------------------------------------- > > > > > > > > > > > > > -------------------------------------------------------------------- > Kevin Heflin | ShreveNet, Inc. | Ph:318.222.2638 x103 > VP/Mac Tech | 333 Texas St #175 | FAX:318.221.6612 > kheflin@shreve.net | Shreveport, LA 71101 | http://www.shreve.net > -------------------------------------------------------------------- > > >