X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BA38E3A5DAE for ; Thu, 27 Jan 2005 04:47:58 +0000 (GMT) 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 87964-07 for ; Thu, 27 Jan 2005 04:47:56 +0000 (GMT) Received: from web51604.mail.yahoo.com (web51604.mail.yahoo.com [206.190.38.209]) by svr1.postgresql.org (Postfix) with SMTP id D20FE3A5D7F for ; Thu, 27 Jan 2005 04:47:54 +0000 (GMT) Received: (qmail 61146 invoked by uid 60001); 27 Jan 2005 04:47:46 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=n7EeJaGyilUKtXXP9/bxhntD1dNTSpSjztp0uxWJdI/MuA99dTliBpDgxcwSTcNgVdvkzAfIAGxU+60VI9lqj8vLqdiHls6RbGKDuoX5KfanR+/EY9qQL7jd2wlKINAr+YlFyYSib9Gkp2xoCNou8rv1OWh7bRHij63qbi9X8XI= ; Message-ID: <20050127044746.61144.qmail@web51604.mail.yahoo.com> Received: from [24.193.108.52] by web51604.mail.yahoo.com via HTTP; Wed, 26 Jan 2005 20:47:46 PST Date: Wed, 26 Jan 2005 20:47:46 -0800 (PST) From: Rob LoPresti Subject: Views and rules section (link provided below) To: pgsql-docs@postgresql.org 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.636 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200501/58 X-Sequence-Number: 2817 On the page: http://borg.postgresql.org/docs/8.0/static/rules-views.html Is the text (very close to the top): --------- Views in PostgreSQL are implemented using the rule system. In fact, there is essentially no difference between CREATE VIEW myview AS SELECT * FROM mytab; compared against the two commands CREATE TABLE myview (same column list as mytab); CREATE RULE "_RETURN" AS ON SELECT TO myview DO INSTEAD SELECT * FROM mytab; ---------- I did this the second way (actually using 7.3.4, but the documentation is nearly identical), and as I'm still a little new to postgres, I created my table with foreign key restraints, which works, but causes problems if you want to drop the view. I searched for a workaround on google, and found the following bug report: http://archives.postgresql.org/pgsql-bugs/2003-09/msg00134.php which received this reply: http://archives.postgresql.org/pgsql-bugs/2003-09/msg00135.php If it's unsupported, okay, no big deal, I won't do that anymore, but the exact detail that Tom Lane's response says is unsupported is the same as the above example taken straight from the manual. I don't claim to know the best way to rewrite the section, but I'd like to put forward the suggestion that it not use any unsupported examples. Thank you for your consideration, -Rob __________________________________ Do you Yahoo!? Yahoo! Mail - now with 250MB free storage. Learn more. http://info.mail.yahoo.com/mail_250