X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 08CC99DCA04 for ; Thu, 9 Feb 2006 13:11:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 87844-05 for ; Thu, 9 Feb 2006 13:11:32 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id E5ED89DCA25 for ; Thu, 9 Feb 2006 13:11:31 -0400 (AST) Received: from red.jesrie.de (red.jesrie.de [62.146.91.106]) by svr4.postgresql.org (Postfix) with ESMTP id EEC0F5AF02E for ; Thu, 9 Feb 2006 17:11:31 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by red.jesrie.de (Postfix) with ESMTP id 830BC2C00A4 for ; Thu, 9 Feb 2006 18:13:29 +0100 (CET) Received: from red.jesrie.de ([127.0.0.1]) by localhost (red.jesrie.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01239-14 for ; Thu, 9 Feb 2006 18:13:29 +0100 (CET) Received: from mail.arsoft.homeip.net (i3ED6E527.versanet.de [62.214.229.39]) by red.jesrie.de (Postfix) with ESMTP id 447182C008B for ; Thu, 9 Feb 2006 18:13:29 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by mail.arsoft.homeip.net (Postfix) with ESMTP id A81BA1003BA for ; Thu, 9 Feb 2006 18:11:25 +0100 (CET) Received: from mail.arsoft.homeip.net ([192.168.1.2]) by localhost (srv.arsoft.homeip.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 30137-09 for ; Thu, 9 Feb 2006 18:11:25 +0100 (CET) Received: from ar.arsoft.homeip.net (ar.arsoft.homeip.net [192.168.1.19]) by mail.arsoft.homeip.net (Postfix) with ESMTP id 0F8B110035D for ; Thu, 9 Feb 2006 18:11:25 +0100 (CET) From: Andreas Roth To: pgsql-sql@postgresql.org Subject: Change definition of a view Date: Thu, 9 Feb 2006 18:11:24 +0100 User-Agent: KMail/1.9.1 MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200602091811.24476.aroth@arsoft-online.com> X-Virus-Scanned: by amavisd-new at arsoft.homeip.net X-Virus-Scanned: amavisd-new at jesire.de X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.195 required=5 tests=[AWL=1.195] X-Spam-Score: 1.195 X-Spam-Level: * X-Archive-Number: 200602/103 X-Sequence-Number: 24113 Hello, one question: Is it possible to add or remove a column from a view without drop the view and recreate it? If one or more rules depend on a view, it's very hard to extend a view. I use the following procedure to extend a view: - drop depending rules - drop view - recreate view with additional column - recreate all rules Any help is welcomed! Thanks, Andreas Roth