| From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
|---|---|
| To: | yuezh(at)ccermail(dot)net |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: about view |
| Date: | 2003-05-08 14:55:45 |
| Message-ID: | 3EBA6FF1.A09FAA17@Yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
yuezh(at)ccermail(dot)net wrote:
>
> Still can not update views in postgresql ?
> Is it difficult to implement updating view ?
Yes, we have yet not implemented the automatic creation of INSERT,
UPDATE and DELETE rules for simple views.
AFAIK the SQL standard defines those updatable views only for simple,
one table views without subselects and so forth ... should be easy
enough to define those rewrite rules by hand.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2003-05-08 15:00:18 | Re: CIDR in pg_hba.conf |
| Previous Message | Tom Lane | 2003-05-08 14:13:39 | Re: CIDR in pg_hba.conf |