Re: [SQL] owner of type 'mmm' apperars to be invalid

2002-11-05 Thread Richard Huxton
On Tuesday 05 Nov 2002 2:32 pm, cristi wrote: > On Tuesday 05 Nov 2002 1:03 pm, cristi wrote: > >But - you have deleted the "refcursor" type which is not a good idea! If > Ooo > Yes, I see... > You right. > > >If so, drop and recreate the database, restoring the data to it. If not, I > think y

Re: [SQL] owner of type 'mmm' apperars to be invalid

2002-11-05 Thread cristi
On Tuesday 05 Nov 2002 1:03 pm, cristi wrote: > It shouldn't be this the solution of the problem? >> salt=# delete from pg_type where typname='refcursor'; >> DELETE 1 >> Now, I don't have the error message! > >Mr.Richard Huxton, thank you very much! >But - you have deleted the "refcursor" ty

Re: [SQL] owner of type 'mmm' apperars to be invalid

2002-11-05 Thread Richard Huxton
On Tuesday 05 Nov 2002 1:03 pm, cristi wrote: > It shouldn't be this the solution of the problem? > > salt=# delete from pg_type where typname='refcursor'; > DELETE 1 > salt=# delete from pg_type where typname='eee'; > DELETE 1 > salt=# delete from pg_type where typname='mmm'; > DELETE 1 > > Now, I

Re: [SQL] owner of type 'mmm' apperars to be invalid

2002-11-05 Thread cristi
It shouldn't be this the solution of the problem? salt=# delete from pg_type where typname='refcursor'; DELETE 1 salt=# delete from pg_type where typname='eee'; DELETE 1 salt=# delete from pg_type where typname='mmm'; DELETE 1 Now, I don't have the error message! Mr.Richard Huxton, thank you ver

Re: [SQL] owner of type 'mmm' apperars to be invalid

2002-11-05 Thread Richard Huxton
On Tuesday 05 Nov 2002 5:57 am, cristi wrote: > When I'm trying to make pg_dump on a data base I have this message: > > WARNING: owner of type 'mmm' apperars to be invalid > WARNING: owner of type 'eee' apperars to be invalid > WARNING: owner of type 'refcursor' apperars to be invalid > > Where ar

[SQL] owner of type 'mmm' apperars to be invalid

2002-11-04 Thread cristi
  When I'm trying to make pg_dump on a data base I have this message: WARNING: owner of type 'mmm' apperars to be invalidWARNING: owner of type 'eee' apperars to be invalidWARNING: owner of type 'refcursor' apperars to be invalid Where are these object and how can I destroy its?