Thread: CREATE RULE _copy AS ON COPY TO ...

Hi,

My ON INSERT rule won't go off when I copy into it.
Is there a way to COPY into a RULE?

I'm using 8.4 now. Also interested in 9.

Cheers,

WBL

--
"Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw

On Apr 11, 2011, at 11:56 PM, Willy-Bas Loos wrote:

> My ON INSERT rule won't go off when I copy into it.
> Is there a way to COPY into a RULE?

COPY Command does not respect rule on table, so please use trigger.

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.kumar@enterprisedb.com
Blog:http://vibhork.blogspot.com