Re: [COMMITTERS] pgsql: WITH CHECK OPTION support for auto-updatable VIEWs - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: [COMMITTERS] pgsql: WITH CHECK OPTION support for auto-updatable VIEWs
Date
Msg-id 20130730002417.GC2706@tamriel.snowman.net
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: WITH CHECK OPTION support for auto-updatable VIEWs  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: [COMMITTERS] pgsql: WITH CHECK OPTION support for auto-updatable VIEWs
List pgsql-hackers
depesz,

* hubert depesz lubaczewski (depesz@depesz.com) wrote:
> On Mon, Jul 29, 2013 at 07:43:53PM -0400, Stephen Frost wrote:
> > * hubert depesz lubaczewski (depesz@depesz.com) wrote:
> > > create table some_data (id int4 primary key, payload text);
> > > create view first as select * from some_data where 0 = id % 2 with local check option;
> > > create view second as select * from first where 0 = id with local check option;
[...]
> the check is "0 = id % 3" - i.e. id has to be multiply of 3. Sorry if my
> way of writing conditionals is confusing.

Neither client that I use to read email with saw a '% 3' on the view
definition for 'second' in your original email (or as quoted above).
Still, I do see what you're talking about and will take a look.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: [COMMITTERS] pgsql: WITH CHECK OPTION support for auto-updatable VIEWs
Next
From: Amit Langote
Date:
Subject: Re: maintenance_work_mem and CREATE INDEX time