Re: [BUGS] INSTEAD rule bug? - Mailing list pgsql-general

From Dmitry Tkach
Subject Re: [BUGS] INSTEAD rule bug?
Date
Msg-id 3F142F8D.8020402@openratings.com
Whole thread Raw
In response to Re: [BUGS] INSTEAD rule bug?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [BUGS] INSTEAD rule bug?
List pgsql-general
Tom Lane wrote:

>Dmitry Tkach <dmitry@openratings.com> writes:
>
>
>>testdb=# create table test_view as select * from test;
>>SELECT
>>
>>
>
>That is not a view, it's only a static copy of the original table.
>
>            regards, tom lane
>
>
I know... That was a typo in my sql :-)
But for this example it doesn't matter - that view/table is only needed
to illustrate the rules behaviour on insert.
You can just replace 'table' with 'view' in that statement - the
behaviour of the insert is exactly the same anyway.

Dima


pgsql-general by date:

Previous
From: "Jay O'Connor"
Date:
Subject: Re: perfromance impact of vacuum
Next
From: Bruno Wolff III
Date:
Subject: Re: perfromance impact of vacuum