Skip site navigation (1) Skip section navigation (2)

BUG #2437: Rules for COPY

From: "Anton Fedorov" <datacompboy(at)mail(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2437: Rules for COPY
Date: 2006-05-13 11:52:51
Message-ID: 200605131152.k4DBqp6b023058@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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
Details: 

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.

Responses

pgsql-bugs by date

Next:From: YourSoftDate: 2006-05-13 13:12:55
Subject: group by
Previous:From: Paul ForgeyDate: 2006-05-12 21:12:03
Subject: BUG #2436: cannot --enable-thread-safety on -lpthread host

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group