X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id AE3CAD1B4D7 for ; Wed, 10 Dec 2003 16:12:49 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 73410-08 for ; Wed, 10 Dec 2003 12:12:18 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 8252AD1B565 for ; Wed, 10 Dec 2003 12:12:17 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id hBAGCG19006769; Wed, 10 Dec 2003 11:12:16 -0500 (EST) To: Chris Travers Cc: pgsql-sql@postgresql.org Subject: Re: How to completely move a table to another schema? In-reply-to: <1071041216.2212.73.camel@localhost.localdomain> References: <1071041216.2212.73.camel@localhost.localdomain> Comments: In-reply-to Chris Travers message dated "10 Dec 2003 20:21:08 +0800" Date: Wed, 10 Dec 2003 11:12:16 -0500 Message-ID: <6768.1071072736@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/85 X-Sequence-Number: 16251 Chris Travers writes: > I have a function which moves a table from one schema to another by > updating the relnamespace field of pg_class: > Am I missing anything? pg_constraint entries related to the table. Also you need to recurse for each index of the table. regards, tom lane