Hi, I've created an INSERT rule on a view but when I try to use the COPY command to import data into the view it fails with.
cannot copy to view "viewname" I can create a temporary table and COPY into the temporary table and then INSERT into the view by selecting from the temporary table. But that's sorta lame, especially because I don't want the front-end to care whether it's importing into a table or a view. Does anyone have any suggestions? Is there some reason why COPYing into views is disallowed or is there just an extra error check in the code that's getting in my way? If so, would the project be open to accepting a patch? Thanks for the work. Karl <[EMAIL PROTECTED]> Free Software: "You don't pay back, you pay forward." -- Robert A. Heinlein ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly