Re: Help, I dropped a system datatype, and now I'm .... - Mailing list pgsql-general

From Dave Cramer
Subject Re: Help, I dropped a system datatype, and now I'm ....
Date
Msg-id 000f01c0d188$3fe343f0$230470d1@INSPIRON
Whole thread Raw
In response to Re: Re: Report Writer for PostgreSQL  (larry a price <laprice@efn.org>)
Responses Re: Help, I dropped a system datatype, and now I'm ....
List pgsql-general
Tom,

Thanks, actually Bruce helped me out with this last night.

>
> Oops.  Consider not doing your development work as superuser ;-)
>

What is the definition of superuser? most of my users have the ability to
createdb. This seems to give them superuser priveleges. Is that correct?

Dave


> > I have two possible solutions; 1 of which doesn't work yet
>
> > insert back into the pg_type table the box row copied from another
machine
> > with oid 603, which postgres doesn't allow me to do.
>
> AFAIR, this should work if you use COPY WITH OIDS.
>
> > recreate the type and find all the references to it. Can someone tell me
> > where to look for all the references to it?
>
> This would not work very well since pg_dump would then think that 'box'
> is a user-defined type and would include it in dumps, which you do not
> want.  Instead, consider finding and dropping the procs, operators, etc
> that refer to 'box' (only if you don't use the type, of course).
> pg_proc and pg_operator would be the main places, there might also be
> some in pg_amproc and pg_amop.  See contrib/findoidjoins/README for more
> info about where to look.
>
> regards, tom lane
>
>


pgsql-general by date:

Previous
From: "Eric G. Miller"
Date:
Subject: Re: running pgaccess on localhost
Next
From: "Fred Ingham"
Date:
Subject: RE: PostgreSQL and mySQL database size question