Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle

From: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
To: Zeugswetter Andreas OSB sIT <Andreas(dot)Zeugswetter(at)s-itsolutions(dot)at>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bernd Helmle <mailings(at)oopsware(dot)de>, Peter Eisentraut <peter_e(at)gmx(dot)net>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle
Date: 2009-01-26 16:00:37
Message-ID: 3073cc9b0901260800qc4211bdu20ff80b64b001248@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On Mon, Jan 26, 2009 at 6:48 AM, Zeugswetter Andreas OSB sIT
<Andreas(dot)Zeugswetter(at)s-itsolutions(dot)at> wrote:
>
>
> Is that why other db's only make views updateable, that are created
> "WITH CHECK OPTION" ? Should we also follow that path ?
>

no, the standard says that if the query expression is updatable the
view is updatable

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

In response to

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2009-01-26 19:41:06 pgsql: Allow extracting and parsing of reloptions from a bare pg_class
Previous Message Zeugswetter Andreas OSB sIT 2009-01-26 11:48:24 Re: [COMMITTERS] pgsql: Automatic view update rules Bernd Helmle

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2009-01-26 16:06:25 Re: mingw check hung
Previous Message Tom Lane 2009-01-26 15:58:32 Re: 8.4 release planning