Thread: Views update ?

Views update ?

From
LAMBEAU Bernard
Date:
Hi,

On the TODO list, if found the following information :
Automatically create rules on views so they are updateable, per SQL99

Does anyone already work on such a tool inside PostgreSQL ? I'm
interessed by giving some contribution to this task ... if you're
interessed also ?

Bernard


Re: Views update ?

From
Richard Huxton
Date:
LAMBEAU Bernard wrote:
> Hi,
> 
> On the TODO list, if found the following information :
> Automatically create rules on views so they are updateable, per SQL99
> 
> Does anyone already work on such a tool inside PostgreSQL ? I'm
> interessed by giving some contribution to this task ... if you're
> interessed also ?

I believe there is some work happening on this http://archives.postgresql.org/pgsql-hackers/2005-03/msg00671.php
http://archives.postgresql.org/pgsql-hackers/2005-03/msg01029.phphttp://www.oopsware.de/pgsql_viewupdate.html
 

I'm sure they'd be happy of any additional help/early testing. It's a 
feature that will be appreciated by many users.

--  Richard Huxton  Archonet Ltd


Re: Views update ?

From
Jaime Casanova
Date:
On 5/18/05, LAMBEAU Bernard <blambeau@gmail.com> wrote:
> Hi,
>
> On the TODO list, if found the following information :
> Automatically create rules on views so they are updateable, per SQL99
>
> Does anyone already work on such a tool inside PostgreSQL ? I'm
> interessed by giving some contribution to this task ... if you're
> interessed also ?
>
Hi Bernd and i, specialy Bernd, are working on this. Any help would be
appreciated.
This is the patch against current HEAD.

Have you talked with Bernd already? if not, i am emailing to tell him about you.

--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

Attachment

Re: Views update ?

From
LAMBEAU Bernard
Date:
Hi.

I have already read previous discussion in the archives about views
update. I have also taked a look on the patch code. I will try it as
soon as possible.

P.S. I'm a beginner in the postgresql development and I have many
things to learn before being able to give real help ... but I will
try.
P.S.2. I don't have talked with Bernd until now...

Regards
Bernard

On 5/22/05, Jaime Casanova <systemguards@gmail.com> wrote:
> On 5/18/05, LAMBEAU Bernard <blambeau@gmail.com> wrote:
> > Hi,
> >
> > On the TODO list, if found the following information :
> > Automatically create rules on views so they are updateable, per SQL99
> >
> > Does anyone already work on such a tool inside PostgreSQL ? I'm
> > interessed by giving some contribution to this task ... if you're
> > interessed also ?
> >
> Hi Bernd and i, specialy Bernd, are working on this. Any help would be
> appreciated.
> This is the patch against current HEAD.
>
> Have you talked with Bernd already? if not, i am emailing to tell him about you.
>
> --
> Atentamente,
> Jaime Casanova
> (DBA: DataBase Aniquilator ;)
>
>
>