From: | Rob LoPresti <mooingyak(at)yahoo(dot)com> |
---|---|
To: | pgsql-docs(at)postgresql(dot)org |
Subject: | Views and rules section (link provided below) |
Date: | 2005-01-27 04:47:46 |
Message-ID: | 20050127044746.61144.qmail@web51604.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-01-27 14:47:28 | Re: Views and rules section (link provided below) |
Previous Message | Alvaro Herrera | 2005-01-25 01:26:56 | Re: A Question |