[Info-Ingres] Dropping and creating views

#21

Paul Mason wrote:

Quote:

John Smedley wrote:

Just don't read the documentation for CREATE RULE :-)

rule_name

Specifies the name of the rule. Rules
cannot be defined against views, only against base tables.

If you don't mind me saying so, removing that restriction is a
rather massive new feature that deserves to get some attention.

Any idea which rev introduced it?

I just tested it in 2.0 and it worked.

I am flabbergasted.

I hope Mikey and I aren't the only ones who didn't know about this. :-(

--
Roy

UK Ingres User Association Conference 2010 will be on Tuesday June 8 2010
Go to http://www.iua.org.uk/join to get on the mailing list.

#22

22-dec-92 (andre) - Added support for creating rules on views

Hum, must have missed that one, I will log a doc bug.

John

-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Roy
Hann
Sent: 20 November 2009 11:22
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: Re: [Info-Ingres] Dropping and creating views

Paul Mason wrote:

Quote:

John Smedley wrote:

Just don't read the documentation for CREATE RULE :-)

rule_name

Specifies the name of the rule. Rules
cannot be defined against views, only against base tables.

If you don't mind me saying so, removing that restriction is a
rather massive new feature that deserves to get some attention.

Any idea which rev introduced it?

I just tested it in 2.0 and it worked.

I am flabbergasted.

I hope Mikey and I aren't the only ones who didn't know about this. :-(

--
Roy

UK Ingres User Association Conference 2010 will be on Tuesday June 8
2010
Go to http://www.iua.org.uk/join to get on the mailing list.

_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres

#23

John Smedley wrote:

Quote:

22-dec-92 (andre) - Added support for creating rules on views

Hum, must have missed that one, I will log a doc bug.

Good man.

1992 huh? So it's been possible for longer than I've had access to
what we used to call KME back then. Words fail me. (But I'm smiling.
This is like finding treasure buried in the garden.)

--
Roy

UK Ingres User Association Conference 2010 will be on Tuesday June 8 2010
Go to http://www.iua.org.uk/join to get on the mailing list.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

[Info-Ingres] Dropping and creating views

comp.databases.ingres comp.databases.ingres

Re: [Info-Ingres] Dropping and creating views - 11-20-2009 , 05:22 AM

Re: [Info-Ingres] Dropping and creating views - 11-20-2009 , 06:30 AM

Re: [Info-Ingres] Dropping and creating views - 11-20-2009 , 06:50 AM