On Mon, Dec 22, 2008 at 8:53 AM, Bernd Helmle <mailings@oopsware.de> wrote:
> --On Mittwoch, November 26, 2008 10:54:01 +0100 Bernd Helmle
> <mailings@oopsware.de> wrote:
>
> Okay, i've finally managed to create an updated version with (hopefully) all
> issues mentioned by Robert adressed.
>
Hi Bernd,
1) i found a crash type bug, try this:
create table foo (
id integer not null primary key,
name varchar(30)
) with oids;
create view foo_view as select oid, * from foo;
with this you will get an error like this one:
ERROR: RETURNING list's entry 1 has different type from column "oid"
but if you make this:
alter table foo add column description text;
create view foo_view as select oid, * from foo;
then, the server crash.
STATEMENT: create or replace view v_foo as select oid, * from foo;
LOG: server process (PID 16320) was terminated by signal 11: Segmentation fault
LOG: terminating any other active server processes
maybe the better solution is to not allow such a view to be updatable
2) Another less important bug, the WITH CHECK OPTION is accepted even
when that functionality is not implemented.
updatable_views=# create or replace view v2 as select * from foo where
id < 10 with check option;
NOTICE: CREATE VIEW will create implicit INSERT/UPDATE/DELETE rules
CREATE VIEW
3) one final point: seems like you'll have to update the rules
regression test (attached the regression.diffs)
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157