The following bug has been logged online:
Bug reference: 2437
Logged by: Anton Fedorov
Email address: datacompboy(at)mail(dot)ru
PostgreSQL version: 8.1.3-3
Operating system: debian linux
Description: Rules for COPY
Looks like COPY bypass rules 'ON INSERT INSTEAD'.
I think, COPY .. FROM ... should be equal to
INSERT INTO ... SELECT * FROM ...
and be catched by INSERT rule.
Otherwise, need to create new temporary table, load data into, INSERT ..
SELECT ..., DROP TABLE, while it seems strange.
pgsql-bugs by date
|Next:||From: YourSoft||Date: 2006-05-13 13:12:55|
|Subject: group by|
|Previous:||From: Paul Forgey||Date: 2006-05-12 21:12:03|
|Subject: BUG #2436: cannot --enable-thread-safety on -lpthread host|