Обсуждение: CREATE RULE _copy AS ON COPY TO ...

Поиск
Список
Период
Сортировка

CREATE RULE _copy AS ON COPY TO ...

От
Willy-Bas Loos
Дата:
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

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

От
Vibhor Kumar
Дата:
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