Little question on owners

Started by Olivier PRENANTabout 24 years ago1 messages
#1Olivier PRENANT
ohp@pyrenet.fr

Hi all!!

I'm testing 7.2b4 and I have this (little problem) when importing the
7.1.3 databases:

2 of the databases are owner by a gone user (not in the system
anymore) That gives errors when recreating databases.

I'd like to see this databases belong to me (that one was easy : change
sysuid in pg_databases); however, how do I change table owner, permissions
etc..

Regards

--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)