Re: SOLVED: invalid type error

From: Jan Wieck <janwieck(at)yahoo(dot)com>
To: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
Cc: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: SOLVED: invalid type error
Date: 2002-06-03 19:47:58
Message-ID: 200206031947.g53Jlww03802@saturn.janwieck.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Johnson, Shaunn wrote:
> --Never mind; I solved it.
>
> --It had to do with something in pg_type.

Just deleted the rows from pg_type?

If so, congrats, in this case it is one of the possible
solutions. In some other cases you might well mess up your
entire DB's system catalog by shooting around in the pg_*
tables like that without the advice of someone who really
knows what she's doing there.

Jan

--

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2002-06-03 20:00:47 Re: ctid & updates
Previous Message Jan Wieck 2002-06-03 19:37:16 Re: invalid type error