From: | "Jaime Casanova" <systemguards(at)gmail(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | josh(at)agliodbs(dot)com, "Stephan Szabo" <sszabo(at)megazone(dot)bigpanda(dot)com>, pgsql-hackers(at)postgresql(dot)org, "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com> |
Subject: | Updateable views was:(Re: [HACKERS] Proposal for SYNONYMS) |
Date: | 2006-03-10 03:37:31 |
Message-ID: | c2d9e70e0603091937k6f0cfe09w2cb604259df76ac9@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 3/9/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Josh Berkus <josh(at)agliodbs(dot)com> writes:
> > Eh? I thought that it was just syntatic sugar that was missing. I've
> > built lots of updatable views manually; I don't see what's difficult about
> > it.
>
> I think you'll find that corner cases like inserts involving nextval()
> don't work real well with a rule-based updatable view. But perhaps I'm
> just scarred by the many complaints we've had about rules. With a plain
> unconditional DO INSTEAD rule it might be OK ...
>
> regards, tom lane
>
the last time i talk with Bernd Helmle, he was preparing the code to
send to patches for discussion... that was two months ago...
the current code had problems with casts and i think with domains too...
i will contact with Bernd to know if he did some more work, if not i
can send to patches the latest path he sent me...
--
regards,
Jaime Casanova
"What they (MySQL) lose in usability, they gain back in benchmarks, and that's
all that matters: getting the wrong answer really fast."
Randal L. Schwartz
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2006-03-10 03:37:59 | Re: [COMMITTERS] pgsql: Remove Jan Wieck's name from |
Previous Message | Marc G. Fournier | 2006-03-10 03:36:53 | Re: [COMMITTERS] pgsql: Remove Jan Wieck's name from |