Received: from erm1.u-strasbg.fr (erm1.u-strasbg.fr [130.79.74.61]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4LKLdA49091 for ; Mon, 21 May 2001 16:21:39 -0400 (EDT) (envelope-from bboett@erm1.u-strasbg.fr) Received: by erm1.u-strasbg.fr (Postfix, from userid 501) id C495B5E36; Mon, 21 May 2001 22:28:40 +0200 (CEST) Date: Mon, 21 May 2001 22:28:40 +0200 To: pgsql-sql@postgresql.org Subject: how to set ownership of tables? Message-ID: <20010521222840.Q15377@erm1.u-strasbg.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline User-Agent: Mutt/1.3.15i From: bboett@erm1.u-strasbg.fr (Bruno Boettcher) X-Archive-Number: 200105/229 X-Sequence-Number: 3046 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? -- ciao bboett ============================================================== bboett@earthling.net http://inforezo.u-strasbg.fr/~bboett http://erm1.u-strasbg.fr/~bboett =============================================================== the total amount of intelligence on earth is constant. human population is growing....