Re: invalid type error

Johnson, Shaunn wrote:
> Howdy:
>
> Running Postgres 7.1.3 on RedHat Linux 7.2.
>
>
> I don't know what I did, or how I did it, but when I
> try to do a pg_dump of a table, I get this message:
>
> [snip]
>
> WARNING: owner of type 'number' appears to be invalid
> WARNING: owner of type 'interger' appears to be invalid
>
> [/snip]
>
> I'm thinking that I did the latter one when I was
> trying to create a function and I fat-fingered
> the name.

    Sure  did  you, and I'm pretty sure you did with the "number"
    type as well since there is no such datatype in the system by
    default.   Maybe  you haven't found the function(s) returning
    that typo - er type yet, but if you find  some,  there  isn't
    much more useful to do with them than dropping.

    Try a

        SELECT proname FROM pg_proc P, pg_type T
            WHERE P.prorettype = T.oid
              AND T.typname = 'number';

    The  reason  why it says that the owner appears to be invalid
    is, that the created pg_type shell has owner ID 0 yet.

> Does anyone know how I can get rid of these messages?

    You need to complete these type definitions, before  you  can
    drop the resulting datatype again. The commands

        CREATE TYPE interger (
            INPUT=textin, OUTPUT=textout,
            INTERNALLENGTH=variable);
        DROP TYPE interger;

    should take care of one of them.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #