X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4E8E4D9A59 for ; Wed, 28 Sep 2005 11:24:17 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 15761-07 for ; Wed, 28 Sep 2005 14:24:11 +0000 (GMT) Received: from zrtps0kp.nortelnetworks.com (zrtps0kp.nortelnetworks.com [47.140.192.56]) by svr1.postgresql.org (Postfix) with ESMTP id CDB69D9A17 for ; Wed, 28 Sep 2005 11:24:12 -0300 (ADT) Received: from zrtps0m6.us.nortel.com (zrtps0m6.us.nortel.com [47.140.192.58]) by zrtps0kp.nortelnetworks.com (Switch-2.2.6/Switch-2.2.0) with ESMTP id j8SEOEn04188; Wed, 28 Sep 2005 10:24:14 -0400 (EDT) Received: from cash.rhiamet.com (rhiamet.us.nortel.com [47.103.243.53]) by zrtps0m6.us.nortel.com (Switch-2.2.6/Switch-2.2.0) with ESMTP id j8SEO4S00923; Wed, 28 Sep 2005 10:24:04 -0400 (EDT) Received: from cash.rhiamet.com (bmetcalf@localhost [127.0.0.1]) by cash.rhiamet.com (8.13.4/8.13.4/Debian-3) with ESMTP id j8SEO0br005043; Wed, 28 Sep 2005 09:24:00 -0500 Received: from localhost (bmetcalf@localhost) by cash.rhiamet.com (8.13.4/8.13.4/Submit) with ESMTP id j8SENxSh005039; Wed, 28 Sep 2005 09:24:00 -0500 X-Authentication-Warning: cash.rhiamet.com: bmetcalf owned process doing -bs Date: Wed, 28 Sep 2005 09:23:59 -0500 (CDT) From: "Brandon Metcalf" X-X-Sender: bmetcalf@cash.rhiamet.com To: Chris Browne Cc: pgsql-sql@postgresql.org Subject: Re: add column if doesn't exist In-Reply-To: <60d5muk52o.fsf@dba2.int.libertyrms.com> Message-ID: References: <200509270216.05141.peter_e@gmx.net> <60d5muk52o.fsf@dba2.int.libertyrms.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.248 required=5 tests=[AWL=0.198, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/277 X-Sequence-Number: 22824 c == cbbrowne@acm.org writes: c> I set up a stored procedure to do this for Slony-I... Replace c> @NAMESPACE@ with your favorite namespace, and slon_quote_brute can c> likely be treated as an identity function unless you use silly c> namespace names :-). Thanks. -- Brandon