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

From: Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com>
To: Willy-Bas Loos <willybas(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: CREATE RULE _copy AS ON COPY TO ...
Date: 2011-04-11 21:10:47
Message-ID: CEF41C37-C0D9-457F-B639-D9BA99E43645@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joel Stevenson 2011-04-11 22:19:23 Column storage (EXTERNAL/EXTENDED) settings for bytea/text column
Previous Message Pavel Stehule 2011-04-11 19:33:14 Re: Howto use "COPY FROM" with the native API?