Read-Only Views?

Поиск
Список
Период
Сортировка
Искать

Read-Only Views?

От:
Naomi Walker <nwalker@eldocomp.com>
Дата:

I noticed in some (older) documentation that views were read-only?  Is this 
still the case?

Naomi


-------------------------------------------------------------------------------------------------------------------------
Naomi Walker                         Chief Information Officer
                                               Eldorado Computing, Inc.
nwalker@eldocomp.com           602-604-3100
-------------------------------------------------------------------------------------------------------------------------
Do not follow where the path may lead.  Go, instead and leave a trail.
-Robert Frost
-------------------------------------------------------------------------------------------------------------------------

-- CONFIDENTIALITY NOTICE --

This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email, and delete the message. Thank you.

Re: Read-Only Views?

От:
"scott.marlowe" <scott.marlowe@ihs.com>
Дата:
Yep.  by default views are not updateable in postgresql.  However, they 
can be made updateable by triggers.  Note that not all views are 
inherently updateable, just the simplest.  for instance how would you 
update:

create view bigview as select g1.id, t1.f1*t2.f2, t1.f3/t3.f4 from tabl1 
t1, table2 t2, table3 t3 where t1.id=t2.t1id and t1.id=t3.t1id

?

On Fri, 18 Jul 2003, Naomi Walker wrote:

> 
> I noticed in some (older) documentation that views were read-only?  Is this 
> still the case?
> 
> Naomi
> 
> 
> -------------------------------------------------------------------------------------------------------------------------
> Naomi Walker                         Chief Information Officer
>                                                Eldorado Computing, Inc.
> nwalker@eldocomp.com           602-604-3100
> -------------------------------------------------------------------------------------------------------------------------
> Do not follow where the path may lead.  Go, instead and leave a trail.
> -Robert Frost
> -------------------------------------------------------------------------------------------------------------------------
> 
> -- CONFIDENTIALITY NOTICE --
> 
> This message is intended for the sole use of the individual and entity to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the intended addressee, nor authorized to receive for the intended addressee, you are hereby notified that you may not use, copy, disclose or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email, and delete the message. Thank you.
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
> 

Re: Read-Only Views?

От:
Arguile <arguile@lucentstudios.com>
Дата:
On Fri, 2003-07-18 at 13:26, Naomi Walker wrote:
> I noticed in some (older) documentation that views were read-only?  Is this 
> still the case?

Yes, views are read-only unless you define rules for how they can be
inserted/updated/deleted from.

See these for how to create those rules:
http://developer.postgresql.org/docs/postgres/rules.html
http://developer.postgresql.org/docs/postgres/rules-update.html

FAQ