Postgres Pro
Downloads
Home   >   mailing lists

Thread: postgres 6.5 error

postgres 6.5 error

From
Kevin Heflin
Date:
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
--------------------------------------------------------------------

Re: [GENERAL] postgres 6.5 error

From
Marcin Grondecki
Date:
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
> --------------------------------------------------------------------
>
>
>

Re: [GENERAL] postgres 6.5 error

From
Kevin Heflin
Date:
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
--------------------------------------------------------------------

Re: [GENERAL] postgres 6.5 error

From
Marcin Grondecki
Date:
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
> --------------------------------------------------------------------
>
>
>