Postgres Pro
Downloads
Home   >   mailing lists

Re: create temp table in rule - Mailing list pgsql-sql

From Tom Lane
Subject Re: create temp table in rule
Date
Msg-id 18465.1145389989@sss.pgh.pa.us
Whole thread Raw
In response to create temp table in rule  (Ron Peterson <rpeterso@mtholyoke.edu>)
List pgsql-sql
Tree view 
Ron Peterson <rpeterso@mtholyoke.edu> writes:
> Is it possible to create a temporary table within a rule?

No, sorry.  From memory, rules only allow SELECT/INSERT/UPDATE/DELETE
plus NOTIFY (and there are restrictions on the latter).
        regards, tom lane

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Looking for some help with cascading updates...
Next
From: gurkan@resolution.com
Date:
Subject: Complex Informix OUTER