Thread: Does PG support updateable view?

Does PG support updateable view?

From
The Nice Spider
Date:
Which version of PG support updatable view?


Yahoo! FareChase - Search multiple travel sites in one click.

Re: Does PG support updateable view?

From
"A. Kretschmer"
Date:
am  13.11.2005, um 17:04:37 -0800 mailte The Nice Spider folgendes:
> Which version of PG support updatable view?

None. Updateable views are a 'TODO'.
http://www.postgresql.org/docs/faqs.TODO.html

You can use Rules instead:
http://www.varlena.com/varlena/GeneralBits/111.php, Issue 82-4


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

Re: Does PG support updateable view?

From
Bruce Momjian
Date:
The Nice Spider wrote:
> Which version of PG support updatable view?

You have to use rules to make views updatable, and all PG vesions
support those.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073