Received: from candle.pha.pa.us (candle.navpoint.com [162.33.245.46]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4MBgDA07393 for ; Tue, 22 May 2001 07:42:13 -0400 (EDT) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.10.1/8.10.1) id f4MBg8S29036; Tue, 22 May 2001 07:42:08 -0400 (EDT) From: Bruce Momjian Message-Id: <200105221142.f4MBg8S29036@candle.pha.pa.us> Subject: Re: how to set ownership of tables? In-Reply-To: <20010521222840.Q15377@erm1.u-strasbg.fr> "from Bruno Boettcher at May 21, 2001 10:28:40 pm" To: Bruno Boettcher Date: Tue, 22 May 2001 07:42:08 -0400 (EDT) CC: pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL90 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200105/235 X-Sequence-Number: 3052 > Hello! > > how can i change the ownership of a table? i have the problem that i > create table with CONSTRAINTS on other tables, those others have a > different owner... and thus the creation of the table is refused.... > > is it possible to make constraints on tables whithout having their > ownership? is it possible to grant those rights? > > or otherwise, how can i change the owenership of the concerned table? 7.1.X has ALTER TABLE ... OWNER. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026