Return-Path: postman Delivery-Date: Wed, 25 Aug 93 10:19:30 PDT Return-Path: postman Received: by postgres.Berkeley.EDU (5.61/1.29) id AA17627; Wed, 25 Aug 93 10:14:14 -0700 Resent-From: postman (POSTGRES mailing list) Resent-Message-Id: <9308251714.AA17627@postgres.Berkeley.EDU> Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: aoki@postgres.Berkeley.EDU Received: from faerie.CS.Berkeley.EDU by postgres.Berkeley.EDU (5.61/1.29) id AA17619; Wed, 25 Aug 93 10:14:09 -0700 Received: from localhost (localhost [127.0.0.1]) by faerie.CS.Berkeley.EDU (8.1C/8.1B) with SMTP id KAA03385; Wed, 25 Aug 1993 10:22:27 -0700 Message-Id: <199308251722.KAA03385@faerie.CS.Berkeley.EDU> From: aoki@postgres.berkeley.edu (Paul M. Aoki) To: David Allan Finch Cc: postgres@postgres.berkeley.edu Subject: Re: Class ownership In-Reply-To: Your message of Wed, 25 Aug 93 08:43:00 BST <9308250749.AA00199@vger.demon.co.uk> Date: Wed, 25 Aug 93 10:22:27 -0700 X-Sender: aoki@postgres.Berkeley.EDU X-Mts: smtp Resent-To: postgres-dist Resent-Date: Wed, 25 Aug 93 10:14:13 PDT David Allan Finch writes: > My new question is 'how do you change the ownership > of a class?'. I can dump the class format to rebuild > the structure and the data to re-load, but all the > data and classes are now owned by Postgres. Can I just > change the ownership by modifing the field in pg_class > for that class? that should work, assuming you're only talking about ownership within the database. (relowner is just your uid.) if you're having a problem with unix permissions, well, postgres doesn't run suid root :-) -- Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU | Berkeley, CA 94720 | ...!uunet!ucbvax!aoki