Creating a view: ERROR: rules on SELECT must have action INSTEAD SELECT

From: David Waddy <david(at)littleriver(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Creating a view: ERROR: rules on SELECT must have action INSTEAD SELECT
Date: 2010-03-19 11:57:25
Message-ID: 10c46bc21003190457k16d228bck36653796ee8bf1e8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I get the following error when trying to create a view with the
following trivial example.

SQL error:
ERROR: rules on SELECT must have action INSTEAD SELECT

In statement:
CREATE VIEW "nutrition"."test_view" AS SELECT 2 as two, 3 as three
INTO TEMP temp_table; SELECT *,two+three as five FROM temp_table;

If I rewrite the statement to maybe make more sense:

SQL error:

ERROR: temporary tables cannot specify a schema name

In statement:

SELECT 2 as two, 3 as three INTO TEMP nutrition.temp_table; CREATE
VIEW "nutrition.test_view" AS SELECT *,two+three as five FROM
nutrition.temp_table;

So the question is how do I use the powerful feature of temporary
tables with views? And if this is not possible, how do I do something
similar for optimization reasons (ie pretend "two+three as five" is
some very expensive operation and "two" and "three" were also
expensive operations)?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2010-03-19 13:15:52 Re: AIX postgresql error
Previous Message elekis 2010-03-19 09:22:47 Re: compile a program witn libpq64 (error LIBCMT.Lib...)